Add colored horizontal band to

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you make a chart with right angles only? 12
how to add a horizontal benchmark value line in a column chart? 1
Dividing a chart with a horizontal line 2
need to add colored horizontal line on chart to show cutoff level 1
How do I use a single cell value to chart a horizontal line in Exc 9
Assign data series to primary axis 1
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Add line to horizontal bar chart 1

Top