Chart Area
 

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.
--
Thanks,
Nikki

Chart Area
 

Nikki -

Here's one way:

http://peltiertech.com/Excel/ChartsH...orizBands.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nikki" wrote in message
...
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.
--
Thanks,
Nikki

Chart Area
 

--
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


"Jon Peltier" wrote:

Nikki -

Here's one way:

http://peltiertech.com/Excel/ChartsH...orizBands.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nikki" wrote in message
...
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.
--
Thanks,
Nikki