Fixed multi-color background!

[Os]

Can anyone help with this:
I need to be able to highlight my chart background as (in
rows from top to bottom):
Red, Yellow, Green, Yellow, and Red. So I can have my
Line chart run through it. I have only one data series
(values) that run on 16 columns. I've tried to hilite it,
but Excel will only hilite the entire background (plot
area) at once.
Any help is highly appreciated.

Thanks.

 

[Andy Pope]

Hi,

The multiple coloured background can be created by using a dummy
dataseries. For your chart you would use a stacked column.

Have a look a the technique shown by Jon in his example.
http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html

Cheers
Andy