Creating visible Pass / Fail areas
 

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.

Creating visible Pass / Fail areas
 

Hi,

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

Cheers
Andy

K.P.D wrote:
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, Microsoft MVP - Excel
http://www.andypope.info