Excel Area Chart: When to Use One and How to Build It

An area chart in Excel is a line chart with the space under each line filled with colour. It is the right choice when you want readers to feel the size of a total over time, or to see how several parts build up that total month by month. This guide shows when an area chart beats a line or column chart, how to build one in a few clicks, and how to fix the problems that make area charts hard to read.

What is an area chart in Excel?#

An area chart plots values over time, joins them with a line and shades everything below the line. The shading draws the eye to volume, so the reader notices how much, not just which direction.

Excel offers three 2-D versions, plus 3-D copies of each:

Skip the 3-D versions. The depth adds nothing, and it makes the values harder to read against the axis.

When to use an area chart (and when not to)#

Use an area chart when time runs along the bottom and the size of the total matters to your story. Monthly sales by channel, website visits by source and hours worked by team are all good fits.

Pick a different chart in these cases:

• You need exact values or crossing lines. A line chart in Excel is easier to read when series cross often, because nothing is hidden behind a fill.
• The categories have no order. Regions or product names belong in a bar or column chart. An area joins the points, which suggests a trend that doesn't exist.
• You only have one period. A share of one month's total is a pie chart or a single stacked bar.
• You have more than four or five series. The bands get thin and the colours run together.

The guide to making charts in Excel compares every main chart type side by side.

How to set up the data for an area chart#

An area chart needs the time periods in the first column and one column of numbers for each series. Give every column a header, because Excel uses the headers as the legend names.

Keep the months in order from oldest to newest, with no blank rows and no total row inside the range. A total row would be stacked on top as if it were another month.

Build the table from raw data with SUMIFS#

Real data usually arrives as a list of sales, one row per order. Chart that list directly and you get one point per order, which is useless. Total it by month and channel first with the SUMIFS function:

=SUMIFS($C$2:$C$8,$A$2:$A$8,$F2,$B$2:$B$8,G$1)

Here column F holds the months and row 1 from G onwards holds the channel names. The mixed references ($F2 and G$1) let you fill the formula across and down to complete the grid. On the data in this page's exercise, the cell for Feb and Online returns 4,800 (2,450 + 2,350), the same figure as in the table above. The pivot-style summary lesson practises exactly this grid of totals.

How to make an area chart step by step#

With a clean table in place, inserting the chart takes four steps:

1. Select the whole table, including the headers: A1:D7.
2. Go to Insert and, in the Charts group, click Insert Line or Area Chart (the line chart icon).
3. Under 2-D Area, choose Stacked Area.
4. Click the chart title and type a clear one, such as "Monthly sales by channel, Jan–Jun 2026".

Excel stacks the three channels. Online sits at the bottom, Store above it and Phone on top. The top edge of the chart traces the total for each month: 8,200 in January rising to 10,600 in June. If you want to check one of those totals, the SUM function gives it directly: =SUM(B7:D7) returns 10,600 for June.

If Excel puts the months in the legend and the channels along the bottom, it has read your data the wrong way round. Click the chart and choose Chart Design > Switch Row/Column.

Add labels and tidy the chart#

Click the chart, then the Chart Elements button (the + next to it) and tick Axis Titles. On a Mac, use Chart Design > Add Chart Element instead. Label the vertical axis with the unit, such as "Sales ($)". Data labels rarely help on an area chart: there are too many points, and the labels overlap the bands.

Standard, stacked or 100% stacked: which one to pick#

Pick the type by the question your chart must answer. Here is how the same sales table reads in each:

• Stacked Area answers "How did total sales grow, and which channel drove it?" You can see the total climb while Online widens and Store narrows.
• 100% Stacked Area answers "How did the mix change?" Online's share grows from about 51% of January sales to about 70% of June sales. The total disappears, so you can't tell sales grew at all.
• Area answers "How big is each channel on its own?" It works here only because Online is always largest. If you put Online behind the other series, it would cover them.

When readers need the exact value of a middle band, stacked charts are weak, because each band floats on the ones below. If that matters, show a line chart beside it, or add a combo chart with a secondary axis when one measure is on a different scale.

How to fix common area chart problems#

Most area chart problems come from overlap or from the data layout. Here are the usual fixes:

To reorder series, right-click the chart, choose Select Data, select a series in the list and use the up and down arrows (on a Mac, drag or use the order buttons in the same dialog). The series at the top of the list sits at the bottom of a stacked chart.

Keep the chart up to date#

A chart follows the range it was built on, so a new month typed under the table may be left out. Format the summary as a table first (Windows: Ctrl+T; Mac: ⌘T). When you add a row, the table grows and the chart picks up the new month by itself.

If your summary comes from a PivotTable, insert a PivotChart instead: click inside the PivotTable, go to PivotTable Analyze > PivotChart (Windows) and choose a stacked area. It updates when you refresh the PivotTable.

Practise it#

A good area chart starts with a clean table of totals. Try the SUMIFS exercise on this page, then practise building a pivot-style summary in a live spreadsheet: you type each total and ExcelReady checks it instantly. If you want to warm up first, the SUM function lesson covers the basic totals every chart is built on.