expand/collapse

Hi! I have an obscure request. I do this thing where I like to use a pivot chart (with the expand/collapse button) as a fast way to "expand all" or "collapse all" for a related pivot table. Really, all I need is the Expand/Collapse button from the chart, so I always shrink the chart so I can...

I need a VBA Button that will toggle between "Expand All" and "Callapse All" for the groupings on a given worksheet. Any help would be appreciated. Thanks!!!

Hello I have created some buttons that have macros assigned to them to expand/collapse grouped rows on click. There are two levels of grouped rows. One level, which has its own Expand All button, will expand/collapse all groups. The other level is just an Expand button which will...

Hi folks, Is there any way I can expand/collapse Pivot chart like we do with pivot table button in Excel 2010. Let me explain. I have 2 column Cities and Neighborhood. In the pivot chart, it is showing me the the count of neighborhoods in each city. i want users to click on any specific city...