How to Create a Stacked Column Chart in Excel

Charts & pivot tables · Updated November 20, 2026

To create a stacked column chart in Excel, arrange categories in the first column and each data series in its own column, select the complete table, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. The chart will show each category as one column, with its series values stacked to show both the category total and the parts that make it up.

This guide is for Excel for Microsoft 365 on Windows. Before you begin, decide what each column should represent and check that the values you plan to stack are meaningful together. A stacked chart is most useful when you want to compare totals across categories while also seeing how different series contribute to each total.

What You’ll Need

  • An Excel workbook with a rectangular table: one column of category labels and one column for each series you want to compare.
  • A header for every column, such as Month, Product A, and Product B.
  • Numeric values for the series. Use a consistent unit and time period so the stacks can be compared fairly.

Step-by-Step

  1. Arrange the source data. Put category names down the first column and series names across the top row. For example, column A might contain months, while columns B through D contain sales for three product lines. Each row should describe one category, and each series value should belong to that row. Keep the table contiguous, with no completely blank rows or columns breaking it up. You can include a total column in the source, but do not include it in the chart selection unless you specifically want totals stacked as another series; usually, that would inflate the displayed column totals.
  2. Check the values before charting. Confirm that the data cells contain numbers rather than text that only looks like numbers, and that all series use the same unit, such as dollars or units sold. Decide how to handle missing values: a blank is not the same as a measured zero. Correct labels and values in the table first, because the chart reflects the selected source data. If your categories are dates, use actual Excel dates with a consistent interval rather than a mixture of date formats stored as text.
  3. Select the full table, including headers. Click the first header cell, then drag to the last value cell so the selection includes all category labels, series names, and data. For a table from A1 to D13, select A1:D13. Including headers helps Excel name the legend entries and identify the category axis. If Excel has formatted the range as a table, you can select cells in the table and create the chart from that selection. Avoid selecting an extra total row or unrelated notes.
  4. Insert the stacked column chart. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Select the option labeled Stacked Column, not Clustered Column or 100% Stacked Column. Excel inserts a chart based on the selected data. The 2-D option is generally easiest to read; a 3-D chart can distort the apparent size of columns and make comparisons less clear.
  5. Check that Excel interpreted rows and columns correctly. Each category should appear once along the horizontal axis, and each series should have its own color in the stack and its own legend entry. If the legend lists individual categories instead of series, or the axis shows series names, select the chart and choose Chart Design > Switch Row/Column. Check the result again, because this command exchanges which data Excel treats as categories and which it treats as series.
  6. Add a useful chart title and axis titles. Click the chart title and replace the placeholder with a concise description, such as Monthly Sales by Product. To add axis titles, select the chart and choose Chart Design > Add Chart Element > Axis Titles, then select the horizontal or vertical title. Name the vertical axis with its unit, for example Sales (dollars), and use a horizontal title only if it adds clarity. If the chart has no visible title, use the same Add Chart Element menu to add one.
  7. Make the series and labels readable. Use the chart legend to identify the stack colors. If the series order is confusing, change the order in the source columns or use Chart Design > Select Data and adjust the series list. To show values on the columns, choose Chart Design > Add Chart Element > Data Labels and select a position such as Center or Inside End. Labels can help when there are only a few series, but may overlap in a crowded chart. Remove them if they make the columns hard to read.
  8. Refine the appearance and verify the chart. Select a series to change its fill color, or use the Chart Design tab to choose a chart style. Keep colors distinct and use the same color for a series wherever it appears. If columns look too narrow or too wide, right-click a column, choose Format Data Series, and adjust Gap Width in the pane. Finally, compare several columns against the source table, confirm the legend matches the headers, and make sure the vertical axis begins at zero when the goal is to compare totals.

In Excel for Mac, the chart choices are also on the Insert tab, although the ribbon layout and labels can vary slightly by release. Select the data, use the column or bar chart menu, and choose the stacked 2-D column option. In Excel for the web, the available chart formatting controls can be more limited; if a particular control is missing, open the workbook in the desktop app.

Common Mistakes

  • Choosing the wrong chart type. A clustered column chart places series side by side; a stacked column chart puts them in one column per category. A 100% stacked chart converts each category to a 100% whole, so it emphasizes proportions rather than actual totals.
  • Including a total as another series. If you include a row or column that already sums the components, Excel stacks that total on top of the components. The displayed height then exaggerates the real total. Remove that total from the chart range or edit the chart’s data selection.
  • Mixing unrelated units or measures. Stacking dollars with percentages, or units with hours, produces a total with no useful interpretation. Use a separate chart or another comparison method when the measures cannot be added meaningfully.
  • Using too many series or categories. Many colors and labels make it difficult to follow the contributions. Keep the chart focused on a manageable number of series, or consider a different chart type if readers need to compare each series precisely.
  • Assuming every segment is easy to compare. Only the bottom segment shares a common baseline across categories. Upper segments start at different heights, so their sizes are harder to compare precisely. A stacked chart is good for totals and broad composition, but not always for detailed comparisons between series.
  • Letting text or blanks distort the picture. Numbers stored as text may be treated unexpectedly, and blank cells can create gaps or missing segments. Check the source cells and decide whether missing observations should be blank, zero, or clearly marked as unavailable.

Tips

  • Order series deliberately. The order in the legend corresponds to the stack order. Put the most important or most stable series at the bottom when that makes comparisons easier, and keep the same order across related charts.
  • Use 100% stacked columns only for share comparisons. This type makes every category the same height and shows how much each series contributes as a fraction of that category. It hides differences in the category totals, so add a separate total label or chart if those totals matter too.
  • Keep formatting restrained. Choose a small, consistent palette, avoid unnecessary 3-D effects, and use a clear font size. A reader should be able to identify the series without relying on color alone; direct labels or a descriptive legend can help.
  • Make the chart update with the data. If the source is likely to grow, format it as an Excel table with Home > Format as Table before creating the chart. Charts based on a table can include newly added table rows. Review the chart after adding data to confirm the new categories and values appear as expected.
  • Sort categories for a reason. Keep dates in chronological order. For non-time categories, order them by a meaningful sequence or by total if that supports the message. Avoid sorting only one source column, since that can misalign labels and series values.
  • Use a clear scale and context. A zero baseline helps readers compare total column heights accurately. Include the period, unit, and population or location in the title or nearby text when those details are not obvious from the data.

Troubleshooting

The chart shows the wrong categories or series: Select the chart and choose Chart Design > Switch Row/Column. If that does not fix it, open Chart Design > Select Data and check the chart data range, category-axis labels, and series names. Make sure the first row and first column of the selected range are the intended headers and labels.

The chart is blank or some columns are missing: Confirm that the chart’s source range includes the value cells and that the values are numeric. Check for filters that hide rows, hidden rows or columns, and cells containing errors. In the Select Data dialog, use the option for hidden and empty cells to review how hidden data is handled. If values are stored as text, convert them to numbers and refresh the chart selection if necessary.

Column heights look unexpectedly large: Look for a total column or row included as a series, duplicate data, or values in a different unit. A stacked column height represents the sum of its series for that category. Verify one category by adding its component values from the worksheet and comparing the result with the chart’s total height.

Data labels overlap or are hard to read: Remove some labels, reduce the number of series, or resize the chart to provide more room. You can select an individual label and delete it if only selected values need emphasis. Consider using a legend instead of labeling every segment, and avoid placing labels outside narrow segments.

The chart does not include newly entered rows: Check whether the new rows are inside the chart’s source range. Select the chart, choose Chart Design > Select Data, and expand the range if needed. Converting the source range to an Excel table before adding future rows can make the chart easier to maintain.

The ribbon option seems unavailable: Click the chart first so the contextual Chart Design tab appears. In some versions or window sizes, commands may be grouped or shown as icons. If you are working in Excel for the web and cannot find an advanced formatting control, open the workbook in Excel for Microsoft 365 on Windows or Mac.

Frequently Asked Questions

What is the difference between stacked and 100% stacked columns?
A regular stacked column shows the sum of the series as the total height, so categories can have different heights. A 100% stacked column scales every category to 100%, making it useful for comparing proportions but not total amounts.

Can I create a stacked column chart with negative values?
Yes. Excel can plot negative values below the horizontal axis and positive values above it. However, positive and negative components do not form a simple all-positive total, so explain what the signs mean and check that the chart communicates the comparison you intend.

How do I change the order of the stacked segments?
Change the series order in the chart’s source columns, or select the chart and use Chart Design > Select Data to reorder the series. The legend order and stack order are related, so review both after making a change.

Can I show the total above each column?
Excel does not always add a separate total label automatically for a standard stacked chart. You can calculate totals in a separate worksheet column and use a suitable data-label workflow, or add text boxes manually for a small, fixed chart. If you use text boxes, remember to update them when the data changes.

Can I change a clustered column chart to a stacked one?
Yes. Select the chart, choose Chart Design > Change Chart Type, choose Column, and select Stacked Column. Check the preview and verify that the series and categories remain oriented correctly after the change.

When should I use a different chart?
Use a clustered column chart when precise comparisons between individual series matter more than totals. Use a 100% stacked chart for composition shares, and consider a line chart for trends over many time periods. Choose the chart type that best answers the reader’s question.

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.