Shade Area of a Chart in Excel: Methods and Tips

Charts & pivot tables · Updated November 20, 2026

To shade the area beneath a line in Excel, select the chart, go to Chart Design > Change Chart Type, and choose Area; then select the filled series and set its color under Format Data Series > Fill & Line. If you mean shading the chart background or the space between two lines, use the corresponding method below—the steps differ because Excel treats those as different chart elements.

What shading means in an Excel chart

Excel does not have one universal Shade Area command. The word area can refer to the space under a plotted data series, the region between two data series, or the background inside the axes. These are controlled by different chart types or formatting options, so identifying the area you want to emphasize is the first step.

  • Under a line: use an Area chart to fill from the series down to the category axis.
  • Between two boundaries: use a stacked-area construction with a hidden base series and a filled difference series.
  • Behind the data: format the Plot Area fill.
  • Outside the axes but inside the chart object: format the Chart Area fill.

These options communicate different things. An area chart suggests magnitude accumulating from a baseline, while a shaded band between two lines typically represents a range, such as a forecast interval. A background fill is decorative and does not represent a data value.

Shade beneath a line with an Area chart

For one data series, an Area chart is usually the simplest choice. Arrange the category labels in one column and the values in the next, select the data, then choose Insert > Insert Line or Area Chart > 2-D Area. If you already have a line chart, select it and use Chart Design > Change Chart Type > Area to change the chart type without rebuilding the data.

  1. Click the filled region once to select the data series. If you select the chart instead, click the region again.
  2. Open Format Data Series. You can right-click the series and choose Format Data Series, or use the Format Selection command on the chart-formatting ribbon.
  3. In the formatting pane, select Fill & Line, open Fill, and choose Solid fill.
  4. Choose a color. Adjust Transparency if you want gridlines or other series to remain visible through the fill.
  5. Under Line, choose a matching outline, a different outline, or No line, depending on the look you want.

Use a 2-D Area chart when the vertical distance from the axis is meaningful. An area chart fills down toward the category axis, so changing the axis minimum can change how much of the chart appears filled. If the values are not intended to be interpreted from a zero baseline, a regular line chart may be less misleading.

Shade the space between two data series

Excel does not provide a single built-in command to fill only the gap between two arbitrary lines. A practical workaround is to build a stacked-area band. The first area series represents the lower boundary and is made transparent; the second represents the distance from the lower boundary to the upper one and receives the visible fill. Because the second series is stacked on the first, the colored band occupies the space between the two values.

For example, put dates in A2:A6, lower-bound values in B2:B6, and upper-bound values in C2:C6. In D2, calculate the band thickness from the upper and lower values with =C2-B2, then fill the formula down. If B2 is 4 and C2 is 7, D2 returns 3, the height of the band for that category. The upper value must be at least as large as the lower value for this simple method to make sense.

  1. Select the category labels in column A and the lower-bound and band-thickness series in columns B and D.
  2. Choose Insert > Insert Line or Area Chart > 2-D Stacked Area.
  3. Format the lower-bound series with No fill and No line. Format the band-thickness series with the color and transparency you want.
  4. Check that the lower-bound series is the first stacked series and the thickness series is stacked above it. If Excel plots them in the wrong order, use Chart Design > Select Data to adjust the series order.

The invisible base still affects where the visible band is positioned, which is why it must remain in the chart. If readers need to see the boundary values themselves, add the lower and upper series as line series in a combo chart and keep the band series as a stacked area. In Chart Design > Change Chart Type, choose Combo and assign the relevant chart type to each series. Check the preview and axis carefully: all series should use the same primary axis unless a genuinely different scale is intended.

Color the chart or plot background

If you want a tinted rectangle behind the plotted data rather than a data-shaped fill, format the Plot Area. Click inside the axes, but away from a data series, then right-click and choose Format Plot Area. In the pane, use Fill & Line > Fill to apply a solid color, gradient, or picture fill where available. A light tint can separate the chart from the page without implying that the color represents a value.

The Chart Area is the larger container around the plot, including space used for the title, legend, and axes labels. To color that whole container, select or right-click the outer chart background and choose Format Chart Area. If the wrong region changes, undo the formatting and select the other area. Excel chart elements can be small targets, so the Current Selection list on the Format tab can help you select Plot Area, Chart Area, or a particular series explicitly.

Highlight only a selected interval or threshold

Sometimes the goal is to shade only part of a timeline—for example, a recession period, a target zone, or the days when a measurement exceeds a limit. One option is to add a helper series that contains values only for the interval you want to emphasize, then format that series differently. For a filled interval, use an area-based chart arrangement that matches the data and test how Excel handles blank cells at the beginning and end of the interval. A helper series with values across the entire timeline will shade the entire timeline, not just the selected segment.

For a horizontal target band between two fixed values, another clear approach is to add lower and upper boundary lines and use the stacked-area method with a constant difference. For a threshold that marks only a data point or a short event, a contrasting marker, data label, or vertical line can be clearer than a broad fill. Avoid coloring a large area if it hides the actual series or makes the chart appear to show values that are not in the data.

Choose an area style that fits the data

A regular Area chart draws multiple series from the same baseline and can cover series plotted behind it. A Stacked Area chart adds each series to the preceding series, so it communicates a total and each series’ contribution to that total. It does not show independent values in the same way as a line chart. A 100% Stacked Area chart scales each category to 100%, which is useful for comparing proportions but hides changes in the overall total.

Use the chart type that matches the question being asked:

  • Choose Area for one series when the filled magnitude relative to the axis is the point.
  • Choose Stacked Area when series are parts of a meaningful total.
  • Choose Line when comparing several independent series and their exact trends matters more than a filled region.
  • Choose a shaded band when the space between two boundaries has meaning, such as a range or uncertainty interval.

For overlapping, independent series, a regular line chart with one lightly shaded helper band may be easier to read than several opaque area fills. Use color sparingly and consider a legend or direct labels so readers can identify what each shaded region means.

Common shading problems and fixes

  • The fill covers another series: this is common with overlapping Area charts. Reduce transparency, change the series order, or use lines for the independent series instead.
  • The shaded band starts at zero: the chart may be a regular Area chart rather than a Stacked Area chart, or the hidden base series may not be included. Check Chart Design > Change Chart Type and the series list.
  • The band is much too tall: confirm that the helper series contains upper minus lower, not the upper values themselves. Also check that the upper boundary is not below the lower boundary.
  • The chart looks misleading: inspect the vertical axis bounds and baseline. A nonzero minimum can visually exaggerate a filled region or make a small change look large.
  • The wrong part of the chart changes color: select the series, Plot Area, or Chart Area specifically before formatting. The pane title indicates which chart element is selected.
  • Colors are hard to distinguish: use moderate transparency, stronger outlines, or labels. Check the chart against a plain background and in grayscale if it will be printed.

For a chart that updates as new rows are added, consider storing the source data in an Excel table before creating the chart. Charts based on tables generally expand as table data is added, but verify that any helper formulas and series ranges include the new rows. If a helper column is not part of the chart, use Chart Design > Select Data to update the chart’s source range.

Excel on Mac and Excel for the web

The chart concepts and main formatting choices are similar in current Excel for Microsoft 365 on Windows and Mac, but ribbon layout and pane placement can vary. On Mac, select the chart element, then use the Chart Design or Format tab and the formatting pane; right-clicking or Control-clicking a series also opens its context menu. If a named command is not visible in the same place, use the chart’s context menu or search Excel’s command box rather than assuming the feature is absent.

Excel for the web supports common chart creation and formatting, but some advanced chart-type combinations or detailed formatting controls may be limited compared with the desktop app. If you cannot assign area and line types separately in a combo chart, open the workbook in the desktop version of Excel. Check the final result in the version where the chart will be presented, especially when it uses a helper series or custom combination.

Frequently Asked Questions

How do I shade under a line in Excel?
Select the chart and choose Chart Design > Change Chart Type > Area. Then select the area series, open Format Data Series > Fill & Line, and choose a fill color.

How do I shade between two lines in Excel?
Create a helper series equal to the upper line minus the lower line. Plot the lower series and the difference as a Stacked Area chart, make the lower series transparent, and fill the difference series.

How do I change the background color inside a chart?
Right-click inside the axes and choose Format Plot Area, then set its fill. To color the larger chart container, select Format Chart Area instead.

Can I shade only part of an area chart?
Yes. Add a helper series that has values only over the interval to highlight, then format it as a separate series. Confirm how blank cells are plotted and that the fill does not obscure other data.

What is the difference between Area and Stacked Area in Excel?
An Area chart fills each series toward the axis, and overlapping fills can obscure data. A Stacked Area chart adds each series on top of the prior one to show a cumulative total, so use it only when that cumulative meaning is appropriate.

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.