Excel Chart: Shade the Area Under a Line in Excel

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, change a line chart to an Area chart to fill beneath the data, or use a combo chart with an Area series behind a Line series if you want to keep a crisp line on top. The fill extends to the chart’s horizontal baseline, so check the axis settings if the shaded area should start at zero or another value.

What shading under a line means

A line chart emphasizes how values change from one category or date to the next. Shading the space below the line adds a visual sense of magnitude, making it easier to see the overall level or compare the size of values across a period. Excel does not provide a simple fill toggle for a standard Line chart; the usual approach is to use an Area chart, whose plotted series is filled down to the horizontal axis.

For example, a monthly visitor series can be displayed as an area to make seasonal rises and falls more prominent. This is most useful when the chart has one main series, the categories are in a meaningful order, and the fill does not hide important information. If the line itself needs to remain clearly visible, combine an area series with a line series rather than relying on the area chart’s outline alone.

Turn a line chart into an Area chart

This is the quickest method when a filled chart is all you need. Arrange labels in one column and the values in the next, select the data, and insert or convert the chart. For instance, put months in A2:A13 and sales in B2:B13, with headers in row 1. The categories should be in the order you want them to appear; dates stored as text may not behave like real dates on a date axis.

  1. Select the chart. If you are starting from a worksheet range, select the labels and values, then choose Insert > Insert Line or Area Chart > Area.
  2. To convert an existing line chart, select it and choose Chart Design > Change Chart Type.
  3. In the chart-type window, choose Area, select the standard Area subtype, and choose OK.
  4. Use Chart Design > Add Chart Element or the chart formatting controls to add a title, axis titles, or a legend if they help explain the data.

The standard Area subtype is generally the right starting point for one series. It preserves the values while filling the plot beneath them. Avoid selecting a 100% Stacked Area chart unless the purpose is to show each series as a share of a total; that chart rescales values to percentages and no longer communicates the original amounts directly.

Keep a sharp line with a combo chart

An Area chart usually draws an outline along the top of the filled shape, but its appearance may not match a line chart’s weight, markers, or color. For a stronger line, create an area series for the fill and a separate line series for the outline. A practical way to do that is to duplicate the value column, then use a combo chart so both columns contain the same values but have different chart types.

  1. Add a second copy of the values in a new column and give it a clear header, such as Line overlay. Keep the category labels aligned row by row.
  2. Select the chart, then choose Chart Design > Change Chart Type > Combo.
  3. In the custom combo settings, set the original series to Area and the duplicate series to Line. Leave both on the primary axis when they use the same units and scale.
  4. Choose OK, then format the line series with the desired color, width, or markers. Give the area series a contrasting fill.

If the line is obscured, open Chart Design > Select Data and use the series-order controls to put the line series after the area series. Excel generally draws later series over earlier ones, although chart-type combinations and formatting can affect the result. Avoid placing the duplicate line on a secondary axis when both series represent identical values: separate scales can make the line appear not to match the filled boundary.

The combo-chart route is especially helpful when the shaded chart needs a thin, prominent line, data markers, or a fill color that is much lighter than the line color. It also makes the design easier to adjust later: the fill and line are separate series with independent formatting.

Choose colors and transparency

A solid fill can dominate the chart, particularly when the chart has a dark background or several data series. To soften it, select the area series, open Format Data Series, and use Fill & Line > Fill. Choose Solid fill, select a color, and adjust Transparency. The exact pane layout can vary slightly with window size, but Format Data Series is the relevant control; formatting the Chart Area instead changes the chart background rather than the data fill.

Use a fill that contrasts with the plot background and remains distinguishable from the line. A pale fill with a darker outline is a dependable choice for a single series. With several series, choose colors that remain distinct where the filled shapes overlap, and do not rely on color alone to communicate a critical distinction. Direct labels, a clear legend, or different line styles can help readers who have difficulty distinguishing colors.

Click the edge of the filled shape carefully when selecting it. If Excel selects the chart area, plot area, or another series instead, use the chart’s Current Selection list on the Format tab to choose the intended series. Changing the fill through Format Data Series keeps the color attached to the data series if the chart is resized.

Set the baseline and handle values below zero

An area chart fills toward the horizontal axis, not automatically toward whichever starting value seems visually convenient. For ordinary positive values, the horizontal axis is often at zero, which makes the shaded area read as amount above zero. To verify this, right-click the value axis, choose Format Axis, and inspect the Bounds and the horizontal-axis crossing options. Axis controls depend on whether the chart uses a value axis or a category axis, so check the preview after changing a bound or crossing point.

Negative values need particular care. When a series crosses zero, the fill may extend on different sides of the axis, and a large shaded block can make the direction of change less clear. Set the value-axis bounds to include the full data range, keep the zero line visible if it is a meaningful reference, and consider using a line chart instead if the filled regions make positive and negative values hard to distinguish. Do not crop the axis simply to make the filled area look larger; that can give readers a misleading impression of the scale.

If the intended shaded region is between the data and a nonzero target, use a helper series rather than treating the chart baseline as if it were the target. For example, suppose values are in B2:B10 and a constant target is 8. Put the target in C2:C10, and calculate the amount above it in D2:D10. With the data layout of actual values in B2:B10 and target values in C2:C10, enter =MAX(0,B2-C2) in D2 and fill down. If B2 is 12 and C2 is 8, the result is 4. A stacked-area construction can use the target as the invisible base and the difference as the visible fill; overlay the actual values as a line in a combo chart. This shades only above the target. For areas below a target, calculate the shortfall separately and choose the fill logic to match the story the chart should tell.

Area charts, stacked areas, and alternatives

A standard Area chart is suited to showing the size and movement of one series against a baseline. A Stacked Area chart is designed to show how multiple positive series contribute to a combined total over categories. It accumulates series on top of one another, so later series no longer share the same zero baseline. That makes it useful for composition, but often confusing if the goal is to compare each series’ independent values.

A Line chart is usually clearer when exact values, many series, or small differences matter more than the sense of volume. A combo chart is a good compromise when one series needs shading but the data still needs a strong line. For a simple presentation graphic, Excel shapes can imitate a colored region, but shapes do not update reliably with changing data and are not a good substitute for a data-driven chart. If the chart must refresh as source data changes, use chart series rather than manually drawn shapes.

Common problems and how to fix them

  • The whole chart is colored. You may have formatted the Chart Area or Plot Area. Select the plotted series and format its fill under Format Data Series.
  • The line is hard to see. Reduce fill opacity by increasing transparency, use a darker outline, or add a duplicate Line series in a combo chart.
  • The shaded region starts at the wrong level. Check where the horizontal axis crosses the value axis. For a nonzero reference such as a target, build a helper-series chart instead of expecting the ordinary area fill to use that target.
  • Several fills overlap in an unexpected way. A standard Area chart can obscure earlier series. Try a combo chart, change series order, or use a Stacked Area chart only when the values are intended to accumulate.
  • The chart has gaps or odd category spacing. Check that category labels and values are aligned and that dates are genuine Excel dates where date spacing is important. Select Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed.

When a chart looks wrong after changing its type, check the selected data range as well as the formatting. A header accidentally included as a value, blank rows inside the source range, or a second series using a different scale can change the result. For charts that will be maintained, convert the source range to an Excel table with Insert > Table; charts based on a table can expand as rows are added, subject to the chart’s series setup.

Frequently Asked Questions

Can I shade under a line without changing the chart type?
Not with a direct fill setting on a standard Line chart. Convert it to an Area chart, or use a combo chart with an Area series and a Line series if you want to preserve a distinct line overlay.

How do I make the area fill transparent?
Select the area series, open Format Data Series, and choose Fill & Line > Fill > Solid fill. Adjust Transparency until the line and any gridlines remain easy to read.

Can I shade only the space above a goal line?
Yes. Use helper columns for the goal and the difference between each value and the goal, then build a stacked-area fill and overlay the actual values as a line. This gives more control than an ordinary Area chart, which fills to the chart axis.

Why does my area chart hide another series?
Filled areas can cover series drawn earlier in the chart. Change the series order in Chart Design > Select Data, make the fill more transparent, or use a combo chart and place a line series over the area.

Can I use these steps in Excel for Mac or Excel for the web?
The chart concepts are the same. Excel for Mac has comparable chart-type and series-formatting controls, though ribbon and pane placement may differ. Excel for the web supports common chart changes, but some advanced combo-chart or formatting controls may be more limited than in the Microsoft 365 Windows desktop app.

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.