PowerPivot 2010 offers the opportunity to create up to 4 Charts from your data . . . but what if you need to move beyond that to 5 or more Charts? In Episode #1306, Bill shows us how to move into the "More Than Four" dimension.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Power Pivot for the Data Analyst-Chapter 9: Five Or More Pivots.
Okay, well, in the power pivot drop-down here, they offer the opportunity to create up to four charts.
But what if you need more than that?
So, here I have a report.
A couple of slicers driving for different charts but I need to create some fifth or sixth report.
Watch how easy this is to do.
I'll go to Pivot Table > Pivot Table, and I say I want to create this on an existing worksheet.
Alright, and the existing worksheet will be down here below my data.
Click the reference button.
Click Ok.
Click Ok.
Alright, and so we have a field list here.
We build a nice little report mail.
Do division and revenue.
Ok, so we now have that report.
But I need that report to be hooked up to the existing slicers.
So, we're gonna come here to pivot table options.
There's a insert slicer button.
I don't want to use that button.
I want to go to the drop-down and say that I want to do slicer connections.
and say that this new Pivot Table is tied to these existing slicers.
click OK.
And now, I have a 5th Pivot Table that is controlled by the slicers.
So, as I choose from the slicers, the four original Pivot Tables update.
But my fifth pivot table will update as well.
A very, very, cool way to go.
So, you're not really limited to four pivot tables or fifth, Pivot charts at all.
You can build as many as you want.
However, anything beyond that original set, you need to hook those slicers up manually using the slicer connections.
Well, I wanna thank you for stopping bye.
See you next time for another netcast from MrExcel.
Power Pivot for the Data Analyst-Chapter 9: Five Or More Pivots.
Okay, well, in the power pivot drop-down here, they offer the opportunity to create up to four charts.
But what if you need more than that?
So, here I have a report.
A couple of slicers driving for different charts but I need to create some fifth or sixth report.
Watch how easy this is to do.
I'll go to Pivot Table > Pivot Table, and I say I want to create this on an existing worksheet.
Alright, and the existing worksheet will be down here below my data.
Click the reference button.
Click Ok.
Click Ok.
Alright, and so we have a field list here.
We build a nice little report mail.
Do division and revenue.
Ok, so we now have that report.
But I need that report to be hooked up to the existing slicers.
So, we're gonna come here to pivot table options.
There's a insert slicer button.
I don't want to use that button.
I want to go to the drop-down and say that I want to do slicer connections.
and say that this new Pivot Table is tied to these existing slicers.
click OK.
And now, I have a 5th Pivot Table that is controlled by the slicers.
So, as I choose from the slicers, the four original Pivot Tables update.
But my fifth pivot table will update as well.
A very, very, cool way to go.
So, you're not really limited to four pivot tables or fifth, Pivot charts at all.
You can build as many as you want.
However, anything beyond that original set, you need to hook those slicers up manually using the slicer connections.
Well, I wanna thank you for stopping bye.
See you next time for another netcast from MrExcel.
