Coloring the scales of a chart

[Guest]

I would like to make a line graph that is colored between the horozontal
lines I specify i.e.

1.344 Green Area

Between .525 and 1.343 Yellow
Between -.290 and .525 Pink
< -.300 Red

If the plot point is .750 it would be in the Yellow area

All points will fall between these brackets. How do I color the areas of
the chart?

 

[Andy Pope]

Hi,

Have a look at Jon's page on color banding
http://peltiertech.com/Excel/Charts/NewStuff.html#HorizBands

Cheers
Andy

 

[Guest]

I would like to make a line graph that is colored between the horozontal
lines I specify i.e.

Between .525 and 1.343 Yellow
Between -.290 and .525 Pink
< -.300 Red

If the plot point is .750 it would be in the Yellow area

All points will fall between these brackets. How do I color the areas of
the chart?