Maintaining consistent colours for series in Pivot Charts

[tanababa]

Hi

How can I maintain the same colour for each series in a pivot chart, when displayed alone or with other series as I change my slicers choices?

Thank you,

Tamir

Capture.PNG

[golfboy7]

Hi Tanababa,

Generally speaking, Excel pivot charts struggle maintaining formatting when you make changes to the pivot table (filtering...sorting...etc). I think many users would say it's a crap-shoot, sometimes the formatting is maintained, other times it is not.

For my experience, I have had some success when I apply the following methodology/follow these steps rigorously:

1. Create the Pivot table and chart (do not create slicers yet)
2. Make all formatting changes now - color, number formatting...etc
3. Now create your slicers/add filters...etc

For me, this has worked almost every time. Logically, it would seem that Excel has some sort of caching action that captures your formatting options and applies to all filtered/sorted groups, but this action doesn't seem to hold if you have already filtered/sorted before you add the formatting. Doesn't make a lot of sense to me but again, in my experience, this is how I have found success.

Hope this is helpful.

gb7

[tanababa]

Hi gb7,

Thank you for the guidelines.

However, in my case, it does not work.

Thank you kindly,

Tamir