Conditional format of a bar chart

[RobSA]

Hi Folks,


I would like to know if it possible to have conditional formating on a bar chart ?


I have developed a bar chart that has a pass requirement of 95%. If the implementation of the process achieves the pass requirement of 95% and greater the bar remains the colour it is.


If however the mark is not achieved and is 94.99% and less the the specific bar in the chart will turn red.


I would be most appreciative of your help.


Regards

Rob

 

[bobhc]

RobSA this link should sort you out

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

 

[Montrey]

You basically have to make multiple series with if statements.