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!
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.
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.
