Excel Line Chart With Shaded Area: How to Make One

Charts & pivot tables · Updated November 19, 2026

To make an Excel line chart with a shaded area beneath the line, create a combo chart from two copies of the same data series: set one copy to Area and the other to Line. In Excel for Microsoft 365 on Windows, select the data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign the two chart types, and keep both series on the primary axis.

What a shaded-area line chart shows

A shaded-area line chart combines two visual cues. The line shows how a measurement changes across categories or time, while the filled region draws attention to the amount between the line and the chart’s baseline. It can make the overall size or movement of a series easier to see, especially in a presentation or dashboard.

Excel’s ordinary Line chart connects the data points but does not fill beneath them. An Area chart does fill from the plotted values toward the horizontal axis, but its line and fill formatting options may not give you the exact look or emphasis you want. Overlaying an Area series and a Line series gives you separate control over the fill and the line.

The phrase “shaded area” can also mean a band between two lines, such as actual sales and a target, or a confidence range around a measurement. That is a different charting task: a basic Area chart shades toward the axis baseline, not automatically between any two series. The distinction matters because the wrong chart can suggest the wrong meaning.

Prepare the data and duplicate the series

Arrange the source data in columns, with time periods or categories in the first column and the values in the next. For example, put Month in A1 and Revenue in B1, then enter Jan through Jun in A2:A7 and 12, 15, 14, 19, 17, and 22 in B2:B7. These values might represent thousands of dollars; label the unit clearly if that is what they mean.

For the combo-chart method, make a second copy of the values in another column. For example, use C1 for Revenue line and copy the values in B2:B7 into C2:C7. The two series should have the same category labels and values. Give them distinct headings so you can identify them in the chart setup and legend. The duplicate is not a second measurement; it exists so that Excel can draw the same data once as a filled area and once as a line.

Before charting, check that the values are numeric, the category labels are in a single consistent column, and there are no accidental blank rows in the middle of the range. If you use a date axis, enter real Excel dates rather than text that merely looks like dates. Clear headings and sensible units help Excel recognize the series and help readers interpret the finished chart.

Create the combo chart in Excel for Windows

  1. Select the category column and both data columns, including their headings. In the example, select A1:C7.
  2. Choose Insert > Insert Combo Chart > Create Custom Combo Chart. The exact button may appear as a combo-chart icon in the Charts group.
  3. In the custom combo chart dialog, set the original Revenue series to Area and the duplicate Revenue line series to Line.
  4. Leave both series on the primary axis for this use. A secondary axis is normally unnecessary when the two series contain identical values.
  5. Choose OK. If Excel places the fill in front of the line, change the series order as described in the troubleshooting section.

Excel builds the chart from the two copies. The Area series supplies the shaded region and the Line series draws the sharper outline on top of it. The chart is technically a combo chart, even though it looks like a line chart with a fill.

On Excel for Mac, select the chart and look under Chart Design > Change Chart Type for the Combo options; the available labels and dialog layout can vary by release. Excel for the web may offer fewer chart-type and formatting controls than the desktop app. If you cannot find the custom combo settings in the web version, open the workbook in desktop Excel to create or adjust the chart.

Format the fill, line, axes, and legend

Click the filled area to select the Area series, then use the Format Data Series pane to adjust its fill. A light, moderately transparent color often keeps the gridlines and other chart elements visible. Click the line separately to change its color, width, or dash style. Keep the line sufficiently distinct from the fill so that the data path remains easy to follow.

Useful finishing touches include:

  • Add a descriptive chart title, such as Monthly Revenue, and identify units in the vertical-axis title or a nearby note.
  • Use a restrained fill color and a stronger line color, rather than several competing colors for the same series.
  • Reduce unnecessary gridlines, but retain enough reference marks to help readers estimate values.
  • Remove or rename a duplicate-series legend entry if it makes the chart confusing. The two series represent one measure, not two separate measures.
  • Check the vertical-axis minimum and maximum. A zero baseline is often important for an area chart because the filled region visually implies magnitude from that baseline.

To edit the chart title, select it and type the replacement. To change series names or order, use Chart Design > Select Data. In the Select Data Source dialog, the Legend Entries (Series) list lets you select a series and use the move controls to change its order. Labels and dialog details can differ slightly across Excel updates.

When the shaded area should start somewhere other than zero

By default, an Area chart fills from the data values toward the horizontal axis. With a vertical axis that begins at zero, the fill therefore communicates the distance from zero. If you set the axis minimum to a nonzero value, the visual baseline changes, which can make the apparent area seem larger or smaller. Use a nonzero minimum only when it supports the intended comparison and is clearly understood.

If you want to shade between a measured series and a target line, do not assume that a standard area series will fill the gap between them. It may instead fill toward the axis and cover other plotted information. One approach is to build helper data representing the lower boundary and the difference to the upper boundary, then use a stacked-area construction for the band and overlay the desired line series. This requires careful axis and series-order settings; use it only when the chart truly needs a band between boundaries.

For a simple target comparison, a clearer alternative may be to show the actual values as a line and the target as a second line, perhaps using a contrasting dashed style. That avoids implying that the entire area from zero to the actual value is the target gap. For ranges such as forecast intervals, a properly constructed band should be labeled so readers know what its upper and lower edges mean.

Choose between an Area chart and a combo chart

Use an Area chart alone when the filled shape is the main point and a standard area outline is sufficient. It is quick to create: select the category and value columns, then choose Insert > Insert Line or Area Chart > Area. Choose a combo chart when you want independent control of the fill and line appearance, or when you need to combine the area with another compatible series.

A regular Line chart is usually preferable when comparing several series. Filled areas can overlap and hide one another, and stacked area charts emphasize totals and contributions rather than making every individual value equally easy to compare. For multiple measurements, lines with distinct colors or markers may communicate the data more faithfully than a large shaded region.

Consider the reader’s task. If they need to compare exact values, add data labels sparingly or include a companion table. If they need to see a trend at a glance, a clean line over a light fill can work well. If the chart contains several categories, long date ranges, or multiple overlapping series, test whether the fill improves comprehension rather than merely decorating the plot.

Common problems and how to fix them

  • The line disappears behind the fill: Open Chart Design > Select Data and adjust the series order so the Area series is behind the Line series. The drawing order can affect which series appears on top.
  • The area fills to the wrong place: Check the vertical-axis bounds and confirm that an area-to-zero chart is actually what you intend. A fill to the axis is not the same as a band between two data series.
  • The legend appears to show duplicate data: The duplicate columns are chart construction helpers. Rename the series clearly, remove a redundant legend entry, or explain the single measure in the chart title and note.
  • The chart has unexpected gaps: Look for blank cells, text values in the numeric data, or missing category labels. Excel’s handling of empty cells can be adjusted through Chart Design > Select Data > Hidden and Empty Cells.
  • The chart looks crowded: Use one fill color, soften its visual weight, reduce extra gridlines, and avoid adding many more filled series. A line chart may be better for comparing several measures.

Frequently Asked Questions

Can Excel shade under a line without duplicating the data?
Yes. Insert an Area chart if its default filled-area appearance meets your needs. Duplicating the series is useful when you want an Area series for the fill and a separate Line series for more precise line formatting.

How do I make the shaded area transparent?
Select the Area series, open Format Data Series, and adjust the fill transparency if the control is available in your Excel version. Use enough contrast for the line and gridlines to remain visible, and avoid making the fill so faint that it serves no purpose.

Can I shade between two lines in Excel?
Yes, but a basic line-plus-area combo does not automatically fill the gap between two arbitrary series. A stacked-area band built from helper series is one option; two clearly styled lines may be simpler and less misleading for a target comparison.

Why does my area chart start at zero?
An Area chart fills toward the horizontal axis, which commonly represents zero on the value scale. Check the vertical-axis minimum if the fill appears to start elsewhere, and remember that changing the axis baseline changes the visual impression of the filled area.

Can I create this chart in Excel for the web?
Chart features and formatting choices in Excel for the web can differ from desktop Excel. If the web interface does not provide the custom Area-and-Line combo settings you need, use Excel for Microsoft 365 on Windows or Mac to create and format the chart.

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.