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.

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
http://www.peltiertech.com/Excel/Cha...html#CondChart
GL,
Henk

"ask72883" wrote:

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.