A stacked column chart in Excel displays several data series as colored sections stacked within vertical columns, so you can compare both category totals and the parts that make up each total. To create one in Microsoft Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Column or Bar Chart > 2-D Column > Stacked Column.
What a stacked column chart shows
Each column represents a category, such as a month, product, department, or region. The height of the full column represents the sum of its series values, while each colored segment represents one series. For example, a company could show monthly sales by product line: every month gets one column, and each product line contributes a segment to that month’s total.
This chart is useful when the reader needs to see the total and how its components contribute. It makes it easy to spot a month with a high combined result, and it can reveal whether one component is consistently larger than another. Because the segments share a baseline only at the bottom of the stack, however, it is harder to compare the values of segments that appear higher up. Their heights can be judged, but their starting points vary.
The chart is sometimes called a stacked column chart rather than a stack column chart. In Excel, the relevant chart type is named Stacked Column. It is not the same as a clustered column chart, where series appear beside each other, or a 100% stacked column chart, where every column is normalized to the same height.
Prepare the data in a clear layout
Arrange the source data in a simple rectangular table. Put category names in the first column and give each series its own column with a descriptive heading. For example, a monthly sales table might have Month, Accessories, Furniture, and Software as its headings. Each subsequent row contains one month and its values for those series.
Include the headings in the selection when you insert the chart. Excel uses them for the legend and usually uses the first column for category labels. Keep the table free of blank rows or columns inside the data range, merged cells, and totals that you do not want treated as another category. Make sure numeric values are stored as numbers rather than text; text-formatted numbers may be omitted from the chart or behave unexpectedly.
- Use one row per category and one column per series for a typical layout.
- Use consistent units across the series. Stacking dollars with percentages, for instance, would produce a misleading total.
- Use a sensible number of series. A long legend and many thin segments make the chart difficult to read.
- Check that missing values are genuinely missing or zero as intended. A blank and a zero can communicate different things.
If your data is already arranged with each series in a row and categories in columns, Excel may interpret the chart in the opposite direction. You can correct that after insertion with Chart Design > Switch Row/Column.
Create the chart in Excel
- Select the data range, including the category labels and series headings.
- On the ribbon, select Insert > Insert Column or Bar Chart.
- Under 2-D Column, choose Stacked Column. Avoid 100% Stacked Column unless the goal is to compare proportions rather than totals.
- Review the chart’s categories, legend, and values. If Excel assigned the data in the wrong direction, select the chart and choose Chart Design > Switch Row/Column.
- Select the chart title and replace it with a brief title that states what is measured and, where useful, the time period or unit.
The chart is linked to its source cells, so edits to the underlying values generally update the visualization. If you add rows beyond the selected range, they might not be included automatically when the source is a plain cell range. Formatting the source data as an Excel table before making the chart can help the chart expand as table rows are added, although you should verify the chart’s source after changing the table.
Choose between stacked and 100% stacked
A standard stacked column chart preserves the original values. A column totaling 500 units is taller than one totaling 300 units, and its segments show the individual contributions to those totals. Use this version when absolute amounts and overall size matter, such as comparing monthly units sold or expenses by department.
A 100% stacked column chart scales every category to the same height. Its segments show each series as a share of that category’s total, so it is useful for comparing composition when categories have different totals. The original totals are no longer apparent from the column heights. If one region sells 1,000 units and another sells 100, both columns still reach 100%; the chart emphasizes their mix, not their scale.
Choose a clustered column chart when direct comparisons between individual series are more important than showing a combined total. In a clustered chart, the bars for different series sit side by side within each category and share a common baseline. This makes comparing a particular series across categories easier, but it takes more horizontal space and does not present a single stacked total in the same way.
Read the segments and totals carefully
The bottom segment in each column begins at the chart’s baseline, so it is usually easiest to compare across categories. The next series starts at the top of the first segment, and later series start at successively higher levels. As a result, a segment’s visual position can shift even when its value stays constant. Do not infer that a top segment grew simply because its upper edge is higher; check its segment height or its data label.
Series order affects the visual story. Excel generally stacks series in the order shown in the source data, with the first series at the base. Put the component that readers need to compare most often near the bottom, and keep the same order across related charts. Reordering series changes where they appear in the stack, not their underlying values or the total.
For a concrete example, suppose one month has 40 units of A, 30 of B, and 20 of C, while the next has 50, 25, and 15. The totals are 90 and 90. A stacked chart makes the equal totals clear and shows the changing mix, but comparing B between the months is less immediate because B is not at the baseline. A small data table, labels, or a clustered chart may help if exact series comparisons are central.
Format the chart for readability
Select the chart to access the Chart Design and Format tabs. Chart Design provides chart options and elements; the exact contextual controls may vary slightly with window size and Excel updates. Use Chart Design > Add Chart Element to add or adjust elements such as chart titles, axis titles, data labels, and the legend. Keep only elements that help the reader understand the data.
- Use distinct, consistent colors. Give each series a color that remains the same across related charts. Avoid similar shades that are difficult to distinguish, and consider how the chart will appear in grayscale or for readers with color-vision differences.
- Label units and categories. A vertical axis title such as Revenue ($ thousands) is more informative than an unexplained number scale. Category labels should be legible without being crowded.
- Add labels selectively. Data labels can show values inside segments, but labeling every small segment can make the chart cluttered. Use labels when exact values matter, and consider showing fewer series or a nearby table when labels overlap.
- Keep the legend understandable. Use clear series headings in the source table. Move the legend if it competes with the plot area, or position it near the chart where readers can connect colors to names quickly.
Do not remove the value axis or distort its scale merely to make differences look larger. Standard stacked columns normally begin at zero, which preserves a meaningful visual comparison of column heights. If you change axis bounds, explain why and consider whether the result could mislead.
Common problems and how to fix them
The chart has the wrong categories or series: Select it and use Chart Design > Switch Row/Column. If the problem persists, check the selected data range and ensure headings are in the first row or column in the expected arrangement.
Some values are missing: Confirm they are numeric, included in the chart’s source range, and not hidden by an unexpected filter. Check for cells containing text such as a dash in place of a number. If a value is unknown, do not automatically replace it with zero; zero means the measured amount is actually none.
The chart looks cluttered: Reduce the number of categories or series, shorten long labels, enlarge the chart, or use a different chart type. Many categories create narrow columns, while many series create a complicated legend and small segments. A stacked chart is not improved by adding every available field.
The total seems wrong: Verify the source values and check whether you included a totals row or column as an additional series. Including a row of pre-calculated totals alongside the components can cause Excel to stack the total on top of those same components, effectively counting the data twice.
New data does not appear: Select the chart and inspect Chart Design > Select Data to review the chart data range. If the new cells sit outside a fixed range, update the range or use a source Excel table that can grow with added records.
When another chart may be better
Stacked columns are most effective when there are a manageable number of categories and a small set of meaningful components. They are less suitable when readers need precise comparisons across every series, when totals vary greatly and obscure small components, or when there are so many segments that colors and labels become hard to follow.
Use a clustered column chart for side-by-side comparisons, a line chart when the main question is how a continuous measure changes over time, or a 100% stacked chart when comparing shares of a whole. A table can be better when exact values matter more than visual patterns. For a long time series with numerous categories, a line chart may communicate the trend more clearly than tightly packed columns.
Frequently Asked Questions
How do I make a stacked column chart in Excel?
Select your data, then choose Insert > Insert Column or Bar Chart > 2-D Column > Stacked Column. Check that the category labels and series headings appear in the right places, and use Chart Design > Switch Row/Column if Excel interpreted the layout incorrectly.
What is the difference between stacked and 100% stacked columns?
A standard stacked column shows the actual values and their combined total. A 100% stacked column makes each category the same height and shows each series as a percentage of that category’s total, so it is for comparing composition rather than absolute amounts.
Can I show the total above each stacked column?
Excel’s ordinary data labels identify individual series values; they do not necessarily add a separate total label automatically. You can calculate totals in the source data and add them carefully as a separate chart series or place them in nearby cells. If you add a totals series, make sure it is displayed as labels rather than stacked as another component, or the chart will double-count the values visually.
How do I change which series is at the bottom?
Change the series order in the chart’s data source or use Chart Design > Select Data to edit the series list and move a series up or down. The order determines the stacking order, so check the legend and the resulting columns after making the change.
Can a stacked column chart display negative values?
Yes. Excel can plot negative values below the horizontal axis and positive values above it. The chart can become harder to interpret when positive and negative components are mixed, so explain the baseline and check that the categories and series remain clear.
Related
- Project Timeline Excel Template: Build One Step by Step Guide
- Project Contact List Excel Template: Build and Use It
- Project Plan Timeline Template Excel: Build One That Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Create a Line Chart in Excel: A Step-by-Step GuideTo create a line chart in Excel for Microsoft 365 on Windows, arrange your data in columns or…
- How to Reverse Order in Excel Graphs: Axis and SeriesTo reverse the order of categories in an Excel graph, select the chart axis, open Format Axis, and…
- Pivot Chart Grand Totals: Why Excel Leaves Them OutNo. In Microsoft Excel for Microsoft 365, a PivotChart does not plot a PivotTable’s grand total, even when…
- Excel Pivot Table Not Updating? Fix It Step by StepIf an Excel PivotTable is not updating, click inside it and select PivotTable Analyze > Refresh; to refresh…
- Google Sheets Data Chart: Create, Customize, and Fix ItTo make a data chart in Google Sheets, select the cells you want to visualize, then choose Insert…
- Excel Pivot Table: Add a Field to Filters and RowsTo add a PivotTable field to both a filter and a row, open the PivotTable Fields pane and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.