Background Color(S!!!!!)

[Guest]

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.

 

[Jon Peltier]

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

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

- Jon