What if you need more than four PowerPivot pivot charts tied to the same set of slicers? This episode of the MrExcel netcast will show you how.
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
Transcript of the video:
MrExcel podcast is sponsored by “Easy-XL”!
PowerPivot for the Data Analyst chapter 9 - 5 or More Pivots!
OK well, in the PowerPivot drop-down here, they offer the opportunity to create up to 4 charts, but what if you need more than that?
So here I have a report, a couple of slicers driving 4 different charts, but I need to create some 5th or 6th report.
Watch how easy this is to do, I'll go to 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, we’ll 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 going to come here to PivotTable 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 these slicers.
So, as I choose from the slicers, the 4 original pivot tables update, but my 5th pivot table will update as well, a very, very cool way to go.
So you're not really limited to 4 pivot tables or pivot charts at all.
You can go to 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 want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
PowerPivot for the Data Analyst chapter 9 - 5 or More Pivots!
OK well, in the PowerPivot drop-down here, they offer the opportunity to create up to 4 charts, but what if you need more than that?
So here I have a report, a couple of slicers driving 4 different charts, but I need to create some 5th or 6th report.
Watch how easy this is to do, I'll go to 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, we’ll 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 going to come here to PivotTable 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 these slicers.
So, as I choose from the slicers, the 4 original pivot tables update, but my 5th pivot table will update as well, a very, very cool way to go.
So you're not really limited to 4 pivot tables or pivot charts at all.
You can go to 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 want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
