Creating visible Pass / Fail areas

[K.P.D]

I'm creating a Column chart and I would like to be able to format it so that
from 0 to 69.99 is red for the fail area, 70 - 79.99 is yellow, 80-89.99 is
blue, 90-94.99 is dark green, and 95-100 is light green.

How can I accomplish this? I know it was possible in previous editions.

 

[Andy Pope]

Hi,

You should be able to use the conditional chart approach of using
multiple series.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy