Add colored horizontal band to

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a line chart with two set of data (1995 and 1996). The months are
along the bottom. I have added horizontal lines for the average value for
each year.
What I'd like to do, however, is divide the background into different colors
(ie below a certain amount is good, above is average, and into the next level
is bad).
I have found references on adding a colored vertical line, but nothing on a
horizontal - maybe because it is straight forward, but I can't figure it out.
Thanks.
 
Hi,

Add 3 extra data series to the chart. Plot these as stacked column
chart. Format the Gap width to be zero.
You will need to set the maximum value of the Y axis in order to stop
the auto scale leaving a clear space at the top of the columns.

Cheers
Andy
 
Back
Top