I have a bar chart that is tied to some data that changes quarter to quarter. I have the data set up to sort automatically.
I would like it so that, for example, the bar for ‘City’ is is always purple and the bar for ‘street’ is always blue and all other bars are green.
The issue is, when the data sorts, the colors don’t stay with what is set. IE the top is always purple regardless of if it is city, street, or other category unless I manually change it.
If it helps, my data automatically sorts largest to smallest based on the second column, which is the counts.
I appreciate any insight.
