Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

Shading

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
matthew - 24 Dec 2003 15:58 GMT
I have a line chart with 2 lines. Is there anyway to shade
or change the color in the area between those 2 lines?
Thank you
Jon Peltier - 24 Dec 2003 17:57 GMT
Matthew -

Make a stacked area chart, then unshade the bottom series (Fill = None).
 You plot the difference between the two original curves for the second
series.  If you want better control over the lines, and especially if
you want to use data point markers, make your stacked area chart and
format the border of both area series to None, then add the two original
series, and change their chart type back to Line.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I have a line chart with 2 lines. Is there anyway to shade
> or change the color in the area between those 2 lines?
> Thank you
 
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.