Hello all,
I have a few similar pivots that run on the same raw data and measure slightly different things.
For example, let's say I have stores in 10 cities and one pivot shows the sales of socks in each city per month.
Another pivot shows the sales of shirts in each city per month.
I use pivot charts to produce bar charts that show how the sales of socks and shirts breakdown throughout cities per month (the horizontal axis show months).

However, socks were sold in all 10 cities but shirts were only sold in 8.

So, the two graphs will have different color codings for the cities.

Is there a way to keep the color coding consistent for all the graphs? e.g. a city that is colored blue in one graph will be blue in another?

Also, is there a way to do so for pivots built in a similar way, but from different raw data sets?

Thanks for your help!