Stacked Area Chart in Excel: Create and Format One

Charts & pivot tables · Updated November 20, 2026

To make a stacked area chart in Excel, arrange your time periods in the first column and each data series in its own column, select the full table, then choose Insert > Insert Line or Area Chart > 2-D Area > Stacked Area. The chart shows how the component series add up to a changing total over time, making it easier to compare both the overall trend and each component’s contribution.

What You’ll Need

Before you start, prepare a small, rectangular table with one header row and one row for each period. Use a consistent time interval, such as months or quarters, and include a numeric value for every series and period where you have data. For example, a table might have Month, Product A, Product B, and Product C as its column headings, followed by one row per month.

  • Excel for Microsoft 365 on Windows. The chart tools are also available in recent desktop versions of Excel.
  • A column of dates, months, or other ordered categories, plus two or more columns of numeric series.
  • Meaningful series names in the column headings. Excel uses these names in the chart legend.

A stacked area chart is most useful when the series are parts of a total and you want to show how that total and its composition change. It is less suitable when you need to compare the precise movement of every series independently, because only the bottom series shares the zero baseline.

Step-by-Step

  1. Arrange and check the source data. Put time periods in the first column, with the earliest period first, and put each series in a separate column. Keep the headings in the top row and avoid blank rows or columns inside the table. Check that the values are numbers, not text that only looks numeric. If your periods are actual Excel dates, format them as dates; if they are month names typed as text, put them in chronological order yourself. For example, alphabetic sorting would put April before February, which would make the chart’s timeline misleading.

  2. Select the complete data range. Select the headings and all the period and value cells, but do not include a grand-total row unless you specifically want that total to become another stacked series. If the table is small, drag across it. For a larger range, click its first cell, then hold Shift while selecting the last cell. Check that the date or category column is included; leaving it out can make Excel use generic labels such as 1, 2, and 3 along the horizontal axis.

  3. Insert the stacked area chart. On the ribbon, choose Insert > Insert Line or Area Chart, then under 2-D Area choose Stacked Area. Do not choose Area, which overlays the series rather than adding them cumulatively, or 100% Stacked Area, which converts each period to a percentage of its total. Excel inserts a chart on the worksheet. If the menu is compressed in your window, look for the line-and-area chart icon on the Insert tab and open its chart-type menu.

  4. Check which direction Excel plotted the data. The horizontal axis should show the periods, and the legend should list the series names. If the chart instead shows your series along the horizontal axis, select the chart and choose Chart Design > Switch Row/Column. Open Chart Design > Select Data to inspect the chart’s data range and series names. In the Select Data Source dialog, confirm that each series points to its own column of values and that the horizontal axis labels point to the period column. Choose Edit if a name or label range needs correcting.

  5. Add a clear title and axis labels. Select the chart, then use Chart Design > Add Chart Element to add a Chart Title and, when useful, Primary Horizontal and Primary Vertical Axis Titles. You can also click the chart title placeholder and type a concise title directly. Label the vertical axis with the measure and units, such as Monthly sales ($), and the horizontal axis with the time period. Keep the legend visible unless the series are labeled clearly in another way; readers need to know which color represents each component.

  6. Make the series easy to distinguish. With the chart selected, choose Chart Design > Change Colors to try another coordinated palette. To change one series more precisely, click its colored area, right-click, and select Format Data Series. In the Format Data Series pane, use Fill & Line options to adjust its fill color and, if needed, outline. Use colors with clear contrast and avoid very similar shades. Also consider how the colors look when printed in grayscale or viewed by someone with color-vision differences; distinct lightness and patterns of color can help.

  7. Improve the scale and reduce clutter. The vertical axis normally starts at zero, which is usually appropriate because the chart’s stacked heights represent quantities. If the scale is inappropriate, right-click the vertical axis, choose Format Axis, and review the Bounds and Units settings in the pane. Avoid setting a minimum that hides part of the total or exaggerates changes. Remove unnecessary gridlines or extra chart elements by selecting them and pressing Delete. If the data has many periods, widen the chart or simplify the date labels rather than shrinking the text until it is hard to read.

  8. Verify the result and prepare it for future updates. Compare a few chart totals with the corresponding values in your table: at each period, the full stack should represent the sum of the component values. Confirm that the periods appear in order and that the legend matches the correct colors. If you expect to add rows later, consider converting the source range to an Excel table using Insert > Table before creating the chart, or resize the chart’s data range through Chart Design > Select Data. Save the workbook after checking the chart at a readable size.

Common Mistakes

  • Choosing the wrong area chart type. A regular Area chart overlaps series, while a 100% Stacked Area chart shows proportions rather than original values. Choose Stacked Area when the actual accumulated amounts and their total matter.
  • Including an overall total as a series. If the source table has a Total column alongside the component columns, Excel may stack that total on top of its own components. Remove the total column from the chart range; the resulting full stack already represents the total.
  • Using inconsistent units or periods. Mixing dollars with units, or monthly values with quarterly values, makes the stack difficult to interpret. Normalize the data or separate the measures into different charts.
  • Expecting every series to have a common baseline. In a stacked chart, only the bottom series starts at zero. The height of a higher band shows its value, but its vertical position also depends on the series below it. For direct comparison of individual trends, a line chart may be clearer.
  • Ignoring negative or missing values. Negative values complicate the visual meaning of a positive stack, and blanks can create unexpected gaps or apparent changes. Check how your chosen chart handles them and decide whether to explain, clean, or chart those values separately.

Tips

  • Use a stacked area chart when the categories are meaningful parts of a whole and the total is also important. If you only care about each category’s direction, consider a line chart; if you care about changing shares, use 100% Stacked Area.
  • Limit the number of series. A chart with many bands can become hard to read, especially when similar colors touch. Combine minor categories into an Other series only when that grouping makes sense for the data, and explain what it contains.
  • Keep series order consistent with how readers should interpret the stack. In many charts, the largest or most stable component is placed at the bottom, where it is easiest to compare against zero. Change the order in the source columns or adjust the series order in Chart Design > Select Data.
  • Use actual dates when possible. If Excel spaces date labels oddly, right-click the horizontal axis and choose Format Axis to review the axis type and date units. A date axis can space dates according to time; a text axis treats each label as an equally spaced category.
  • For a presentation or report, provide a descriptive chart title, units, a source note if needed, and enough space for the legend. Do not rely on color alone to communicate an important result; label the chart or explain the key point in nearby text.

Troubleshooting

The chart looks like a single shape or the series cover one another. Check that you selected Stacked Area rather than Area. If the chart type is wrong, select the chart and choose Chart Design > Change Chart Type, then select Stacked Area under Area.

The axis shows numbers instead of dates or month names. Open Chart Design > Select Data and check the Horizontal (Category) Axis Labels range. Select Edit and choose the cells containing the periods. If month names are out of sequence, reorder the source rows chronologically. If you used text labels, Excel may treat them as categories rather than dates, which is fine as long as they are ordered correctly.

The legend names are Series 1, Series 2, or the chart is transposed. In Chart Design > Select Data, edit each series and set its name to the appropriate heading cell. Confirm that the values range excludes the heading, then use Chart Design > Switch Row/Column if Excel interpreted rows and columns in the opposite direction.

The colors or labels are hard to read. Use Chart Design > Change Colors, enlarge the chart, or reduce the number of plotted series. If labels overlap, remove unnecessary data labels rather than forcing every point to display a value. A visible legend and clear axis titles are often enough for a chart with many periods.

New rows do not appear in the chart. Select the chart and choose Chart Design > Select Data to check the Chart data range. Extend the range to include the new rows. For data that grows regularly, an Excel table can make the source range easier to maintain; verify that the chart includes new table rows after adding them.

Frequently Asked Questions

What is a stacked area chart used for?
A stacked area chart shows how multiple series contribute to a cumulative total across an ordered sequence, usually time. It is useful for viewing changes in both the total and its composition.

What is the difference between Stacked Area and 100% Stacked Area?
Stacked Area displays the values in their original units, so the overall height changes with the total. 100% Stacked Area scales every period to 100%, emphasizing each series’ share rather than its absolute amount.

Can I make a stacked area chart with dates?
Yes. Put valid Excel dates in the first column and values in adjacent columns. Excel can use those dates for the horizontal axis. If it spaces or labels them unexpectedly, check the axis settings and make sure the date cells are included in the chart data.

Can I add data labels to the chart?
Yes. Select the chart, choose Chart Design > Add Chart Element > Data Labels, and select a position. Labels on every point can quickly make a stacked chart crowded, so use them sparingly or label only the values that readers need to identify.

Why is a stacked area chart sometimes misleading?
Only the bottom series shares a zero baseline, so comparing the exact movement of upper series is difficult. A line chart is usually better for comparing individual trends; a stacked chart is better when the cumulative total and contribution are the focus.

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.