To make a stacked column chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each data series in its own column, select the full table, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Each column represents a category, and its colored sections show how the series add up to that category’s total.
What a stacked column chart shows
A stacked column chart combines two comparisons in one view: the height of each column represents a total, while the segments within it show the parts that make up that total. For example, a shop could compare monthly sales across three product lines. Each month gets one column; the column’s overall height shows total sales, and the colored sections show how much each product line contributed.
This chart type is most useful when the categories have meaningful totals and you want to compare both those totals and their composition. It is less suitable when readers need to compare small changes in individual series across many categories. Only the bottom segment shares a common baseline, so the heights of segments higher in the stack are harder to compare accurately from one column to another.
Excel’s “stacked column” and “stacked bar” charts are related but oriented differently. Columns extend vertically, while bars extend horizontally. People sometimes use “bar chart” informally for both, but in Excel’s chart menu the distinction matters when choosing the chart type.
Prepare the worksheet data
Set up the table so each row is a category and each additional column is a series. Put the category labels in the first column and series names in the top row. For example:
- Column A: Month, with January, February, and March below the heading.
- Columns B through D: product lines, with one numeric sales value per product and month.
- The top-left cell: a heading such as Month, so Excel can identify the category field.
Use the same unit throughout a series, such as dollars in every sales cell, and avoid mixing subtotals into the source data. A total column is usually unnecessary for a standard stacked chart: Excel calculates the visible total by stacking the series. Including a total as another series would add it on top of the components and make the columns misleading.
Keep the layout contiguous when possible, with no blank rows or columns breaking up the table. Check that category labels are unique enough to distinguish the rows and that the data cells contain numbers rather than text that only looks numeric. If some values are missing, decide whether they genuinely mean zero or are unknown; treating an unknown as zero can distort both the total and the visual story.
Create the chart in Excel
- Select the complete data range, including the headings and category labels.
- Go to Insert > Insert Column or Bar Chart.
- Under 2-D Column, select Stacked Column. Avoid 100% Stacked Column unless you want every column normalized to the same height.
- Review the chart to make sure the category labels run along the horizontal axis and the intended series appear in the legend.
Excel creates a chart linked to the selected cells. Changing a source value updates the chart; adding data outside the chart’s source range may not. To inspect or adjust that range, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, you can edit the chart data range, add or remove a series, and change the category-axis labels.
If the chart groups the data in the wrong direction—for instance, months appear as series instead of categories—select it and choose Chart Design > Switch Row/Column. This changes how Excel interprets the same cells; it does not rearrange or alter the worksheet data. Check the legend and axis labels after switching, since the right orientation depends on what you want each column to represent.
On Excel for Mac, the chart is also created from the Insert tab, but the ribbon layout and chart gallery may look different. In Excel for the web, select the data and use Insert to add a chart, then use the chart options to change its type. Names and placement can vary slightly by platform or update; the chart-type choice you want is Stacked Column, not Stacked Bar.
Choose stacked or 100% stacked
A standard Stacked Column chart uses the original values. Its columns can have different heights, so a reader can compare both totals and the absolute size of each component. Choose it when totals are important—for example, comparing the number of service requests received each week and how many came from each department.
A 100% Stacked Column chart scales every category to 100%. Its columns have equal heights, and each segment represents that series’ share of the category total. This is useful for comparing proportions, such as the percentage of requests from each department. It removes the visual comparison of total volume, however: a week with 20 requests and one with 200 can look equally tall.
In Excel, select the chart, then choose Chart Design > Change Chart Type and select the appropriate stacked option. Use the standard version when absolute amounts matter, and the 100% version when relative shares matter. If both the total and the percentage are essential, consider labeling the totals or placing a separate total chart nearby rather than asking readers to infer both from equal-height columns.
Make the chart easier to read
A chart should make the comparison clear without forcing readers to decode it. Select the chart and use Chart Design > Add Chart Element to add a title, axis titles, data labels, or gridlines where they help. A specific title such as “Monthly sales by product line” tells readers what the categories and segments mean more quickly than a generic “Sales” heading.
- Choose distinct, consistent colors for the series, and keep the same color-to-series mapping across related charts.
- Use a legend when readers need to identify segments. If there are only a few series, data labels can help, but labels on every segment may crowd the chart.
- Give the value axis an appropriate number format, such as currency for sales, and include units in an axis title or chart title when they are not obvious.
- Order series deliberately. In a stacked column chart, the first series is generally at the bottom of the stack, so put the most important or most consistently compared series there.
For formatting, right-click a chart element and choose its formatting option, or use the Format pane when it appears. Avoid relying on color alone to communicate a critical distinction: clear legend labels and, where practical, direct data labels make the chart more accessible. If a series is small, consider whether the chart type or a companion table would communicate its values better than a tiny colored strip.
Read the chart carefully
The total is represented by the top of the full stack, not by any one segment. To compare totals, compare the overall column heights. To compare a component, compare its segment across categories—but remember that only the bottom series starts from a shared baseline. Segments in the middle or at the top begin at different heights, which makes small differences difficult to judge by eye.
Suppose a chart shows January with 40 units of A, 30 of B, and 20 of C, and February with 50 of A, 25 of B, and 25 of C. January totals 90 units; February totals 100. The standard stacked chart shows the larger February total and the component values as portions of each column. The 100% version instead shows A as about 44% of January and 50% of February, making the changing mix clearer while concealing that the total rose by 10 units.
A common misconception is that the tallest segment alone indicates the largest category total. It does not: the total is the sum of all stacked series. Another is that a 100% stacked chart displays the original quantities; it displays each series as a fraction of its category total. Include data labels or a nearby table if the exact numbers matter, and do not infer a trend from visual heights without checking the axis and chart type.
Common problems and fixes
- Categories and series are reversed: Select the chart and choose Chart Design > Switch Row/Column. Confirm that the horizontal axis now lists the intended categories.
- A total looks too large: Check whether the source table includes a total column as well as the component columns. Remove the total series from the chart rather than stacking it on top of its parts.
- One column is unexpectedly tiny or huge: Check for a missing value, an accidental extra zero, or data in a different unit. Also confirm that the chart is not 100% stacked if you expect absolute heights.
- Series are missing: Select the chart and open Chart Design > Select Data. Check the data range and whether the missing series is listed.
- Labels are difficult to read: Reduce the number of displayed labels, enlarge the chart, or use a data table alongside it. Too many labels can obscure the segments they describe.
If the chart does not update after adding rows, check its source range in Select Data. You can make a source range easier to expand by formatting it as an Excel table: select the data and choose Insert > Table, confirming that the table has headers. A chart built from a table can include data added to that table, though it is still sensible to inspect the chart after changing the data layout.
When another chart is a better choice
Use a clustered column chart when the main task is to compare individual series side by side across categories. The common baseline makes it easier to compare values than a stack, although the chart can become crowded with many series. Use a stacked bar chart when category names are long or when horizontal labels are easier to read; it preserves the stacked comparison but changes the orientation.
For many categories or many series, a stacked chart can become visually dense. A line chart may be more useful for showing changes over time, while a table can be clearer when exact values matter more than patterns. A standard pie chart is generally not a substitute for comparing several category totals and their components. Choose according to the question: total size, composition, trend, or precise value.
Frequently Asked Questions
How do I make a stacked column chart in Excel?
Select a table with category labels in the first column and series headings across the top. Choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Check the legend and categories, and use Chart Design > Switch Row/Column if Excel groups them incorrectly.
What is the difference between stacked column and 100% stacked column?
A stacked column chart preserves the original values, so column heights show totals. A 100% stacked column chart makes every column the same height and shows each series’ share of its category total. Use the latter to compare proportions, not total volume.
Can I show the total above each stacked column?
Excel stacks the individual series but does not automatically add a separate total series as a safe shortcut; stacking a total series would double-count it visually. You can add total labels using a carefully prepared helper series or place totals in a separate table. If you use a helper series, ensure it does not add visible height to the stack and check the result after edits.
Why are my stacked columns displayed the wrong way around?
Excel may have treated rows as series and columns as categories, or vice versa. Select the chart and choose Chart Design > Switch Row/Column, then verify that the axis lists the categories you intend and the legend lists the component series.
Can a stacked column chart contain negative values?
Excel can plot negative values, but positive and negative segments extend in different directions around the zero line. This can make totals and composition harder to interpret than in an all-positive chart. If negative values are important, explain the zero baseline clearly and consider whether a separate chart would make gains and losses easier to compare.
Related
- Quick Key to Zoom In Excel: Shortcuts and Zoom Options
- Quick Schedule Maker in Excel: Build One Fast
- Excel Strikethrough Shortcut: Quick Key and How to Use It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Not Displaying Data Correctly? How to FixIf an Excel chart is skipping, mislabeling, or mis-scaling data, select the chart and check Chart Design >…
- Excel Waterfall Chart Connector Lines: How to FormatIn Excel for Microsoft 365 on Windows, select the waterfall chart’s data series, open Format Data Series, expand…
- How to Add a Combo Chart in Excel: A Clear WalkthroughTo add a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert >…
- Excel Chart Not Showing X-Axis Values? How to Fix ItIf an Excel chart is not showing x-axis values, select the chart and check that its horizontal axis…
- Free Excel Gantt Chart Timeline TemplatesYes. You can get a free Gantt chart timeline template by searching Excel’s template gallery or Microsoft Create,…
- Bubble Chart in Excel: Make Each Bubble a Different SizeYes. To make bubbles different sizes in an Excel bubble chart, give each data point its own size…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.