M
Michael Waters
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
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