Shading

M

matthew

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select text of a particular shading color (VBA macro) 5
How do I convert shading to highlighting for specific colors 8
Change colour of Field Shading in Word 365? 2
table shading prints differently on different pages 0
Shading inside a heading 11
Help with area under trendline 0
Excel 2007 format High Low plot area 2
Convert Error Bars to Series and Colour 1

Top