simple chart change bar colour if A2 = ... etc

  • Thread starter Thread starter fitful_thought
  • Start date Start date
F

fitful_thought

Making a very simple chart from the data in cells A1, A2 and A3.
A1 contains the date.
A2 contains either a 0 or a 1.
A3 contains a dollar amount.

Can I get Excel to change the bar colour based on the value in A2?
If A2 = 0 bar colour = red
if A2 = 1 bar colour = blue.
 
Back
Top