I have a bar chart that functions as a schedule.

I want to do is be able to change the color of a bar series through a drop down (or through a text field within a cell). I don't want conditional formatting based on the value. All I would want is that somewhere outside the chart I have a drop down and when I change the drop down it will change all the red bars to blue or green or yellow or whatever color is selected.

Is this possible?

Example.PNG