- Goal: I have some reports im making over differing time frames, for example I have two bar charts representing our sales per state per week, and our sales per state per month. I have it grouping by state so each bar in the chart is a different state and color, however I would like to be able to keep the same colors for each state between the week and month charts so that its easier to compare them. Is there anyway to do this without having to manually set the color for every state? which is not only tedious but problematic as I can only map states that exist in the report, if we were to sell in a new state then it would then automatically be assigned different colors between the charts, making it so the charts need constant monitoring. I was hoping there is some way to sync the coloring between these two charts. It seems like this would be a fairly common use case so I'm hopping I'm missing something somewhere.
Oh also I'm using the new beta version of the chart if that helps.
All help is appreciated!
or a programmatic way to set them