How to create a slicer controlling several pivot chart located in 4 workbooks « Chandoo.org - Learn Excel & Charting Online

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

(4 posts) (2 voices)

Tags:

tonio71

Member
Joined: Sep '12
Posts: 2

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

Posted 8 months ago #
Luke M

Excel Ninja
Joined: Nov '10
Posts: 4,278

Check out Debra's article here:
http://blog.contextures.com/archives/2011/03/07/filter-multiple-pivot-tables-with-excel-2010-slicers/

Posted 8 months ago #
tonio71

Member
Joined: Sep '12
Posts: 2

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

Posted 8 months ago #
Luke M

Excel Ninja
Joined: Nov '10
Posts: 4,278

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

Posted 8 months ago #