AndrewKent
Well-known Member
- Joined
- Jul 26, 2006
- Messages
- 889
Hi there,
I'm aware that there is an issue in Excel whereby using Slicers to filter your pivot table/chart will cause the formatting to reset to the default. I am experiencing this issue however I am noticing some odd behaviour.
My slicers control pivot charts across multiple tabs. If I open each tab and scroll up/down (basically so I have viewed each chart) then when I use my slicers the formatting is maintained. If I don't do this, the formatting resets to the default.
What would be considered a good workaround for maintaining formatting on Pivot Charts?
Andy
I'm aware that there is an issue in Excel whereby using Slicers to filter your pivot table/chart will cause the formatting to reset to the default. I am experiencing this issue however I am noticing some odd behaviour.
My slicers control pivot charts across multiple tabs. If I open each tab and scroll up/down (basically so I have viewed each chart) then when I use my slicers the formatting is maintained. If I don't do this, the formatting resets to the default.
What would be considered a good workaround for maintaining formatting on Pivot Charts?
Andy
