software

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

quot;ask72883quot; wrote:

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