Hello all,
I have a spreadsheet that has 3 Pivot Tables and associated Pivot Chart that are tied to the same data source. I have several Slicers that are attached to all 3 charts. The charts are Stacked Area charts. Periodically when I refresh the data or use the Slicers the Fill Color of the data series in the charts get 'corrupted'. What I see is that most if not all of the data series in the charts turn blue, even though the configured color in the Format Data Series says the series should be a different color.
In the image attached I'm trying to show what I see. The highlighted series is set to be an Automatic color and it should be orange (seen on the right), but the series in the chart (which is selected) is blue along with many of the other series. The series are all supposed to be different colors.
The way I can correct this is to select the series and then toggle the Fill setting between Pattern Fill and Automatic. Doing this somehow "refreshes" something and the color in the chart changes to the correctly configured color.
I am dumbfounded by this, and it costs a ton of time to correct. Any thoughts or ideas would be greatly appreciated. Is this a possible bug I should report?
Capture.PNG
Thanks for any help
Bookmarks