Excel Fill Area Under a Line Chart: Add Shaded Area

To fill the area beneath a line in Excel for Microsoft 365 on Windows, create a combo chart with two copies of the same data series: format one copy as an Area chart and the other as a Line chart. The area series supplies the shading, while the line series sits on top; adjust the area fill color and transparency to keep the data easy to read.

What Excel means by filling under a line

A standard Line chart draws a line between data points but does not offer a direct setting to fill the region between that line and the horizontal axis. An Area chart does fill beneath a series, but its default appearance may not be the line-chart style you want. A combo chart lets you combine the two: one series creates the filled region, and a second series draws the crisp line.

This distinction matters because formatting the chart area or plot area is not the same as filling beneath a data series. Those settings color the chart background or the rectangle behind the data. The Area series, by contrast, follows the values and fills down to the horizontal axis. For example, if monthly sales are 12, 18, and 15, the shaded shape rises to 18 in the second month and falls to 15 in the third.

The method below assumes a single set of positive values and a category axis such as months or dates. It also works when the values change over time, and it preserves the familiar line-chart outline. If you want a fill between two lines rather than between one line and the axis, see the section on other shading methods.

Set up the data for a combo chart

Arrange the source data with a category column and two identical value columns. The duplicate is intentional: Excel needs one series to format as an area and another to format as a line. For example, a small table could look like this:

Column A: Month, with January, February, and March.
Column B: Sales line, with 12, 18, and 15.
Column C: Sales fill, with the same values: 12, 18, and 15.

Use clear series names so the chart legend is understandable while you build it. You can remove the duplicate entry from the legend later if it makes the finished chart look cluttered. Keep the two value columns identical; if one is accidentally different, the line and shaded edge will not match.

Select the full table, including the headings. If the chart already exists, you can add the duplicate series through Chart Design > Select Data, but creating the combo chart from a prepared table is often simpler. Excel uses the first column as the category labels when the selection is arranged in this usual format.

Create the shaded line chart

Select the table, then choose Insert > Insert Combo Chart > Create Custom Combo Chart. In some Excel layouts, the combo-chart button appears in the Charts group on the Insert tab.
In the custom combo chart dialog, set the Sales fill series to Area and the Sales line series to Line. Make sure both use the primary axis; they represent the same values and normally need the same scale.
Leave the secondary-axis boxes unchecked unless you have a specific reason to plot different scales. A secondary axis can make matching data appear misaligned or visually confusing.
Choose OK. Excel creates a chart with a filled series and a line series.

If you are changing an existing chart, select it and choose Chart Design > Change Chart Type. Choose the combo chart options, then assign the Area type to the fill series and Line to the outline series. If the existing line chart contains only one series, first add a duplicate through Chart Design > Select Data, then edit the combo assignments.

The chart may initially show the area over the line, or the two series may be difficult to distinguish. The key is that the area should be drawn behind the line. In Chart Design > Select Data, use the series-order controls to put the area series before the line series when the controls are available. If the order is already correct, simply format the line with a visible color and width. Inspect the chart after changing the order because chart types can layer series differently.

Choose a fill color and transparency

Click the shaded region to select the Area series. If a single click selects an individual point rather than the whole series, click again carefully or use the chart’s Format selection controls to select the series. Open the Format Data Series pane, choose Fill & Line, and expand Fill. Select Solid fill, pick a color, and adjust Transparency.

Transparency is useful because a strong opaque fill can hide gridlines, labels, or other chart elements. A pale color or moderate transparency lets the line remain the visual focus while still making the area apparent. There is no universally correct transparency value: the best setting depends on the fill color, chart background, and whether the chart will be viewed on screen or printed.

Next select the Line series and format its line so it is easy to see over the fill. In the Format Data Series pane, use the line options to choose a contrasting color and a suitable width. If you want a clean outline without point symbols, turn off markers for the line series. If the line should emphasize individual observations, keep markers but use a size that does not overwhelm the shaded region.

You can also give the area series no visible outline if its border creates a second edge that looks heavier than intended. Under the area series’ line settings, choose No line. Keep the separate Line series visible so the chart still has a well-defined boundary. Use a chart title and axis titles that explain the measure and units; shading does not replace those labels.

Use a regular Area chart instead

If preserving a separate line series is not important, an Area chart is the quicker option. Select the category and value columns, then choose Insert > Insert Line or Area Chart > Area. Excel fills the space beneath the series automatically. You can format the area color, transparency, and outline afterward.

An Area chart can be a good choice when the goal is to emphasize magnitude or change over time, and there is only one series. Its filled shape may look different from a conventional line chart, especially if you want a strong, sharply defined line on top. The combo-chart method provides more independent control over the fill and line styling.

Be cautious when comparing several Area series. In a regular Area chart, overlapping fills can obscure one another. A Stacked Area chart instead adds series together, so the top boundary represents a cumulative total rather than each series’ original values. Those are different analytical views, not just different colors. For a single series, a regular Area chart avoids that stacking issue.

Fill to a threshold or between two lines

Sometimes the intended shaded region is not the entire space below a line. A chart might need to highlight values above a target, show the gap between actual and planned results, or shade a confidence band. The basic duplicate-series method fills down to the axis; it does not automatically restrict color to a chosen threshold or to the space between two separate curves.

For a threshold, one approach is to build helper series and use a combo chart so the chart can distinguish values above and below the target. For a band between two curves, an Area chart with carefully constructed helper series may be more suitable. In a stacked-area technique, the lower series establishes the base of the band and the difference between the upper and lower values forms the visible band. This requires the helper values to be set up consistently, particularly when the two boundaries cross.

Before choosing a helper-series method, decide what the shaded region should mean and how it should behave when values are negative or boundaries cross. A plain fill beneath a line implies the horizontal axis is the reference point. A target band implies two meaningful boundaries. Choosing the wrong chart construction can make a visually polished chart communicate the wrong quantity.

Common problems and how to fix them

The line disappears behind the fill: Check that the line series is present, assigned the Line chart type, and formatted with a visible color. Put the Area series earlier in the drawing order if necessary.
The shaded area does not match the line: Compare the two source columns row by row. They must contain the same values and use the same category labels.
The fill covers too much of the chart: Reduce its opacity by increasing transparency, choose a lighter color, or use a standard Area chart if a separate line is unnecessary.
The chart has an unexpected cumulative shape: Check whether the series was assigned Stacked Area instead of Area. Stacked Area adds series together.
The categories look wrong: Review the selected source range and the category labels in Chart Design > Select Data. A header or data column may have been interpreted as a series instead of a label.
The area appears to start at an unexpected level: Check the vertical axis bounds and where the horizontal axis crosses it. For ordinary positive values, the fill is generally read against the chart’s horizontal baseline.

Also watch for blank cells, hidden rows, and filtered data. Excel’s chart settings determine how empty cells are displayed, and a gap in the source data may create a break rather than a continuous fill. If your chart skips information, select the chart and review Chart Design > Select Data > Hidden and Empty Cells. The available choices and behavior can depend on chart type and workbook setup.

Make the chart easier to interpret

Shading attracts attention, so use it to support a clear comparison rather than as decoration. A restrained fill and a distinct line usually communicate the series more clearly than a saturated fill combined with several other accent colors. Keep gridlines light enough to remain useful, and avoid unnecessary 3-D effects, which can distort the apparent height of values.

Think about the chart’s baseline. If the vertical axis begins above zero, the visible filled area may exaggerate changes because the chart shows only a cropped portion of the scale. A nonzero baseline can be appropriate in some contexts, but label the axis clearly and consider whether viewers might mistake the shaded height for the full value. When the filled region represents a total or volume, a zero baseline is often easier to interpret.

For dates, check that Excel has treated the horizontal axis as intended. A line chart can space categories evenly, while a date axis spaces dates according to time. If dates are irregular and the exact intervals matter, the chart type and axis settings affect how gaps appear. Review the axis formatting rather than assuming that a smooth-looking shaded shape reflects uniform time intervals.

These instructions describe Excel for Microsoft 365 on Windows. Excel for Mac has comparable chart types and formatting controls, but the ribbon layout and pane placement can differ by release. Excel for the web may also present a reduced set of chart-formatting controls; if a particular combo-chart or series-order option is unavailable, open the workbook in the desktop app to make that adjustment.

Frequently Asked Questions

Can I fill under a line without duplicating the data?
A regular Area chart needs only one series, but it may not give you the separate line styling you want. For a combo chart with an area fill and a clear line on top, duplicating the values into a second series is the straightforward approach.

Can Excel fill only the area above a target line?
Not with the basic fill-under-line setting, because that fills to the horizontal axis. To shade only the region relative to a target, create helper series or another chart construction that represents the target boundary and the difference. Check the result when data crosses the target.

Why does my Area chart look different from my Line chart?
An Area chart fills the space beneath its values, while a Line chart draws only the series line. A combo chart combines those visual roles, but the fill opacity, series order, axis scale, and chart type all affect the final appearance.

Will the shaded chart update when I change the data?
Yes, if both plotted series refer to the source values and the duplicated fill values are kept in sync. If you add rows outside the chart’s source range, the chart may not include them automatically; expand the chart data range or use an Excel table as the source.

Can I use this method for negative values?
Usually, an Area series fills toward the horizontal axis, so negative values appear on the other side of the zero baseline. Review the vertical-axis crossing and the shape carefully, especially if the data includes both positive and negative values or the axis bounds are customized.

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.