To add a shaded area to an Excel chart, use an area series for the region you want filled, then format its color and transparency. For shading beneath a line, combine an area series with a duplicate line series; for a band between two values, build a stacked-area band with helper columns and overlay the line.
Choose the kind of shaded area
“Shaded area” can mean more than one thing. Picking the right chart setup first saves rework, because an area chart fills down to its baseline, while a range band needs to be defined by two boundaries.
- Fill beneath a curve: Useful for showing volume over time, such as website visits per day or cumulative rainfall. The fill extends from the plotted line to the chart’s baseline.
- Highlight a range: Useful for a forecast interval, acceptable operating range, or low-to-high estimate. The shaded band sits between a lower and an upper value.
- Emphasize a time period or category: A colored chart background or a manually placed shape can mark a period, but it is less closely connected to the data and may not move correctly when the chart changes.
For a filled curve, an ordinary Area chart may be all you need. For a shaded range between two changing boundaries, use a Stacked Area chart for the band. These techniques use native Excel chart series, so the shaded region updates when its source data changes.
Shade the area beneath a line
If the filled shape itself is enough, select the category labels and values, then choose Insert > Insert Line or Area Chart > Area. Excel creates an Area chart that fills from each value down to the baseline. Choose this option when you do not need a separate, crisp line drawn over the fill.
To show both a clean line and a translucent fill, plot the same values twice: once as an area and once as a line. With dates in column A, measurements in column B, and a duplicate of those measurements in column C, select the data and create a chart. In Insert > Insert Combo Chart > Create Custom Combo Chart, set the duplicate series in column C to Area and the original series in column B to Line. Keep both on the primary axis when they use the same units.
- Arrange the data with one category column and two identical value columns, each with a clear heading.
- Select the data, including its headings, and open the custom combo-chart dialog.
- Assign Area to one copy and Line to the other. Confirm that both series use the same axis unless there is a specific reason not to.
- If the line is hidden, use Chart Design > Select Data to adjust the series order. Put the area series before the line series so the line is drawn on top.
- Right-click the area series and choose Format Data Series. In the formatting pane, open Fill & Line > Fill, select Solid fill, choose a color, and adjust Transparency.
- Format the line series separately so it has a visible line color and width. Add a chart title, axis titles, and a legend only if they help explain the data.
For example, if daily values rise from 12 to 18 to 14, the area series fills beneath those points and the line series traces the same path. A transparency setting lets gridlines remain visible through the fill. The fill does not represent a second measurement; it is a visual treatment of the values already plotted.
Create a shaded band between two values
A forecast interval or acceptable range needs two boundaries. Excel does not have a universal “shade between any two lines” button for standard line charts, but helper columns and a Stacked Area chart provide a dependable workaround. The lower boundary becomes an invisible base, and the difference between the upper and lower boundaries becomes the visible band.
Suppose dates are in A2:A6, actual values are in B2:B6, lower bounds are in C2:C6, and upper bounds are in D2:D6. Add headings in E1 and F1: Base and Band. The Base column should equal the lower bound. With the lower bound in C2, enter =C2 in E2; for example, if C2 is 10, the result in E2 is 10. Fill the formula down the column. The Band column is the distance from the lower to the upper bound. With the upper bound in D2 and lower bound in C2, enter =D2-C2 in F2; if D2 is 16 and C2 is 10, the result is 6. Fill that formula down too.
Select the date, actual, Base, and Band columns, then create a custom combo chart. Set Base and Band to Stacked Area and Actual to Line. Keep the two area series stacked together and use the same value axis for the line if the values share units. In Chart Design > Select Data, arrange the Base series before Band, and place the Actual line after the area series if needed.
Format the Base series with No fill so it is not visible, then give Band a solid color and adjust its transparency. The stacked series total reaches the upper boundary: the invisible Base contributes the lower value, and the visible Band contributes the difference. The actual line then appears over the shaded interval. Check a few plotted points against the source values, especially if your lower and upper bounds cross or contain blanks.
Make the shading easy to read
Formatting should clarify the relationship between the data and the fill, not compete with it. A saturated color at full opacity can hide gridlines, overlap other series, and make the chart difficult to interpret. A lighter fill or increased transparency often leaves the boundary line and data markers more legible.
- Use one restrained fill color for a single interval; use contrasting colors only when they communicate distinct categories.
- Keep the line darker or more prominent than its matching fill.
- Use a legend label such as “Forecast range” rather than a vague label such as “Series 3.”
- Set a sensible value-axis minimum and maximum, but avoid cropping the chart in a way that exaggerates small changes.
- For a filled curve, make clear whether the fill runs to zero or to another meaningful baseline.
To change the chart’s axis bounds, right-click the value axis, select Format Axis, and adjust the bounds in Axis Options. The available settings depend on the chart type and data. If a band is intended to represent a particular range, ensure the axis scale does not make that range look broader or narrower than it is.
What happens with dates, gaps, and negative values?
Area charts are best suited to ordered categories, often dates. If dates appear at uneven intervals but Excel treats them as equally spaced categories, the chart may show equal spacing even when the actual time gaps differ. Check the horizontal axis settings and chart type if spacing matters; a Scatter chart is often more appropriate when the horizontal values are numeric and their distances must be represented proportionally. A Scatter chart does not offer the same straightforward area-fill workflow, so a different chart design may be needed.
Blank cells can also change the appearance of a filled series. A gap may appear as a break, or Excel may connect across it depending on the chart’s settings and data arrangement. In the chart, choose Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed. Avoid replacing missing observations with zero unless zero is the real value; doing so can create a misleading drop in the shaded area.
Negative values require particular care. Area fills are drawn relative to the axis baseline, and positive and negative portions can appear on opposite sides of zero. If your range-band helper values are negative or the lower boundary is above the upper boundary, verify the chart carefully. A band calculation assumes the upper bound is at least as large as the lower bound at each point; reverse bounds can produce a negative Band value and an unexpected result.
Common problems and fixes
- The line disappears behind the fill: Change the series order so the area series is plotted first and the line is plotted afterward. Also check that the line series is set to Line, not Area.
- The shaded band starts at zero instead of the lower bound: Confirm that Base and Band are both set to Stacked Area, that Base is the first area series, and that Base contains the lower-bound values. An ordinary Area chart will not stack the band above that base.
- The band looks too tall or too small: Check whether the Band formula subtracts lower from upper, not upper from lower in the wrong columns. Inspect the axis bounds and make sure Excel has not put one series on a secondary axis.
- The fill hides labels or another series: Increase transparency, choose a lighter color, or simplify the chart. A secondary axis should not be used merely to change the visual position of a series.
- The chart changes shape when data is added: Check whether the new rows are included in the chart’s source data. Converting the source range to an Excel table can help charts include newly added rows, though chart behavior should still be checked after the layout changes.
Area chart, combo chart, or a manual shape?
An Area chart is the simplest choice when you want to show the magnitude of one series relative to a baseline. It is quick to create and updates with its values, but the filled region can obscure other series. A combo chart is more flexible: it can show a filled area and a distinct line together, or combine a line with a stacked range band. It takes more setup and depends on the helper columns being correct.
A manually inserted rectangle can highlight a fixed period, such as a shutdown window, but it is a visual annotation rather than data-driven shading. It may need repositioning if the axis scale, chart size, or categories change. For a range that changes from day to day, use chart series instead of a shape; for a one-off presentation highlight, a shape may be adequate if you verify its placement after editing the chart.
On Excel for Mac, chart creation and series formatting are available, but ribbon labels and pane layout can differ from Windows. Excel for the web also supports many chart edits, though some advanced chart-type or formatting controls may be limited or arranged differently. If you cannot find a specific combo-chart control, open the workbook in desktop Excel for Microsoft 365 on Windows or Mac.
Frequently Asked Questions
Can I shade only the area under a line in Excel?
Yes. Create an Area chart for a simple fill, or use a combo chart with duplicate values plotted once as Area and once as Line to keep a distinct line over the fill.
Can Excel shade the space between two lines?
Yes, using a helper-column method. Plot the lower bound as a transparent Base area and the difference between the upper and lower bounds as a visible Stacked Area series, then overlay the other line.
How do I make the shaded area transparent?
Right-click the area series, choose Format Data Series, then use Fill & Line > Fill > Solid fill and adjust the Transparency setting.
Why is the fill covering my line?
The area series is probably plotted after the line series. Use Chart Design > Select Data to move the area series earlier in the plot order, or move the line later so it appears on top.
Can I shade a target zone without changing my data?
A manual shape can mark a fixed zone, but it may not follow the chart when values or axes change. A helper-series band is usually the better choice when the target zone is data-based or needs to update.
Related
- How to Combine Two Cells in Excel and Keep Both Values
- Column J Number in Excel: How to Find and Use It Easily
- Excel Column K Number: What It Means and How to Find It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Distribution Charts: Types and SetupA Google Sheets distribution chart is usually a histogram: it groups numerical values into ranges, or bins, and…
- Excel Pivot Chart Secondary Y Axis: How to Add OneYes. In Excel for Microsoft 365 on Windows, select a PivotChart data series, open Format Data Series, and…
- Excel Mini Chart in Cell: Add and Format SparklinesIn Excel, a mini chart displayed in a worksheet cell is called a sparkline. In Excel for Microsoft…
- How to Add a Second Y Axis to an Excel Column ChartTo add a second y-axis to an Excel column chart, select the data series that needs its own…
- Microsoft Excel Dashboard: Build, Design, and Use OneA Microsoft Excel dashboard is a visual summary of important data, usually built from tables, PivotTables, charts, and…
- Pivot Table Charts in Excel: Create, Format, and UseYes. In Microsoft Excel for Microsoft 365 on Windows, click inside a PivotTable, choose PivotTable Analyze > PivotChart,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.