How to change the color of chart bar using a variable without VBA?

[igbaria]

Hi, I'm new here. I have been looking for a solution in this situation: I want to change the color of bars in a bar chart. For example, if I put the number 1 in cell A1 the color will be red, if I pu the number 2 in the cell A1 the color will be green, etc.. I'd like to do that without VBA. There is a solution?

THX

 

[Steve=True]

Hi Igbaria,

Check out this post that explains with a real world example on with an XY scatter chart, but it will also work for a bar chart:
how-to-plot-building-wall-ur-value-in-an-excel-xy-scatter-chart

Here is a post that uses a bubble chart, but the same concepts work for a bar chart:
dynamically-change-excel-bubble-chart-colors

Let me know if it helps.

Steve=True