Learn Excel - Many Pivot Charts: Podcast #1346

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Feb 22, 2011.
Today's Question, from Joe: "How can I arrange many Pivot Charts on a worksheet - without the underlying Pivot Tables getting in the way of my Charts?" Bill answers this by setting up a Dashboard Sheet within Episode #1346. Learn Excel from MrExcel!
maxresdefault.jpg


Transcript of the video:
MrExcel Podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast episode 1346: Pivot Charts.
I love PivotTables but you hardly ever hear me talking about Pivot Charts.
Today's question from Joe is all about Pivot Charts.
Joe wants to get several Pivot charts all on one sheet and he says that as he pivots the data the PivotTable gets wider and it runs into the other Pivot table and that it doesn't let him update the PivotTable.
So typically if we do Insert Pivot Chart, click OK.
What we get is, we get a report.
So, let's just do region, product, revenue.
We get a report where the PivotTable and the pivot chart are on the same sheet and that is the default way that they make their pivot charts but that doesn't have to be where the pivot chart lives.
You can choose this chart and then go to move chart and say that I want this to be a chart in a new sheet or even an object in some other sheet.
So I have a dashboard here, click OK.
I can now drag that down a little bit lower and you'll see here that I actually, on this workbook have created several different PivotTables and taken the pivot chart for each of those PivotTables and used that method to move them where they are all here on the dashboard sheet.
I think this is a nice way to create a dashboard; you don't have to worry about the PivotTable getting smaller or larger as you change the items on the pivot chart.
The pivot charts live out here on their own.
The pivot charts of course are going to stay the same size.
They might get scrunched down or something like that but in general this is a good way to go.
So rather than be forced to live with the pivot chart right next to the PivotTable, you can take that pivot chart and move it, create everything on its own dashboard.
A much friendlier way rather than living with the PivotTable and chart on the same sheet.
I want to thank Joe for sending that question in and I want to thank you for stopping by.
I will see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top