Chart Formatting

[Kerry]

Hi

Am I able to apply conditional formatting to a bargraph?
I would like any bars representing the value <=3 to show
as red, any others in green please.

I am familiar will macros and VBA - is this the only route?

Thank you for your time
Kerry.

 

[Andy Pope]

Hi Kerry,

You can create conditional charts by using extra data series.
Check Jon's examples
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[Kerry]

Fantastic - it works a treat - thank you very much.

Kerry