how do i shade the space beween lines in a chart

G

Guest

I want to shade the area between 2 line plots i.e maximum curve and minimum
curve. Everything in between the two lines is valid. thus the area needs to
be shaded to create an envelop effect.

anyone ever done this before
 
T

Tushar Mehta

Plot the lower threshold line and the *difference* between the lower and
the upper thresholds. Move each of these series to the secondary axis,
change each to stacked area type of chart, add a secondary x axis (with
the chart selected, select Chart | Chart Options... | Axes tab | check
on the 'Secondary x axis'), format the secondary x-axis to *not* check
'Value (Y) axis crosses between categories', and format as desired.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

8?B?Si5TLiBSeWJhaywgUC5Fbmcu?= <J.S. Rybak, P.Eng.
@discussions.microsoft.com> says...
 

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

Convert Error Bars to Series and Colour 1
Question Variation: Shading a portion of the space between two lines 1
Shading a portion of the space between two lines 3
How do I shade the area between two lines on a chart? 3
How do i show the gap between two lines of a chart 4
How do I shade the area beneath a line drawn as a curve? 1
How do I shade only 1/2 of a cell? 1
How to fill the area between two lines in excel graph? 1

Top