Hello,

I have five teams (let's say teams 1-5) and I've created 100% stacked bar chart where I'm tracking six different states (the states are New, Approved, Ready, In Progress, Test Complete, Done). At any given time, one or more of the states will not be prevalent, but I want to assign colors to each state with the bar chart. So for example Done will always be green, New will always be Red and so forth. How do I maintain these colors and their association with a state? If the chart does not have any one of the states at any given time (for example no team has anything in Approved) the colors all change.

I'm looking for a nice VBA solution to be able to run on each PivotChart I have to format the state colors in a consistent manner.

Thanks!
Dan