Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Shading between two lines

Hello,

I have a line graph over time that jumps up and down (data 1). I also
have another horizontal line that is the maximum of Data 1 and another
horizontal line that is the minimum of Data 1. Does anyone know how to
shade the area between the minimum and the maximum lines? I've tried a
few things with Area Graphs but nothing seems to work.

Thanks for all your help in advance.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Shading between two lines

Hi,

This can be done with area charts.
One way, add 2 series based on Min and Max values. Change chart type to
Area.
Change series order so the Min appears in front of Max. Format Min to be
same colour as plotarea.

You can also use stacked area charts where the fill pattern of the lower
area is set to none. But you will need to adjust the Maximum values to be
Max-Min.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
oups.com...
Hello,

I have a line graph over time that jumps up and down (data 1). I also
have another horizontal line that is the maximum of Data 1 and another
horizontal line that is the minimum of Data 1. Does anyone know how to
shade the area between the minimum and the maximum lines? I've tried a
few things with Area Graphs but nothing seems to work.

Thanks for all your help in advance.


Reply
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
Shading between two lines on a chart [email protected][_2_] Excel Discussion (Misc queries) 0 September 10th 07 07:17 PM
Question Variation: Shading a portion of the space between two lines [email protected] Charts and Charting in Excel 1 April 15th 07 10:00 AM
Shading a portion of the space between two lines [email protected] Charts and Charting in Excel 3 March 22nd 07 08:28 PM
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
Powerpoint Graph- Shading in between two linear graph lines TerenYoung Charts and Charting in Excel 1 June 15th 06 09:29 AM


All times are GMT +1. The time now is 02:24 PM.

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

About Us

"It's about Microsoft Excel"