Excel Chart: Shade the Area Between Two Lines

Charts & pivot tables · Updated November 19, 2026

To shade the area between two lines in an Excel chart, add helper columns for the lower value and the gap between the lines, then plot those as a stacked area chart and overlay the original lines. In Excel for Microsoft 365 on Windows, use a custom combo chart: make the helper series stacked areas, make the original data series lines, and set the lower area to No fill.

Why a regular line chart does not fill between lines

A standard Excel line chart draws each series as a line, but it has no built-in command to fill only the space between two line series. An area chart fills from a series down to the chart’s baseline, usually zero, which is not the same thing. The useful workaround is to make the space between the lines behave like a stacked area segment: one invisible series establishes the lower edge, and a second series supplies the band’s thickness.

This distinction matters when presenting a target and actual result, two forecast scenarios, or an upper and lower range. Filling from zero can make the chart look as if the distance from zero is important, when the intended message is the difference between the two plotted values. A helper-series band communicates that difference more directly.

Prepare the data and helper columns

Arrange the source data in columns with one shared category or date column and one column for each line. For example, put dates in A2:A13, Line 1 values in B2:B13, and Line 2 values in C2:C13. Add two helper columns: Lower in D and Band in E. The approach below assumes both line series are nonnegative, an important condition for a stacked area chart.

  • In D2, calculate the lower of the two values. With Line 1 in B2 and Line 2 in C2, enter =MIN(B2,C2).
  • In E2, calculate the distance between them. With the same layout, enter =ABS(B2-C2).
  • Fill both formulas down through the rows containing data. If the values in a row are 42 and 50, the helper values are 42 and 8; the stacked band therefore reaches from 42 to 50.

Using MIN and ABS means the band still lies between the two values when their order reverses. It does not require you to decide in advance which named line will be higher. Keep the original Line 1 and Line 2 columns: they will be added to the chart as visible line series after the helper areas are set up.

Create the combo chart in Excel for Windows

  1. Select the date or category column and the four series columns: Lower, Band, Line 1, and Line 2. Include the headings so Excel can name the series.
  2. Choose Insert > Recommended Charts > All Charts > Combo > Custom Combination.
  3. Set Lower and Band to Stacked Area. Set Line 1 and Line 2 to Line. Leave all four series on the primary axis for a typical comparison.
  4. Click OK. If Excel guesses a different series arrangement, right-click the chart, choose Select Data, and check that the date column is used for the horizontal axis labels and that all four series are included.

In the resulting chart, the stacked areas establish the shaded band, while the line series show the original values. The lower area may initially appear as a solid block from zero to the lower line; that is expected until you make it invisible. The band series must remain stacked on top of the lower series, so do not change the two area types to separate, non-stacked Area charts.

Hide the base and style the shaded band

Click the lower filled area in the chart. If it is difficult to select, use Format > Current Selection on the chart ribbon to choose the Lower series, or click the series in the chart and confirm its name in the Format Data Series pane. Right-click the selected series and choose Format Data Series. In the pane, open Fill & Line, choose Fill > No fill, and set Border > No line if a boundary is visible. The base still affects the stacked position even though it is not painted.

Next, select the Band series and choose a solid fill color. Adjust the fill transparency if the lines or gridlines need to remain easy to see; a moderate amount of transparency is often clearer than an opaque block. You can also remove the Band border to avoid a jagged outline along its top edge. Give the two line series distinct colors and, if useful, different dash styles or markers. The original lines should remain visible over the filled region, not disappear behind it.

Use a chart title and legend labels that explain what each line represents. If the legend includes the helper names Lower and Band, rename those headings to reader-friendly labels or remove the helper entries and explain the shaded region in a note. Avoid relying on color alone when the chart may be printed in grayscale or viewed by someone with color-vision differences.

What happens when the lines cross?

The MIN and ABS helper columns recalculate the lower value and the gap at each row, so they work when Line 1 is above Line 2 in some rows and below it in others. At a row where both values are equal, Band is zero and the fill narrows to nothing. This is usually the intended result for two crossing lines.

Excel connects values between categories, however, so a crossing that happens between two recorded dates is represented by straight segments rather than a precisely calculated intersection. The shaded boundary may look slightly different from a mathematically exact region between continuous curves. If the location of the crossing is important, add a data row at the calculated intersection or use more closely spaced observations. For monthly or weekly summaries, the row-by-row band is generally an appropriate visual approximation.

Important limitation: negative values and missing data

Stacked area charts treat positive and negative values separately. If the lower helper series includes negative values, the Band series may not stack from that negative lower boundary as expected. The simple MIN-and-ABS method is therefore best when both lines stay at or above zero, such as counts, percentages, and many measurements. Do not use it unchanged for profit-and-loss values or other series that cross zero and assume the shaded region will be correct.

For negative data, consider a different visual treatment, such as emphasizing the two lines and marking selected intervals with chart shapes, or preparing a carefully shifted helper dataset and clearly correcting the displayed axis labels. A shifted chart can be misleading if its axis still appears to show the original values, so make that adjustment explicit and verify every tick label. For a chart that must update automatically and accurately across zero, test the complete setup with representative positive, negative, and crossing values before distributing it.

Blank cells also affect the appearance of a band. A missing value can make a series stop, connect across the gap, or display as zero depending on the chart’s empty-cell setting and source data. To inspect the behavior, select the chart and choose Chart Design > Select Data > Hidden and Empty Cells. Choose whether empty cells should appear as gaps or be connected, based on what the missing values mean. Do not replace unknown measurements with zero merely to remove a visual gap; zero is a real value and can create a false dip or wedge.

Alternatives and when to choose them

A stacked-area helper band is useful when the purpose is to show the full separation between two series across many dates or categories. It is also convenient when values change regularly because the formulas and chart update as the source data changes. It is not the only way to emphasize differences, and it is not always the clearest choice.

  • Use two lines without a fill when the chart is crowded or precise reading of each line matters more than highlighting the gap.
  • Use a separate difference series when the size of the difference is the main message. A column chart of Line 1 minus Line 2 can make positive and negative differences easier to compare, but it does not show the area between the original lines.
  • Use a shaded band for an uncertainty range when you have lower and upper bounds around a measurement or forecast. The same stacked-area idea applies when the bounds are nonnegative: plot the lower bound as the base and the upper-minus-lower amount as the band.
  • Use chart shapes for a one-off annotation when only one short interval needs highlighting. Shapes are quick, but they do not recalculate with changing data and can drift out of position when the chart is resized or refreshed.

For a confidence or forecast interval, be precise in the legend and notes about what the band represents. A shaded region between two observed lines is not automatically a confidence interval; it is simply the plotted space between those values unless the data and analysis give it a more specific statistical meaning.

Common problems and fixes

If the fill covers the whole chart from zero, the Lower series has not been made transparent, or the two helper series are not both set to Stacked Area. If the shaded region is on the wrong side of the visible lines, check that the helper formulas use the same rows as the original values and that the chart series are all plotted against the same categories and axis.

If the area rises in unexpected steps, verify that Excel has recognized dates or categories in the first column rather than treating them as another data series. Check the order of the source columns as well: Lower must be stacked before Band. If the lines are obscured, select each original series and confirm its chart type is Line; then adjust its line color and width so it contrasts with the fill.

If new rows do not appear in the chart, expand the chart’s source range or convert the source data to an Excel table before creating the chart. Tables generally extend their ranges as rows are added, though check the chart after adding data to confirm the helper formulas and chart series extend too. When you paste values into the table, ensure the helper formulas have filled into the new rows.

Frequently Asked Questions

Can Excel shade between two lines without helper columns?
No standard line-chart setting fills only the space between two series. Helper columns let a stacked area series represent the lower boundary and the gap, while the original data stays visible as lines.

Can I use this method when one line is sometimes higher?
Yes, if the values are nonnegative. Use MIN for the lower helper and ABS for the gap so the band follows whichever line is lower at each row. The fill narrows where the lines meet.

Does this work in Excel for Mac?
Excel for Mac also supports combo charts and stacked area charts, although ribbon placement and wording can vary by release. Look for a custom combo chart option under Insert, assign the helper series as stacked areas and the original series as lines, then format the Lower series with No fill.

Can I shade between lines with negative values?
Not reliably with the basic stacked-area setup described here. Stacked areas handle negative and positive values separately, so the band may not start at the lower line. Choose another design or use a shifted setup only if you can accurately adjust and label the axis.

Will the shaded band update when my data changes?
It will update when the helper formulas recalculate and the chart includes the changed rows. For ongoing lists, an Excel table can help the source range expand, but confirm that new formula rows and chart series are included.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.