Excel Area Chart: How to Create and Format One

Charts & pivot tables · Updated November 19, 2026

To create an area chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Line or Area Chart > 2-D Area and select a chart type. An area chart displays values over categories, often time, with the space beneath each series filled in; it is useful for showing how totals or parts of a total change.

What an area chart shows

An area chart combines the changing outline of a line chart with filled regions underneath it. The horizontal axis usually represents dates or other ordered categories, and the vertical axis represents a measured value such as units sold, website visits, or energy use. The filled area gives the values visual weight, so increases, declines, and broad patterns can be easy to spot.

For example, a business might chart monthly sales of three product lines. A standard area chart can show each product’s trajectory, while a stacked area chart can show how the combined sales total changes and how much each product contributes. These are different questions, so choosing the chart type matters as much as choosing the data.

Area charts are most effective when the categories have a meaningful order and the series are nonnegative quantities that can reasonably be added or compared. They are less suitable when precise values for several overlapping series are the main point: the fill can make individual boundaries harder to follow than lines with markers.

Prepare the worksheet data

Arrange the data in a rectangular table with one category column and a separate column for each series. Put clear labels in the first row and category labels, such as months, in the first column. For example, the table might contain Month, Product A, Product B, and Product C as headings, followed by one row for each month. Excel uses the headings as series names and the first-column entries as axis labels.

Keep the values consistent: do not combine units such as dollars and quantities in one chart, and avoid blank rows or columns inside the selected range. A missing value is not the same as zero. In a chart, a zero means the measured value is zero; a blank may create a gap or be treated according to the chart’s hidden-and-empty-cell settings. Check how missing observations should appear before interpreting the graph.

  • Use dates or categories in chronological or logical order.
  • Keep each series in its own column, with one observation per category.
  • Use concise, distinct series names so the legend is understandable.
  • Include totals only when they are genuinely another series you want to plot; adding a total to a stacked chart can double-count the components visually.

Create an area chart in Excel

  1. Select the data, including the column and row headings. If the table is contiguous, click in it and Excel may detect the whole range; otherwise drag to select the exact range.
  2. Open the Insert tab, choose Insert Line or Area Chart, and look under 2-D Area.
  3. Choose Area for overlapping filled series, Stacked Area to add series cumulatively, or 100% Stacked Area to show each series as a share of the category total.
  4. Review the chart. If Excel placed categories and series in the wrong direction, select the chart and choose Chart Design > Switch Row/Column.
  5. Add a descriptive title and check that the legend, axis labels, and units make the chart understandable without relying on surrounding worksheet cells.

To revise an existing chart, select it and use Chart Design > Change Chart Type. Use Chart Design > Select Data to adjust the data range, edit series, or change category labels. Ribbon names and chart options can vary slightly by Excel release and platform, but the same basic area-chart choices are available in current desktop Excel for Mac. Excel for the web has a more limited editing interface than the Windows desktop app.

Choose the right area-chart type

Area, sometimes called a regular or unstacked area chart, plots each series from the horizontal axis and fills the area underneath it. This can work for one series or a small number of series with clearly separated values. With multiple series, filled regions can overlap and hide one another; the series plotted later may cover parts of earlier ones. The chart is therefore not a reliable way to compare every series’ exact value at every category.

Stacked Area places series on top of one another. The upper boundary represents the cumulative total, and each band represents a series’ contribution. This is useful when both the combined amount and changing composition matter, such as the total number of support requests split among request types. The vertical position of a band is cumulative, however, so only the bottom series shares a fixed zero baseline. Comparing the thickness of a band can be harder than comparing separate lines.

100% Stacked Area scales each category to 100 percent. It emphasizes the proportions of the whole rather than the absolute total. If a category has 20 items and another has 2,000, both columns still fill the same vertical height; the chart will not communicate that difference in volume. Use it when the composition is the question and show the underlying totals separately if readers also need them.

Format the chart for readability

Start with a title that states the measure, scope, and period where practical—for instance, “Monthly electricity use by building, 2024.” A legend should identify each series clearly. If there are only a few series, direct labels may be easier to follow, but avoid placing labels over dense areas. Axis titles can clarify units such as dollars, tonnes, or hours; without units, a scale of 0 to 500 can be ambiguous.

Select a series and open Format Data Series to adjust its fill, outline, and other series formatting. Choose colors with enough contrast to distinguish adjacent bands, and consider a color-blind-friendly palette. Transparency can reveal overlapping fills in a standard area chart, but excessive transparency may make the chart look washed out. Remove decorative effects that compete with the data, and use gridlines sparingly to help readers estimate values.

Check the vertical axis before changing its bounds. A zero baseline is important for filled areas because the amount of fill visually represents magnitude. Truncating the axis can exaggerate differences and make the filled regions misleading. If the data spans a wide range, consider whether a different chart type or a clearly explained scale would communicate it more honestly. For dates, verify that the horizontal axis is in chronological order and that Excel has not treated date entries as unrelated text categories.

Read the chart without misreading it

In an ordinary area chart, the filled shape can draw attention to the overall pattern, but the upper edge of a later series is not necessarily its own value if the fills overlap. In a stacked chart, the top boundary is a running total rather than the value of the last series alone. To find a component’s value in a stacked chart, compare the top and bottom boundaries of its band at the category in question.

Suppose a stacked chart shows 40 units for one category in its first band and the next band ends at 65. The second series contributes 25 units, not 65. That distinction is easy to miss when reading the chart quickly. Data labels, a companion table, or a line chart can help when exact component values matter.

Area charts can also make small changes look prominent when the scale is tight, or make a meaningful smaller series nearly disappear when another series is much larger. Ask what comparison a reader should make—total, trend, or share—and select a chart and axis that support that comparison.

Common problems and fixes

  • The chart has one series when several were expected: Check that the selected range includes every data column and its heading. Use Chart Design > Select Data to inspect the plotted range.
  • Months appear as series instead of categories: Select the chart and choose Chart Design > Switch Row/Column. This is common when data is arranged in rows rather than columns.
  • A series seems hidden: In a regular area chart, another filled series may cover it. Try a stacked chart if cumulative totals are meaningful, reorder series in Select Data, or use a line chart to compare individual trends.
  • The stacked total looks unexpectedly large: Check whether a total column was included alongside the components. A total stacked on top of its parts counts the same values again.
  • The chart suggests an incorrect trend: Check category order, missing values, units, and vertical-axis bounds. Also confirm that zeros and blank cells are represented as intended.

Area chart versus line and column charts

A line chart is often better when the goal is to compare several series’ trends, especially when they cross or have similar values. Its lines do not obscure one another with filled regions. A column chart is useful for discrete categories or for comparing values at a small number of dates. Area charts are a stronger fit when the data is sequential and the filled magnitude or cumulative composition is central to the message.

There is no rule that every time series needs an area chart. For example, monthly sales for four regions may be easier to compare as four lines. If the question is how total sales split among those regions over time, a stacked area chart may be more appropriate. If the absolute total is not important and only the changing shares matter, 100% stacked area is a candidate. Choose based on the comparison readers need to make, not just the visual style.

Frequently Asked Questions

How do I make an area chart in Excel?
Select the category labels, series headings, and values. Choose Insert > Insert Line or Area Chart > 2-D Area, then select Area, Stacked Area, or 100% Stacked Area. Review the legend and axis labels after Excel creates the chart.

What is the difference between an area chart and a stacked area chart?
A regular area chart fills each series down to the horizontal axis, so series can overlap. A stacked area chart adds the series cumulatively, making the top boundary represent the total and each band represent a component’s contribution.

How do I change an Excel area chart to a line chart?
Select the chart and choose Chart Design > Change Chart Type. Choose a line option and confirm. A line chart is often clearer when you need to compare multiple series individually.

Why is one series hidden in my area chart?
In a regular area chart, a later series can cover an earlier series because the filled regions overlap. Try changing the series order, switching to a line chart, or using a stacked type if the data represents additive parts of a whole.

When should I use a 100% stacked area chart?
Use it when you want to show how each component’s percentage of a total changes across categories. It shows proportions, not changes in the absolute total, because each category is scaled to 100 percent.

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.