To put shaded area under an Excel line, change the chart to an Area chart, or make a combo chart with an Area series behind a Line series. For the cleanest result with a visible outline or markers, duplicate the values, assign one copy to Area and the other to Line, and plot both on the same axis.
What an area chart adds to a line chart
A standard line chart emphasizes how values change from one category or date to the next. An area chart adds a fill between the plotted values and the chart’s baseline, making the size of the values more visually prominent. Excel does not have a single chart type literally called “line chart with area”; the effect comes from using an Area chart or combining area and line series.
For example, a monthly visitors chart can use a pale blue fill to make the overall volume easy to see and a dark blue line to keep month-to-month movement sharp. The fill is not an extra measurement: it represents the same values as the line. Use it when that visual emphasis helps, rather than suggesting that the filled region is a separate total or quantity.
There are two useful approaches:
- Area chart: The simplest choice when you want one series filled beneath its boundary.
- Area-and-line combo: Better when you want independent control over the fill, line weight, markers, or legend labels.
Turn a line chart into an area chart
If your chart already exists and only needs a fill, changing its type is the quickest method in Excel for Microsoft 365 on Windows:
- Select the chart.
- Open Chart Design > Change Chart Type.
- Choose Area, then select 2-D Area for a conventional flat chart.
- Select OK.
The chart retains its data, but the fill changes how it reads. Excel’s area chart normally includes an outline along the data series. To adjust its appearance, right-click the area and choose Format Data Series. In the formatting pane, use Fill & Line to choose a solid fill, transparency, and line color or width. A light fill with some transparency often keeps gridlines and overlapping details legible.
If you are making a chart from scratch, select the category labels and values, then use Insert > Insert Line or Area Chart and choose an Area option. The exact ribbon layout can differ with window size, but the chart type is in the Insert tab’s chart controls. A basic Area chart is usually the right starting point for one series.
Keep a crisp line on top of the shaded area
An Area chart may be enough when its boundary already looks clear. If you want markers at each observation, a stronger outline, or separate formatting for the line and fill, overlay a Line series. The reliable method is to supply the same values twice: one series provides the fill and the other draws the line.
- In the worksheet, keep the dates or categories in one column and the measured values in another. Copy the values into a second column and give the two series clear names, such as “Area” and “Line.”
- Select the category column and both value columns. If a chart already exists, adding the duplicate series may be done through Chart Design > Select Data.
- Choose Chart Design > Change Chart Type, then select Combo or Create Custom Combo Chart, depending on the dialog shown.
- Set the “Area” series to Area and the “Line” series to Line. Leave both on the primary axis when they represent the same measurement.
- Confirm the chart, then format the fill and line separately with Format Data Series.
Make sure the line is drawn above the fill. In Chart Design > Select Data, use the series-order controls to put the area series earlier and the line series later if the fill obscures the line. Excel’s drawing order can affect which series appears on top, so check the finished chart rather than assuming it from the legend order. Name the two series clearly; if the legend becomes confusing, remove it or position it where readers can distinguish the filled area from the line.
Both copies should use the same categories and values. If the two series differ accidentally—for example, one copy omits a month—the line and fill will no longer match, which can create a false impression.
Choose the right area style and baseline
For one measurement, choose a regular Area chart, not Stacked Area. A stacked chart adds each series to the series below it, so its upper boundaries represent cumulative totals rather than the individual series’ original values. That can be useful for showing composition over time, but it is not the right way to shade beneath a single line.
The fill is drawn down to the chart’s baseline. With a value axis that includes zero, positive values typically fill toward zero. If the vertical axis is set to a nonzero minimum, or if the axis crossing is adjusted, the visual baseline can change. Check Format Axis before interpreting the filled area: a cropped range may magnify small changes, while a zero-based range may make those same changes look flatter.
Area charts can also be a poor fit for negative values or data that repeatedly crosses zero. A filled region on both sides of the baseline may be harder to read than a line chart. In those cases, consider leaving the chart as a line chart, using distinct colors for positive and negative values, or separating the series into panels.
Style the chart so the fill supports the data
Use a restrained fill color and make the boundary line darker than the area. A strong opaque fill can hide gridlines, labels, and other series; transparency can help, but too much makes the chart appear washed out. A useful hierarchy is a light fill, a clearly contrasting line, and subtle gridlines.
- Markers: Use them when individual observations matter, such as a small set of quarterly results. They can clutter a daily or hourly time series with many points.
- Gridlines: Keep only the horizontal gridlines that help estimate values. Heavy gridlines compete with the filled shape.
- Legend: Use descriptive series names. In a duplicated-series combo, an “Area” and “Line” legend entry may be unnecessary if both show the same measure.
- Axis labels: Include units and a useful time scale so readers know whether the values are dollars, counts, percentages, or something else.
For a long time series, a line with a modest fill is generally more readable than a saturated block. If there are many categories, check that the date labels have not become crowded; changing the axis label interval or widening the chart can improve readability without changing the data.
Area chart compared with line and stacked area
A line chart is usually best when the main task is comparing trends, especially when several series overlap. Lines make crossings and differences easier to follow because they do not cover the plot below them. An area chart is useful when the magnitude of a single series should feel visually substantial, such as total monthly demand.
A stacked area chart answers a different question: how component values contribute to a total over time. If product categories are stacked, only the bottom series shares a common baseline; the upper series are placed above the values below them. Their changing boundaries therefore do not show each category’s individual value as directly as separate lines do. When comparing exact component trends matters, use a line chart or small multiples instead.
For multiple ordinary area series, overlapping fills may conceal the series plotted underneath. A combo chart does not automatically solve that problem; it is most helpful when a single filled series needs a visible line overlay. If you need to compare several series, use distinct lines, a stacked area chart only when cumulative composition is the intended message, or another chart type suited to the comparison.
Fix common Excel chart problems
The fill hides the line. Check the series order in Chart Design > Select Data and place the line series after the area series. Also use a darker line and lighter fill. If the line and fill still look identical, confirm that the combo chart has two series and that each is assigned the intended chart type.
The chart looks like a solid block. The fill may be too dark, or the values may change little relative to the axis range. Reduce the fill intensity, add a clear boundary line, and inspect the axis bounds. Do not narrow the axis merely to create drama; choose limits that make the size of the changes understandable.
There are gaps or unexpected drops. Check the source data for blank cells, text stored in place of numbers, or missing dates. Select the chart and open Chart Design > Select Data > Hidden and Empty Cells to choose how empty cells are displayed, such as gaps, zero, or connected data points. A zero is not equivalent to a missing observation, so choose the option that matches what the blank means.
The shaded region does not match the line. Compare the category ranges and values in both series. The duplicated series must use the same rows and order. Also make sure one series has not been placed on a secondary axis; different axis scales can make identical values appear misaligned or distort their apparent relationship.
The area chart implies a total that is not real. Confirm that you selected regular Area rather than Stacked Area. Stacking changes the meaning of the upper series and can make the chart appear to show cumulative values.
Windows, Mac, and Excel for the web
The steps above describe Excel for Microsoft 365 on Windows. In current Excel for Mac, chart type and formatting controls are also available from the chart design and format controls, although their placement and dialog layout can differ. Look for Change Chart Type, Select Data, and Format Data Series after selecting the chart.
Excel for the web supports common chart creation and formatting, but some detailed chart editing controls may be limited or presented differently from desktop Excel. If the web interface does not expose the combo chart or series-order option you need, open the workbook in the desktop app to finish the formatting. Check the workbook after editing, especially if the chart is shared with people using another Excel version.
Frequently Asked Questions
Can I fill the area under a line in Excel without making a second series?
Yes. Change the chart type to Area or 2-D Area. A second, duplicate series is only needed when you want the fill and line to have independent formatting, or when you want line markers on top of the filled area.
How do I make an area chart transparent in Excel?
Select the area, right-click and choose Format Data Series, then open Fill & Line and adjust the fill transparency. The exact controls can vary by Excel interface, but they are in the series formatting pane.
Why is my line behind the area in a combo chart?
The area series is likely being drawn over the line. Open Chart Design > Select Data and move the line series later in the series order, then confirm that the line is assigned to Line and the shaded series to Area.
Should I use stacked area or regular area?
Use regular Area when you want to show one series filled to its baseline. Use Stacked Area only when you intend the chart to show how multiple series add up to a cumulative total over time.
Can an Excel area chart show negative numbers?
Yes, but the fill can be harder to interpret when values cross zero or extend below it. Check where the horizontal axis crosses the value axis and consider using a line chart if the filled regions make positive and negative changes unclear.
Related
- Excel Interpolation: How to Estimate Values Between Points
- Microsoft Excel Invoice Template: Find and Customize
- Excel: Insert a Checkbox Without the Developer Tab
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Behavioral Economics and Graph Theory: How They ConnectBehavioral economics and graph theory connect when economists use networks to study how people’s choices are shaped by…
- Excel Pivot Chart Grand Totals: What You Can and Can’t ShowNo: an Excel PivotChart does not display the PivotTable’s grand total as a charted category or series. You…
- Excel Trendline Values: Show and Calculate ThemYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element…
- Insert an Excel Graph Into Word and Keep It UpdatedTo insert an Excel graph into a Word document, select the chart in Excel, copy it, then paste…
- Excel Pivot Table Formula Shortcuts and Calculated FieldsExcel has no single dedicated shortcut for inserting a formula into a PivotTable. To add a calculated field…
- Excel Waterfall Chart Data Labels: Add and Format ThemTo add labels to an Excel waterfall chart in Microsoft 365 for Windows, select the chart, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.