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

Scott wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info