LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
robotmannick
 
Posts: n/a
Default Coloured horizontal stripes


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying certain coloured cell fomula problems Excel Worksheet Functions 9 May 29th 06 08:08 PM
Insert horizontal line/single cell in Excel? CLM Excel Discussion (Misc queries) 1 January 10th 06 09:09 PM
how do i copy only the coloured filled rows in excel to new sheet Kate at work Excel Worksheet Functions 2 January 4th 06 05:10 AM
Using data from coloured cells in a chart Mikey9131 Excel Worksheet Functions 1 November 26th 05 08:08 PM
how to produce horizontal line chart of point est & 95% ci's w98user Charts and Charting in Excel 2 November 9th 05 11:04 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"