View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ask72883
 
Posts: n/a
Default Multiple Plot Shading in Line Graphs

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.