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

[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.

 

[Andy Pope]

Hi,

The simplest way is to use 2 data series. One for the red and one for
the blue data. A formula based on A2.
Have a look at Jon's examples for conditional charts.

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy