Background Color(S!!!!!)
 

I need help creating a line graph that will have multiple background colors.
The basic purpose of this is to be able to look at a line graph and see how
the performance metric is doing based upon which color background the line is
sitting on. I need to have 5 colors that have scales that need to be able to
change dynamically. Is there a way to do this in Excel? I know how to change
the entire background to 1 color, but need to be able to partition off
sections of the graph into different colors.

Background Color(S!!!!!)
 

I've finally rewritten and posted a page that shows how to accomplish this
background shading:

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

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


"Mackenzie" wrote in message
...
I need help creating a line graph that will have multiple background
colors.
The basic purpose of this is to be able to look at a line graph and see
how
the performance metric is doing based upon which color background the line
is
sitting on. I need to have 5 colors that have scales that need to be able
to
change dynamically. Is there a way to do this in Excel? I know how to
change
the entire background to 1 color, but need to be able to partition off
sections of the graph into different colors.