Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() Hi all, Using MS Excel 2003, I want to create a chart that has coloured horizontal bands as a background with the data lines on top of these bands. E.g. If all of my y-axis values will be in the range 0-30, I'd like to split the background into 3 horizontal stripes such that: 0 <=10 is coloured gold 10<=20 is coloured silver 20<=30 is coloured bronze On top of these stripes are my actual data lines. It seems like it -should- be possible, but I'm just too dense to figure it out. Any ideas please? Thanks. -- robotmannick ------------------------------------------------------------------------ robotmannick's Profile: http://www.excelforum.com/member.php...o&userid=35588 View this thread: http://www.excelforum.com/showthread...hreadid=553533 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying certain coloured cell | Excel Worksheet Functions | |||
Insert horizontal line/single cell in Excel? | Excel Discussion (Misc queries) | |||
how do i copy only the coloured filled rows in excel to new sheet | Excel Worksheet Functions | |||
Using data from coloured cells in a chart | Excel Worksheet Functions | |||
how to produce horizontal line chart of point est & 95% ci's | Charts and Charting in Excel |