Shading between two lines

M

Marlene.Sawhney

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.
 
A

Andy Pope

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
 

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

How to make the shading look uniform around a double spaced line in MS Word? 0
Shading between two lines on a chart 0
Convert Error Bars to Series and Colour 1
Word- Find and Replace 1
I cannot set the maximum date for the axis of a line chart 5
Shading between lines chart type. 2
Automatic Macro to create 200 graphs 1
Shading a portion of the space between two lines 3

Top