Cannot saved Changes to Pivot Charts

Copper Contributor

Hi Everyone, I have built a great dashboard for my business. I have created Pivot Tables and from the tables I have created Pivot Charts. My only challenge is inability of my Workbook to save changes I've made to my charts. I want negative value to be inverted and in red fill (bar charts) and the positive values in green. Every time I make these changes and save but when I open, my charts revert to default with negative values in white fill and positive in green. This is annoying. Any help??

 

2 Replies

Johnbosco,

 

I believe that is a real bug,

 

Detlef,

 

I guess that is old issue appears since PowerChart keeps all customization in the cache (in opposite to regular chart). As soon as you lost cache you lost your customization.

 

First I googled about that is https://peltiertech.com/pivot-chart-formatting-changes/, but there are definitely more discussions of the topic.