| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add colored horizontal band to
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to add colored horizontal line on chart to show cutoff level | Charts and Charting in Excel | |||
| how to produce horizontal line chart of point est & 95% ci's | Charts and Charting in Excel | |||
| Horizontal lines in waterfall chart | Charts and Charting in Excel | |||
| SUMIF cell is colored | Excel Discussion (Misc queries) | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
Threaded Mode
