ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shading between two lines on a chart (https://www.excelbanter.com/excel-discussion-misc-queries/157714-shading-between-two-lines-chart.html)

[email protected][_2_]

Shading between two lines on a chart
 
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.



All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com