I have several bar chart data sets based on race. I would like to keep a uniform color attached to each racial group regardless of where the bar appears on the chart. For example, on one chart "Black" may be in first position, while on another chart "Black" would be in third position (based on numerical ranking). In both of these scenarios, I want "Black" to have a blue fill. However, whenever I shift the column position, it appears to adopt the "color" for that position... i.e. "Black" will be blue in position one, but purple in position three.
Is there any way to tie a fill color to a label or do I have to manually change the color every time? I have 100 charts to do and that would be MURDER!