How to Shade Area Between Two Lines in a Chart in Excel

We will use the sample dataset below for illustration.

Dataset to Shade Area Between Two Lines Excel Chart

In a new column, copy the Y-values of the first line, Price (Jan) column.
Use this formula in the E5 cell.

=C5

Basic Required Calculation for Shading Area Between Two Lines of a Chart

It will generate all the values of Price (Jan) in the column named Jan.

Now, we need to find the difference between the Y-values of the two lines.

=D5-C5

Drag the Fill Handle to extend the formula to the other cells in the column. It will show all the price changes.

Right-click on the chart and choose Select Data from the context menu. Alternatively, you can find this option in the Chart Design tab if your chart is selected.

Use of Context Menu Bar to Add More Lines in Excel Chart to Shade Area

A dialog box named Select Data Source will pop up.

Another dialog box named Edit Series will pop up.

Enter or select the Series name in that dialog box. In the example, we have selected the Series name as E4 cell.
Enter the Series values. E.g. range E5:E9.
Press OK.

In the Edit Series dialogue box, enter the required cell in Series name (e.g. F4 cell).
Include the Series values. Here, I have used the range F5:F9.
Press OK.

Edit Data Series to Shade Area Between Two Lines

You will see the following lines.

How to Shade Area Between Two Lines Excel Chart

Utilizing Change Chart Type Feature to Shade Area Between Two Lines in a Chart

In the Change Chart Type window, go to All Charts >> Combo chart >> select Custom Combination.
Change the chart type for both the Jan and Price Change lines to Stacked Area.
Press OK.