Coloring the scales of a chart
 

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?

Coloring the scales of a chart
 

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Paul H" wrote in message
...
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?

Coloring the scales of a chart
 

"Paul H" wrote:

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?