Cannot saved Changes to Pivot Charts

Occasional Visitor

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



I believe that is a real bug,





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, but there are definitely more discussions of the topic.