Pivot Table Expand / Collapse All

[Anonymous]

Is there any way for collapsing and expanding the levels in a pivot table in their entirity without having to right click and then expand/collapse all?

Thanks

[thomaslg_wq]

You do not need the print screens as it is explained : in a few words ==> deal with bookmarks

[ramasaisaksoft]

If possible ,instead  of Macros

simply put 2 charts in a Container

1 is Expanded manner

2nd  is Collapsed manner

[maxime66]

Hi Kevin,

My Hide/Unhide solution below don't satisfy you neither ?