- last edited on
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??
01-29-2018 10:30 AM
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.