Excel Chart Fill Between Lines: The Stacked Area Method

Charts & pivot tables · Updated November 19, 2026

To fill the space between two lines in an Excel chart, add a stacked-area band made from a baseline and the difference between the lines, then overlay the original lines as a line chart. Excel does not have a one-click “fill between lines” setting for an ordinary line chart, so this helper-series method gives you control over the shaded region.

Why a helper series is needed

A standard line chart draws each series as a line; it does not automatically shade the changing space between two series. An area chart can shade values, but its ordinary fill runs from a series down to the horizontal axis, not from one arbitrary line to another. A stacked area chart solves the geometry: the first series establishes the lower edge, and the next series adds a band above it.

Because the baseline is only there to position the band, you make that series invisible. The visible area then appears to sit between the two boundaries. Overlaying the original data as line series restores the crisp lines and makes it easier to read their values. This approach is useful for showing a forecast range, actual results versus a target, a confidence-style interval, or the difference between two measurements over time.

Prepare the data and helper columns

Arrange the source data in columns, with one shared category such as date in the first column and the two lines in the next columns. For example, use A for Month, B for Actual, and C for Target. Add D for the lower boundary and E for the band height. The lower boundary must be the smaller of the two values at each row, while the band height is the distance between them.

With dates in A2:A13, the two line values in B2:C13, and headers in row 1, enter this in D2 to calculate the lower boundary; if B2 is 40 and C2 is 55, the result is 40:

=MIN(B2,C2)

With the same layout, enter this in E2 to calculate the band height; for values 40 and 55, the result is 15 because 55 minus 40 equals 15:

=ABS(B2-C2)

Copy both formulas down through the data. Using MIN and ABS means the band still spans the two values if their order reverses in a later row. If you know one series is always the lower boundary and the other always the upper boundary, you can instead use the lower series directly as the baseline and subtract it from the upper series for the band. Check that the subtraction never produces a negative height in that version.

  • Keep the categories in a single, consistently ordered column; dates should be actual Excel dates if you want a date axis.
  • Do not include totals or blank summary rows in the chart range unless they are meant to appear as data.
  • Make sure both line series use the same units. A band between dollars and percentages, for example, would not be meaningful.

Build the stacked-area and line combination

On Excel for Microsoft 365 for Windows, select the category column and the four plotted series: Lower boundary, Band, Actual, and Target. If those columns are not adjacent, hold Ctrl while selecting the separate ranges, or insert the chart first and add the remaining series afterward. Choose Insert > Insert Combo Chart > Create Custom Combo Chart. In the custom chart dialog, assign Lower boundary and Band to Stacked Area, and assign Actual and Target to Line. Leave all four series on the primary axis.

Click OK to create the combination chart. If Excel guesses the wrong type for a series, use Chart Design > Change Chart Type > Combo and set each series explicitly. The essential arrangement is two stacked-area series plus the two original line series; using an ordinary area chart for the band will fill down to zero instead of following the lower line.

Excel may place the category labels or series in an unexpected orientation. Use Chart Design > Switch Row/Column if the months appear as separate series rather than categories. If the chart is missing a series, use Chart Design > Select Data to check the chart data range and confirm that the helper columns were included.

Make the baseline invisible and style the fill

Click the Lower boundary area in the chart. If it is difficult to select, use the chart’s Format tab and the Current Selection list to choose the series by name. Open Format Data Series, then use Fill & Line. Set Fill to No fill and Border or Line to No line. The baseline still contributes its values to the stacked-area position even though it is not visible.

Next, select the Band series and choose a solid fill color. In Format Data Series, adjust the fill transparency so both plotted lines and any gridlines remain legible. A moderate amount of transparency is usually easier to read than a fully opaque block; the best setting depends on the chart background and the number of lines. Remove the band’s border if its outline makes the plot look like a second, unintended line.

Format Actual and Target as line series with distinct, contrasting colors. If a shaded area hides a line, use Chart Design > Select Data to arrange the series so the baseline and band are listed before the line series, then check the result. The line series should be visually on top of the fill. Add a chart title and axis labels that explain what the measurements and units represent. The legend may include the helper names, so rename the series to useful labels or remove helper entries from the legend when appropriate.

What happens when the lines cross?

With the MIN and ABS helper formulas, the shaded region continues to cover the space between the two values after they cross. However, a single fill color cannot communicate which line is on top at every point. The fill simply marks the interval between them. Keep both line series visible and clearly labeled if their identity matters.

If you want one color when Actual is above Target and another when it is below, a single band series is not enough. You need separate helper series for the two conditions and must ensure the transition is handled at the crossing. When the crossing falls between measured dates, the chart connects points with straight segments; the exact crossing point is not automatically calculated as a new row. For a precise color change at that location, calculate or estimate the crossing and add a data point there, or use a charting approach that explicitly supports conditional areas.

Also consider whether a filled interval is appropriate when the lines cross frequently. The band remains mathematically valid, but repeated color changes or overlaps can make the story hard to follow. In that case, plotting the two lines alone, or charting their difference in a separate panel, may communicate the comparison more clearly.

Alternatives and when to use them

The stacked-area helper method is a practical choice when you want a continuous filled band behind two lines and can maintain a few extra columns. Other chart types may be clearer depending on the question:

  • Two-line chart: Use this when the relationship between the series matters but the filled interval adds visual weight or obscures detail.
  • Difference chart: Calculate one series minus the other and chart that result around a zero line. This makes the size and direction of the gap explicit, though it no longer shows the two original values in the same filled area.
  • Simple area chart: Use it when the meaningful comparison is each value against zero or another axis baseline, rather than the space between two moving lines.
  • Error bars: Consider them when the upper and lower values represent uncertainty around a central estimate at individual points. Error bars show ranges without implying a continuous filled region between observations.

For charts shared with others, label what the shading means in the title, a note, or the legend. A transparent band could represent a target range, a forecast spread, or merely the gap between two measurements; its appearance alone does not tell readers which interpretation is intended.

Common problems and practical fixes

If the fill runs down to the horizontal axis, check that the two area series are set to Stacked Area and that the Lower boundary is included before Band. A regular Area chart does not stack the band on the baseline. If the fill is on the wrong side of a line, inspect the helper values: the baseline should be the smaller value and the band should be the nonnegative difference.

If the band disappears, make sure the Band series is not formatted as No fill and that its formula cells contain numbers rather than text or errors. If only part of the band appears, check for blank cells, formulas returning empty text, or an incomplete chart range. Blank-value behavior can vary with chart settings and chart type, so decide whether missing observations should create a gap or be connected rather than silently treating them as zero.

A secondary axis is usually unnecessary and can distort the apparent relationship. If the two lines or area series have been placed on different axes, the band may not align with the plotted lines even though the numbers look plausible. Set all series to the primary axis unless there is a deliberate, clearly explained reason not to. Changing an axis scale can also make the band look larger or smaller visually without changing its underlying values.

To update the chart as new rows are added, consider converting the source range to an Excel table with Insert > Table before building the chart. Verify that the chart includes the new rows and that the helper formulas fill down. For a chart that is already built, Chart Design > Select Data lets you inspect or edit the source range.

Frequently Asked Questions

Can Excel fill between two lines automatically?
No. A standard line chart has no direct fill-between-series command. Use helper columns with a stacked-area series, make its baseline invisible, and overlay the two original lines.

Can I fill between two lines without adding formulas?
You can manually create helper values, but the chart still needs a baseline and a band height. Formulas are usually safer because they update when the source values change and reduce the risk of incorrect shading.

Will the fill work if the lines cross?
Yes, if the helper columns use the lower value as the baseline and the absolute difference as the band height. The same fill color will span the values on either side of a crossing; it will not automatically change color to identify which series is higher.

Can I use this method in Excel for Mac?
Excel for Mac has combo charts and stacked-area charts. The dialog layout and chart formatting controls may differ from Windows; look under Insert or Recommended Charts for the Combo option, then use the chart formatting pane to set series types and fills.

Does it work in Excel for the web?
Chart editing features in Excel for the web can differ from the desktop app, particularly for custom combinations and detailed series formatting. If you cannot set the stacked-area and line types or remove the baseline fill in the browser, open the workbook in desktop Excel to build or adjust the chart.

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.