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

Shading a portion of the space between two lines 3
how do i shade the space beween lines in a chart 2
Convert Error Bars to Series and Colour 1
Shading between lines chart type. 2
How to fill the area between two lines in excel graph? 1
Two color fill between two lines 8
Horizontal Axis Options Changing 6
I cannot set the maximum date for the axis of a line chart 5

Top