Hello,
I have a spreadsheed that has a data page,and then
various charts based on the data. Each chart has a safe
or ideal zone. I would like to know if there is a way to
change the colors of hte chart so that the unsafe area is
red, and the safe area is green. I had thought about
using a patern shading with 2 colors. This would work if
teh idea range was always in the middle, but on some
charts the chart may go from 1 to 50 with the ideal range
being 20-30. If anyone has any suggestions please let me
know.

Thanks,
Mike Waters

Hi
have a look at
http://peltiertech.com/Excel/Charts/....html#VertBand

--
Regards
Frank Kabel
Frankfurt, Germany

"Michael Waters" <(E-Mail Removed)> schrieb im Newsbeitrag
news:597101c42d3a$348b1620$(E-Mail Removed)...
> Hello,
> I have a spreadsheed that has a data page,and then
> various charts based on the data. Each chart has a safe
> or ideal zone. I would like to know if there is a way to
> change the colors of hte chart so that the unsafe area is
> red, and the safe area is green. I had thought about
> using a patern shading with 2 colors. This would work if
> teh idea range was always in the middle, but on some
> charts the chart may go from 1 to 50 with the ideal range
> being 20-30. If anyone has any suggestions please let me
> know.
>
> Thanks,
> Mike Waters
>