Chart Area

[Nikki]

I know I have done before, but can't seem to remember how to get doable
results.

I want to be able to have 3 different background colors on a chart Green,
Yellow, and Red. Then 3 columns that are used to show different numbers. The
background colors are to help the viewer see quickly if their numbers are in
a valid range.

 

[Jon Peltier]

Nikki -

Here's one way:

http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html

- Jon

 

[Nikki]

--
Thanks for helping me find a solution- I think this is the one I happened
upon last time I did it- so you have helped me twice.
Thanks,
Nikki

Nikki -

Here's one way:

http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html

- Jon