Changing bar graph colours according to value

[Guest]

Is there any way to have the colours of the bars in a bar graph change
according to value?

 

[Andy Pope]

Hi,

Have a look at Jon's example.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy