How to create a slicer controlling several pivot chart located in 4 workbooks

[tonio71]

Hi,

I have created in one excel spreadsheet five pivot charts located in 5 worksheet. Then, I moved all the charts to one worksheet How can I use one slicer on that page to control all the pivot charts??? Many thanks

 

[Luke M]

Check out Debra's article here:

http://blog.contextures.com/archives/2011/03/07/filter-multiple-pivot-tables-with-excel-2010-slicers/

 

[tonio71]

Thanks, I'll check it out. It looks good at a first glance

 

[Luke M]

Glad to help out. Let us know if you have any further questions.