Forum

Notifications
Clear all

Expand/Collapse Button

4 Posts
4 Users
0 Reactions
249 Views
(@hmillikin)
Posts: 5
Active Member
Topic starter
 

Hi...

I am running excel 2016 and I am having a problem with pivot charts. I am wanting to use the expand/collapse buttons in pivot charts.

I have dates along the horizontal axis (Month, Quarter, Year) that I wish to expand/collapse. I have a couple data fields along the vertical axis in the Values field box. The expand/collapse button on the pivot chart (lower right of chart) works fine. However, when I add a measure to the Values field box, the expand/collapse button on the pivot chart no longer works. (Actually, if I expand the dates on the pivot table. I can use the button to collapse the dates, but it will not expand).

Hoping you might have a solution to this issue.

kind regards,

Harry

 
Posted : 22/05/2018 5:20 pm
(@mynda)
Posts: 4761
Member Admin
 

Sounds like a bug, Harry. Can you please share a sample file so I can reproduce the issue and report to Microsoft if it is a bug.

Thanks,

Mynda

 
Posted : 22/05/2018 7:07 pm
(@kasia_m)
Posts: 5
Active Member
 

Hi everyone,

I have a question remotely related to this.

I also want to use expand/collapse buttons in pivot charts in my dashboard. I have around 16 of them altogether and they use the same grouping. Is there a way to sync expand / collapse all of them? Something similar to what slicers do for filters for all connected pivots.

I tried recording a macro (unfortunately I'm not advanced in VBA) but for some reason expanding and collapsing is not being recorded).

Thank you in advance!
Kasia

 
Posted : 09/02/2023 6:05 am
(@jstewart)
Posts: 216
Estimable Member
 

Unfortunately, I don't believe that is within the capabilities of Excel.

 
Posted : 09/02/2023 1:47 pm
Share: