Ace Excel Chart Shade Area Between Two Lines

I attach the excel file with the graph.

Excel chart shade area between two lines. We will also need two stacked area chart series one for the clear region below the lower XY line and one stacked on top to fill between the XY lines. The same issue happens if I use a scatter plot to build the lines. I thought this was really cool so I asked Mike.

If you look at the chart closely you will realize it is a collection of 4 sets of data. The top left cell is blank to tell Excel to use the first row as series names and the first column as category labels. In the Select Data Source dialog box click the button to add a new data series for the Minimum my Min series is in cells O6O17 with Name in O5.

Place the value against each data point you want shading. In the drop-down box choose Scatter with Smooth Lines. Choose Insert Charts Scatter.

We start with two XY scatter chart series one above and one below the filled area. 1 From the Chart Tools Design tab change the type of chart to area 2 From the Chart Tools Format tab select from the drop down on the far left each series in turn and select Format Selection button beneath the drop box 2 Choose the Solid Fill option for FYx Stds and FYy Stds choose a color for both could be the same or different. The second series for the Stacked Area Chart is a new data set that you define as the values for Line 2 minus the values for Line 1.

I want to color the area between these two lines. When learning the integral you might have drawn a plotted curve shade an area under the curve and then calculate the area of shading section. Do the same for the top series.

I have looked at few posts on various sites and I am still struggling. The background data is shown here. Place your data in Excel.