To shade under a line graph in Excel, change the chart to a 2-D Area chart; Excel fills the space between each value and the horizontal axis. To keep a conventional line-chart look, use a combo chart with an Area series behind a Line series, then adjust the area’s fill and transparency.
Use an Area chart for the quickest result
An Area chart is usually the simplest way to show a filled region beneath one data series. It retains the plotted values and their connecting boundary, while adding color between that boundary and the axis. This is useful for illustrating a changing quantity over time, such as monthly website visits, daily temperatures, or a product’s inventory level.
- Select the chart. If you have not made one yet, select the category labels and values in your worksheet, then choose Insert > Insert Line or Area Chart > 2-D Area.
- For an existing line chart, choose Chart Design > Change Chart Type, select Area, and choose the standard 2-D Area option rather than Stacked Area or 3-D Area.
- Select the plotted area, right-click it, and choose Format Data Series.
- In the formatting pane, open Fill & Line. Under Fill, choose Solid fill and select a color. Under Line, choose Solid line if you want to set the outline color and width.
The chart uses the category axis as its baseline. With positive values and a horizontal axis at zero, the fill appears below the line down to zero. If your chart contains negative values, the area extends to the zero line on the negative side as well; it does not necessarily shade down to the bottom edge of the chart.
Keep the original line with a combo chart
If you want the familiar appearance of a line chart, with a distinct line visible over a softer colored region, combine two copies of the same data series. Use one copy as an area and the other as a line. The area provides the shading, and the line provides the crisp boundary. This approach also gives you more control over line thickness and color than relying on the Area chart’s outline alone.
- Keep the original line chart, and make sure its category labels and values are arranged as intended in the worksheet.
- Select the chart and choose Chart Design > Select Data > Add. Set the series name and series values to the same heading and values used by the existing line series. The added series should use the same categories as the original.
- Choose Chart Design > Change Chart Type > Combo. Set one copy to Area and the other to Line. Leave both on the primary axis when they represent the same measure and share the same scale.
- In the Select Data Source dialog, arrange the area series before the line series if the line is hidden by the fill. Excel generally draws later series over earlier ones, so the line should be in front.
- Format the area series with a fill color and the line series with the line color and width you want. If the original line is already styled, apply the line type to the original series and use the duplicate as the area.
Combo-chart controls and labels can look slightly different between Excel releases. In Excel for Microsoft 365 on Windows, the paths above use the Chart Design tab. Excel for Mac has corresponding chart-design and formatting controls, although the dialog layout can differ. In Excel for the web, available chart-formatting options may be more limited, so use the desktop app if you cannot find a particular combo-chart or fill setting.
Choose a fill color and transparency
A strong fill can obscure gridlines, markers, and other series. A pale color or a fill with transparency usually makes the shaded region easier to read. Select the area, open Format Data Series, and use Fill & Line > Fill to choose a solid fill and adjust Transparency. The exact controls shown can depend on the selected series and Excel version.
Choose a fill that contrasts with the plot background but does not compete with the line. For example, a medium-blue line can sit over a light-blue fill. If the chart has several series, reserve a different hue for each filled area only when the categories and values remain easy to distinguish. Avoid relying on color alone to communicate meaning: keep clear axis labels, a useful legend, and a visible line.
Markers are optional. They can help readers identify individual observations in a small data set, but become cluttered when there are many points. To control them, select the line series and use Format Data Series > Fill & Line > Marker. You can keep markers on the line while leaving them off the duplicate area series.
Prepare the data and check the baseline
A chart can only shade the values it receives. Put the category labels in one column and the numeric observations in the next, with a clear header for each. Select the complete range, including headers, when creating the chart. If Excel puts the wrong items on the horizontal axis or treats a value column as a category, open Chart Design > Select Data and check the series and category-label ranges.
For a time series, use dates in chronological order. If the dates are stored as text, Excel may space them as ordinary categories rather than treating them as dates. That can change the apparent spacing between observations. Check the horizontal axis settings if uneven time intervals matter to the story you are presenting.
The axis minimum affects how a chart looks, but it does not change the data. If the horizontal axis is set to cross at a value other than zero, the apparent shaded baseline may not match what a reader expects. For standard positive quantities, a zero baseline is often the clearest reference. For a measure whose meaningful reference is another threshold, consider adding that threshold explicitly and labeling it rather than silently changing the axis scale.
Missing observations need attention too. A blank cell is not the same as a measured zero: zero is a real value that will be plotted, while a blank represents no observation. In Chart Design > Select Data, choose Hidden and Empty Cells to review how empty cells are displayed. Depending on the chart and setting, gaps may appear or Excel may connect points across a blank. Choose the treatment that accurately represents the data, and do not use zero values as substitutes for missing values unless zero is genuinely correct.
Pick the right chart type for your data
Use a standard Area chart when the main purpose is to emphasize the magnitude of one series against a common baseline. Use the duplicate-series combo method when you want a line drawn clearly over its fill. A Line chart without shading is often better when the main task is comparing the direction or timing of several series, especially when their values overlap.
Avoid Stacked Area for a simple shaded line. A stacked chart adds series values on top of one another, so the upper boundary represents a cumulative total rather than each series’ original values. That may be appropriate for showing how components contribute to a whole, but it changes the interpretation. A 100% Stacked Area chart changes it further by showing each series as a share of the total.
Area charts can also make comparisons harder when values cross or when several filled series overlap. The first series may obscure later fills, and readers may mistake the visible boundary for an individual series. If comparison between series is the goal, use lines with distinct colors or markers, or consider small separate charts instead of layering opaque fills.
Shade between two lines instead of down to zero
Shading between an upper and lower line is a different task from shading under one line. An Area chart fills to the category axis; it does not automatically fill only the band between two arbitrary series. For a band such as a forecast range, confidence interval, or high-low spread, a common charting approach is to create helper data: a lower-bound series and the difference between the upper and lower bounds. Plot the lower series as a stacked area with no visible fill, then plot the difference as a filled stacked area. The visible band then runs from the lower value to the upper value.
This method requires careful setup. The bounds must be numeric and aligned to the same categories, and the difference must not be negative if the intended upper bound is always greater than the lower bound. If the bounds cross, decide how that should be represented before charting. Keep the helper series in the worksheet and label them clearly so a future editor can understand why the chart uses stacked areas. For an ordinary single line shaded to zero, this extra construction is unnecessary.
Fix common shading problems
- The line disappears: In a combo chart, make sure one series is set to Line and the duplicate is set to Area. Move the line series later in the series order if the fill covers it, and confirm the line is not formatted as No line.
- The fill covers the wrong space: Check whether the chart is Stacked Area, whether the horizontal axis crosses at zero, and whether the series contains negative values. A stacked chart fills cumulatively rather than independently.
- The chart has an unexpected color or outline: Select the data series itself, not the chart area or plot area, before opening Format Data Series. Those chart parts have separate formatting controls.
- There are gaps or unexpected connections: Check the source cells for blanks, text, or error values, then review the Hidden and Empty Cells setting. Do not replace missing readings with zero just to close a gap.
- The legend shows duplicate entries: A combo chart built from duplicate data has two series, so Excel may display both in the legend. You can rename the series in Select Data or remove a redundant legend entry if the remaining legend still identifies the plotted information clearly.
Make the chart easier to read and share
Give the vertical axis a title and units when values could be ambiguous; “Revenue” alone, for example, is less informative than “Revenue (thousands of dollars).” Keep a chart title that describes the measure and time period, and use the same number format in the axis labels and worksheet where practical. A filled chart can make a small change look large if the vertical axis is cropped, so check the axis minimum and maximum before presenting it.
For accessibility, use strong contrast between the line, fill, and background, and do not encode important distinctions only by color. Add a descriptive chart title and, where appropriate, alternative text through the chart’s context menu or formatting options. If the chart will be printed in grayscale, test whether the line and fill remain distinguishable; a patterned or very light fill and a heavier line can help.
When copying the chart into a presentation or document, check it at the size readers will see. A transparent fill that looks subtle on a monitor may print too faintly, while a dark fill can hide gridlines in a small image. Keep the source data and chart together in the workbook so the chart can be checked or updated later.
Frequently Asked Questions
Can I shade under a line in Excel without changing it to an Area chart?
Yes. Add a duplicate of the line’s data series, set the duplicate to Area and keep the original as Line in a combo chart. The area supplies the fill, while the original series keeps a clear line on top.
Why does my shaded area go to zero?
A standard Area chart fills between the data and its axis baseline, usually zero. If you need shading between two lines or between a line and a nonzero threshold, use a different setup, such as a stacked-area band or a separate helper series.
Should I choose Area or Stacked Area?
Choose standard Area when you want each series shown against the common axis baseline. Choose Stacked Area only when the cumulative total is meaningful and you want to show how series contribute to it. Stacking changes the values represented by upper boundaries.
Can I make the fill transparent?
Yes. Select the area series, open Format Data Series, and adjust Transparency under Fill & Line > Fill. Use enough opacity for the shaded region to be visible, while keeping the line, labels, and gridlines readable.
Can Excel shade only the region between two lines?
Not with the ordinary Area chart setting by itself. A common solution is a stacked-area chart using a hidden lower-bound series and a visible series for the difference between the upper and lower bounds.
Related
- Excel Savings Plan Template: Build a Monthly Goal Tracker
- Excel Script: Set Number Format in a Range
- Excel Save Custom Number Formats: A Practical Guide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Line Charts: Ignore Blank Cells or Show Gaps?Yes. In Excel for Microsoft 365 on Windows, select the line chart, choose Chart Design > Select Data…
- Create a Speedometer Chart in Excel: A Step-by-Step GuideTo create a speedometer chart in Excel for Microsoft 365 on Windows, arrange your gauge bands as values…
- Creating a Waterfall Chart in Excel: A Step-by-Step GuideTo create a waterfall chart in Excel for Microsoft 365 on Windows, put each step of the change…
- Excel Column Chart: Two Axes Without OverlapYes—Excel can plot column data on two vertical axes, but the columns will commonly overlap because each axis…
- Add a Filter to an Excel Line Chart: How It Really WorksTo add a filter to an Excel line chart in Microsoft 365 for Windows, select the chart, click…
- How to Insert a Dynamic Excel Chart in PowerPointTo insert a dynamic Excel chart in PowerPoint for Microsoft 365 on Windows, select the chart in Excel,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.