Yes. In Excel for Microsoft 365 on Windows, you can shade selected sections of an area chart by adding a helper data series, formatting it as a partially transparent area, and placing it behind the main series. For a one-off highlight that does not need to follow changing data, a translucent rectangle is often quicker.
What “shading a section” can mean
There are a few different effects people mean by shading part of an Excel area chart. Choosing the right method matters because the chart’s geometry and the data determine where the fill appears.
- Highlighting a date or category range: shade a vertical band behind the data for a period such as a promotion week or a recession.
- Filling under a data series: this is the standard area-chart effect. The plotted series is filled down to the chart’s horizontal axis.
- Filling between two values or series: use a band to show a confidence interval, target range, or difference between actual and planned values.
- Emphasizing a manually selected part of the picture: place a shape over the chart. This is visual annotation rather than a data-driven chart feature.
An area chart does not have a general “shade this arbitrary section” command. Its fills are connected to plotted data and the axis, so a helper series is the flexible choice when the highlighted range should move as the data changes.
Shade a date or category range with a helper series
This method adds a second area series whose values rise to the top of the chart only during the selected range. The main data series remains visible as a line on top. The example assumes dates are in column A and the charted measurements are in column B, with headers in row 1 and data in rows 2 through 10.
- In C1, enter a label such as Highlight. In C2, enter the formula below, then fill it down through C10. It returns 100 for dates from January 5 through January 7, 2026, and #N/A for other dates. This example assumes the chart’s vertical scale should run from 0 to 100.
With dates in A2:A10, measurements in B2:B10, and the helper series in C2:C10, use this formula in C2:
=IF(AND(A2>=DATE(2026,1,5),A2<=DATE(2026,1,7)),100,NA())
For example, a row dated January 6 returns 100; a row dated January 4 returns #N/A. Change the dates and the 100 to match the range and vertical-axis maximum you need. If the axis maximum is not 100, use its maximum value instead. The formula uses Excel’s real NA function so out-of-range dates are not plotted as zero-valued points.
- Select the chart, then choose Chart Design > Select Data. Add the Highlight series using C1 as its series name and C2:C10 as its values. Make sure its category labels align with the same dates or categories as the existing series.
- Choose Chart Design > Change Chart Type, then select Combo. Set Highlight to Area and set the original measurement series to Line. Keep both on the primary axis for this example.
- Choose Chart Design > Select Data again. In the series list, move Highlight before the measurement series, if necessary. Excel plots later series over earlier ones, so the main line should be above the shaded fill.
- Click the Highlight fill and open Format Data Series. Under Fill & Line, choose a solid fill, pick a color, and increase transparency until the original data is easy to read. Remove the helper series’ border if it creates distracting edges.
Check the result at the beginning and end of the highlighted range. Area charts connect category points, so the fill may taper between categories at the boundary rather than form a perfectly precise vertical edge. With daily categories, that may be acceptable; for exact calendar boundaries, use a shape or add data points at the boundary dates. If the chart is a date axis, verify that Excel is treating the horizontal axis as dates, not merely as text labels.
Use a rectangle for a quick, fixed highlight
If the section is simply an annotation—for instance, marking the quarter when a system outage occurred—a shape can be faster than adding chart data. Select the chart first, then use Insert > Shapes and choose a rectangle. Draw it over the plot area, format its fill color and transparency, and set its outline to no line. Keep the shape narrow enough to mark the period without hiding the series or axis labels.
A shape is not tied to specific dates or values. If you resize the chart, change its axis scale, filter categories, or add data, you may need to reposition or resize the rectangle yourself. Avoid assuming a shape will remain aligned to the same date after the chart changes. To preserve the annotation with the chart when moving it, insert the shape while the chart is selected and confirm it behaves as part of the chart object in your workbook.
Shade the area between two series
A different task is filling the space between an upper and lower boundary, such as a forecast and its lower confidence limit. A conventional area series fills toward the axis; it does not automatically fill only the gap between two lines. A common charting technique is to use a stacked area chart with a hidden base series and a visible band series. The base represents the lower boundary, and the band represents the difference between the upper and lower boundary. The band then appears to occupy the space above the base.
This requires helper values that are valid for every category and a chart type suited to the data. Format the base series with no fill and no line, and give the band series a transparent color. If you also need a line showing the upper or actual value, use a combo chart and plot that series as a line over the area. Check that the boundaries never cross unexpectedly: stacked areas accumulate values, so incorrect or negative band widths can produce a misleading picture. For a simple two-line comparison, two lines may communicate the information more clearly than a filled band.
Format the fill so the chart stays readable
Use a light, restrained fill. A strong opaque color can hide the main series, gridlines, or labels, especially when the helper area reaches the full height of the plot. In Format Data Series, adjust transparency and remove an outline if the boundary is not meaningful. Keep the same shade consistent if several sections have the same meaning, and use a legend entry or a nearby chart note to explain what the color represents.
Check axis bounds as well as color. The helper series needs to reach the top of the plot to create a full-height background band, so a fixed value such as 100 only works when the vertical axis maximum is also 100. If Excel automatically expands the axis after you add the helper series, set the vertical axis maximum deliberately through Format Axis. When the real data later exceeds that limit, revisit the axis and helper values so the chart does not clip meaningful data.
Common problems and their fixes
- The highlight covers the main series: move the helper series earlier in the series order and the line series later, then reduce the fill opacity. Confirm the line is actually set to Line in the combo settings.
- The fill appears across the whole chart: inspect the helper values and category references. A formula copied incorrectly or a series range that includes the wrong cells can make every category qualify.
- The shaded band has sloping edges: area charts join adjacent category points. Add boundary categories where appropriate, or use a rectangle when exact vertical edges matter more than automatic updating.
- The chart gains a large unwanted vertical scale: the helper value may exceed the existing axis maximum. Set the axis bounds intentionally, and use a helper height that reaches the desired plot top.
- The helper series appears as a legend item: edit the legend or rename the series to a clear label such as Promotion period. Do not leave a cryptic helper-column heading for readers.
- Dates are out of order or treated oddly: sort the source data chronologically and check the horizontal-axis settings. Text that looks like a date may not be stored as a real Excel date.
Also check how blanks and errors are represented. A helper formula returning #N/A is generally useful for excluding categories, but test the chart after adding it, particularly when the series is an area. The Chart Design > Select Data > Hidden and Empty Cells options let you control how empty cells are displayed; they do not replace checking the actual formula results and chart type.
Area chart versus shapes, columns, and conditional formatting
Use a helper area series when the highlighted period is defined by source data and should update as that data changes. It is suitable for a chart that is refreshed regularly, though ranges, axis limits, and date boundaries still need to be maintained. Use a rectangle for a presentation annotation that is intentionally fixed and does not need to respond to new data.
If each period is a separate category and the goal is to color particular categories, a column chart may be simpler: individual columns can be formatted to distinguish selected categories. Conditional formatting changes worksheet cells, not the rendered chart area, so applying a fill to the source cells does not automatically shade the same region in the chart. For threshold zones that communicate ranges such as low, acceptable, and high, helper series can be more maintainable than drawing several shapes, provided the chart is built with the correct stacked-area or combo structure.
Excel for Mac and Excel for the web
In current Microsoft 365 Excel for Mac, the underlying approach is similar: add a helper series, change the chart type, and format the series. Ribbon wording and the placement of formatting controls can differ slightly by update, so look for Chart Design, Select Data, and the series formatting pane. The Windows instructions above use ribbon paths for Microsoft 365 on Windows.
Excel for the web supports many chart edits, but some detailed chart-formatting and combo-chart options may be limited or arranged differently from the desktop app. If you cannot select an individual series or set the required combo type in the browser, open the workbook in desktop Excel. The workbook’s data and chart can still be shared, but verify the finished appearance in the version where it will be presented.
Frequently Asked Questions
Can I shade only one date range in an Excel area chart?
Yes. Add a helper series that has a value only for the selected dates, format it as an area, and place it behind the main line or series. For a fixed annotation, add a transparent rectangle instead.
Can I shade above a line instead of below it?
Yes, but a regular area chart fills toward its baseline, not automatically toward the top of the plot. A helper series reaching the axis maximum can create a full-height section, while a between-series band needs a stacked-area setup or another chart construction.
Why does my area chart fill the entire chart?
Usually the helper series contains valid values for every category, or its date test is not matching the source dates as intended. Check the helper cells and confirm that only the intended categories return a plotted value.
Can I use a different color for each shaded section?
Yes. Add a separate helper series for each section and format each with its own fill color. Keep the series order behind the main line, and consider using a legend or labels so the colors have an understandable meaning.
Will the shaded section move when I add data?
A formula-driven helper series can update when its source range and chart range include the new data. A manually drawn rectangle will not track dates or values automatically, so it may need repositioning after chart changes.
Related
- Excel Custom Number Format for Millions
- Excel Custom Number Format: Show Numbers in Thousands
- Excel Shortcut to Select the Rest of a Column Down
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Grouped Stacked Bar Chart: How to Create OneExcel does not offer a built-in chart type that combines clustered bars with stacked segments. You can create…
- How to Make a Histogram in Excel With Custom BinsTo make a histogram in Excel, select your numeric data, choose Insert > Insert Statistic Chart > Histogram,…
- Excel Pivot Table Percentage of Total: How to Show ItTo show Excel PivotTable values as a percentage, right-click a value in the PivotTable and choose Show Values…
- Circle Bullet Chart in Excel: A Step-by-Step GuideCreate a circle bullet chart in Excel by plotting an actual value and the unused portion of a…
- Excel Pivot Table: How to Highlight Subtotal RowsYes. In Excel for Microsoft 365 on Windows, the most reliable way to highlight PivotTable subtotal rows is…
- Excel Pivot Table Tabular View: Setup and FormattingTo display an Excel PivotTable in tabular view, click inside the PivotTable and choose PivotTable Design > Report…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.