July 24, 2014
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.
July 16, 2010
September 1, 2022
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!