Multiple Plot Shading in Line Graphs

[Guest]

Hi,

I was trying to create a line graph with multple colors in the plot area
depending on what the line graph does. i.e. if I were to plot the price of a
stock whenever the stock was in an upward trend the background color would be
different than if the stock were in a downward trend. I've figured out a
cheap way where I just create boxes fill them with color and then place them
behind the graph but was wondering if there were an easier way.

Any help is appreciated. Thanks.

 

[Guest]

You could try making a conditional chart, where the charts looks differently
depending on criteria (e.g. green for upward slopes, red for downward
slopes). Ideas you can find for instance at:
www.andypope.info/charts.htm
www.peltiertech.com/Excel/Charts/format.html#CondChart
GL,
Henk