To make a stack chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and the values for each series in neighboring columns, select the data, then choose Insert > Insert Column or Bar Chart > 2-D Column > Stacked Column. Excel stacks each series into one column per category, making it possible to compare both category totals and the parts that make up those totals.
What an Excel stack chart means
“Stack chart” is an informal name for a stacked chart in Excel. It is not one single chart type: Excel offers stacked column, stacked bar, stacked area, and 100% stacked variations. In an ordinary stacked chart, each segment represents one series, and the full column, bar, or area represents the sum of the series for that category.
For example, a shop might record monthly sales of three product groups. A stacked column chart shows a column for each month, with one colored segment for each group. The height of the whole column indicates total monthly sales, while the segments show how much each group contributed. The chart is most useful when the reader needs to see composition and totals together.
A stacked chart is different from a clustered chart. Clustered columns place series side by side within each category, which makes it easier to compare one series across categories. Stacked columns combine the series into a single column, emphasizing the overall total and contribution to it. The choice changes what comparisons are easy to make.
Choose the right stacked chart
Pick the chart form that matches the question and the shape of the data:
- Stacked column: Use vertical columns to compare totals across a modest number of categories, such as monthly revenue by product line.
- Stacked bar: Use horizontal bars when category names are long or when many categories need to fit on the page. The chart still stacks series, but the category labels are easier to read.
- 100% stacked column or bar: Use this when the main question is how each category is divided proportionally. Every column or bar has the same overall length or height, representing 100%, so the original totals are no longer directly visible.
- Stacked area: Use this to show how components and their combined total change over a continuous sequence, such as weeks or years. It can be difficult to compare the exact movement of series that do not start at the baseline.
Use a 100% chart only when relative shares matter more than absolute amounts. If one month totals 100 units and another totals 1,000, both 100% columns will have the same height. Keep the actual totals available in labels, a table, or a nearby note if readers need that context.
Prepare the data before inserting a chart
A clear data table helps Excel interpret the categories and series correctly. Put one category per row, with the category names in the first column. Put a descriptive series name at the top of each value column, and place the numbers below those headings. Avoid blank rows or columns inside the range you intend to chart.
For example, a table could have Month in A1, Online in B1, Store in C1, and Wholesale in D1. The rows below would contain months and the corresponding sales values. Selecting that complete rectangular range, including the headings, gives Excel labels for the chart and a separate series for each sales channel.
- Use consistent units across all series, such as dollars throughout or units throughout.
- Make sure numeric values are stored as numbers, not text that only looks numeric.
- Use a clear category order. Dates may be sorted chronologically, while other categories can follow a meaningful ranking.
- Keep the number of series manageable. Too many thin segments make a stacked chart hard to read.
If Excel puts the categories and series in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. This is useful when the data is arranged with series in rows rather than columns. Check the legend and category axis afterward to confirm that Excel interpreted the table as intended.
Create a stacked chart in Excel
- Select the data range, including the category labels and series headings.
- Choose Insert > Insert Column or Bar Chart.
- Under 2-D Column, choose Stacked Column. For horizontal bars, choose 2-D Bar > Stacked Bar. The 100% stacked choices are in the same chart-type menu.
- Review the result. Confirm that each category has one combined column or bar and that the legend identifies the segments.
- Click the chart title to replace it with a concise description that says what is measured and, when useful, the time period.
To change the chart later, select it and choose Chart Design > Change Chart Type. You can switch between stacked column, stacked bar, and 100% stacked forms without rebuilding the source table. Excel for Mac has the same general chart choices, although ribbon placement and wording can vary slightly by release. Excel for the web also supports creating common charts, but some formatting options may differ from the desktop application.
How to read the segments and totals
In an ordinary stacked column chart, the first series begins at the baseline, and each later series sits on top of the preceding one. The total height is the sum of the series for that category. The bottom segment is usually easiest to compare across categories because it shares a common baseline. For upper segments, the starting position changes from one column to another, making precise comparisons harder.
Consider monthly orders split into standard and express deliveries. If the columns grow from 800 orders to 1,100, the overall increase is immediately visible. The chart also shows how much of each month came from each delivery type. However, comparing the express segment between two months can be less precise than comparing express columns in a clustered chart, because the express segment does not start at zero.
A 100% stacked chart changes the question. Its segments show each series as a share of the category total. A segment that occupies one quarter of a column represents 25%, regardless of whether the category total is 80 or 800. This makes changing proportions easier to see, but it hides differences in total size unless that information is shown separately.
Format the chart for clear comparisons
Formatting should make the structure legible, not decorate it. Use distinct, consistent colors for the series, and keep the same series in the same color across related charts. If the chart has many categories, reduce unnecessary gridlines and avoid placing labels on every small segment when they overlap.
To add labels or axis titles, select the chart and use Chart Design > Add Chart Element. Choose the element you need, such as Data Labels or Axis Titles, and then select a placement. Data labels are useful for a small chart with a few large segments. For a dense chart, a legend and a well-formatted value axis are often clearer. In a 100% stacked chart, check that the value axis communicates percentages rather than implying raw totals.
Keep the series order purposeful. In a stacked column chart, changing the order changes which series sits at the baseline and which ones sit above it. A series that readers need to compare accurately may be a good candidate for the baseline. In a stacked area chart, order also affects how the layers appear, so choose an order that makes the chart understandable and maintain it consistently.
Give the chart a descriptive title and label units where they are not obvious. If the values are in thousands of dollars, say so in the axis title or chart title rather than expecting readers to infer it. A legend should use meaningful names such as Online or Wholesale, not generic labels like Series 1.
Common problems and how to fix them
- The chart shows one series or the wrong categories: Confirm that the selected range includes all the intended columns and headings. Use Chart Design > Select Data to review the chart data range and series, or try Chart Design > Switch Row/Column.
- Labels or values are missing: Check for blank cells, text-formatted numbers, and unintended gaps in the selected range. Also confirm that the data range includes the rows containing the missing categories.
- The segments are too difficult to compare: Reduce the number of series, sort categories logically, or choose a clustered chart if direct comparison of individual series is the priority.
- The total is not obvious in a 100% chart: Remember that every category is scaled to 100%. Add the raw totals in a neighboring table or use a different chart when total size is essential.
- Negative values produce unexpected stacks: Excel plots positive and negative values on opposite sides of the baseline. The result is not a simple sum of positive segment heights, so consider whether a stacked chart communicates the data fairly.
- There are too many colors or tiny segments: Combine minor categories where appropriate, show fewer categories, or use a table alongside the chart. A chart cannot make a complicated breakdown clear just by adding labels.
Before presenting the chart, check that each category’s segments add up to the intended total and that the values are comparable. In particular, avoid stacking measurements that do not share a meaningful unit or that overlap conceptually. A visually tidy chart can still mislead if the data should not be added together.
Stacked charts compared with alternatives
A clustered column or bar chart is often better when the reader needs to compare each series across categories. Each series begins at a common baseline, which supports more accurate visual comparison, but the total for each category is less prominent. A line chart may be preferable for a time trend, especially when there are several series and the goal is to compare their direction rather than their contribution to a total.
A pie or doughnut chart can show composition for one category, but it is not a practical substitute for a long sequence of stacked categories. Comparing slices across multiple pies is difficult, while a stacked chart places the categories in one shared display. A table may be better than any chart when exact values are the main point or when there are many small components.
Choose the chart based on the reader’s task: use stacked charts for contribution and totals, 100% stacked charts for shares, clustered charts for side-by-side comparisons, and lines for trends. If readers need both precise values and a visual summary, include a compact table or data labels rather than forcing one chart to answer every question.
Frequently Asked Questions
How do I make a stacked bar chart in Excel?
Select the category labels, series headings, and values. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Use the stacked bar option rather than stacked column when horizontal bars suit the labels or layout better.
What is the difference between stacked and 100% stacked?
A stacked chart uses the values themselves, so the combined length or height represents the category total. A 100% stacked chart scales every category to the same total and shows the proportions of its parts, not the differences in raw totals.
Can I add totals to a stacked chart?
Excel’s stacked segments show the component values, and the full column or bar represents their sum. If readers need to see exact totals, add a clear total label or show the totals in a nearby table; avoid assuming that every chart layout will display segment sums automatically.
Why does my Excel chart stack the data incorrectly?
Excel may have interpreted rows as series and columns as categories, or the reverse. Select the chart and choose Chart Design > Switch Row/Column. If that does not resolve it, use Chart Design > Select Data to inspect the range, series names, and category labels.
When should I avoid a stacked chart?
Avoid it when the main task is comparing individual series precisely, when the categories contain many small components, or when the values cannot reasonably be added. A clustered chart, line chart, or data table may communicate those cases more clearly.
Related
- Excel Reverse Undo Shortcut: What Works and What Doesn’t
- Excel Reverse Worksheet Order: How to Do It
- Excel Repair Software Free Full Version: What Works?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Chart Not Showing All Data? How to Fix ItIf a Google Sheets chart is missing data, first check its source range in the Chart editor, then…
- Excel Histogram: How to Set the Number of Bins ExactlyIn Excel for Microsoft 365 on Windows, select the histogram’s horizontal axis, open Format Axis, and under Axis…
- Excel Pivot Table: How to Delete a Calculated FieldTo delete a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields,…
- Bar Chart in Cell Excel: How to Make OneExcel does not put a standard bar chart inside a worksheet cell, but you can create an in-cell…
- Excel Pivot Table Sort Count ColumnYes, you can sort a pivot table by the Count column. Right-click any number in the Count column,…
- Standard Error in Excel Pivot Tables: How to Calculate ItExcel PivotTables do not have a built-in Standard Error summary. To calculate the standard error of a mean,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.