 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2007Shading 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. 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  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info > Hello, > [quoted text clipped - 5 lines] > > Thanks for all your help in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.