Excel Stacked Bar Chart: How to Create and Read One

Charts & pivot tables · Updated November 19, 2026

To make a stacked bar chart in Excel for Microsoft 365 on Windows, select your category labels and series data, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Excel creates a horizontal bar for each category, with its component values joined end to end.

Create a stacked bar chart in Excel

Start with a simple rectangular data table: put category names in the first column, put each data series in its own column, and use the top row for series names. Select the full table, including its headers, before inserting the chart. For example, a household budget table might list months down column A and Rent, Food, and Transport across columns B, C, and D. Each month then appears as one bar divided into those three spending categories.

  1. Arrange the worksheet data with one category per row and one series per column.
  2. Select the data range, including the category labels and series headings.
  3. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.
  4. Use the chart title and legend to make the categories and series clear. If needed, select the chart and use Chart Design > Add Chart Element to add titles, data labels, or other elements.

Excel may choose a different orientation if it interprets the rows and columns the other way around. Select the chart and choose Chart Design > Switch Row/Column to change which data is treated as categories and which is treated as series. In Excel for Mac, the chart commands are also on the ribbon, though their grouping and appearance can vary by version; the chart’s design tab and formatting controls provide the corresponding options.

Set up the data so the chart makes sense

A stacked chart depends on Excel recognizing the boundaries between categories and series. Include one descriptive heading for every series and a label for every category. Avoid blank rows or columns inside the selected range, since they can interrupt the data Excel picks up. If a heading is missing, Excel may use a generic name such as Series 1 in the legend. You can correct a series name through Chart Design > Select Data, where the chart’s source series and category labels can be adjusted.

Use values that can be meaningfully added together. Stacking is appropriate for components of a total, such as the number of units sold by product type in each region, or the hours spent on different activities each week. It is usually misleading to stack unrelated measures with different units, such as revenue and customer satisfaction scores. Make sure the values are numeric; text that looks like a number may not be plotted as expected.

Do not include a total column or row as another series if it duplicates the sum of the stacked components. Doing so adds the total on top of its parts and makes the bars too long. If you want to show the total, use a separate data label, a companion table, or another deliberate design rather than treating the total as a component.

Choose between stacked, 100% stacked, and clustered bars

Excel offers several related chart types, and the right choice depends on whether the reader needs to compare totals, composition, or individual values.

  • Stacked Bar shows the actual values and their combined length. Choose it when totals matter as well as the parts, such as comparing monthly orders and the product categories that make them up.
  • 100% Stacked Bar scales each category to the same full length. It emphasizes proportions, such as each department’s share of a company’s spending. It does not show which category had the larger total.
  • Clustered Bar places series side by side rather than stacking them. It is often easier to compare a particular series across categories, especially when the values are similar in size.

To change an existing chart, select it and choose Chart Design > Change Chart Type, then pick the desired bar option. A common misconception is that 100% stacked bars show percentages that were already in the worksheet. Excel calculates each segment’s share of its category total for display; the original worksheet values remain unchanged.

Format labels, colors, and the legend

A chart is useful only if readers can identify its parts quickly. Keep the series order consistent with the legend, choose colors with enough contrast, and use a concise title that states what is being compared and, where helpful, the time period or unit. Avoid relying only on color to distinguish categories when the chart may be printed in grayscale or viewed by someone with color-vision differences. Direct data labels or a clear legend can help, but too many labels can clutter the display.

To label values, select the chart and choose Chart Design > Add Chart Element > Data Labels, then choose a placement. The options available depend on the chart type and Excel version. If labels overlap or obscure small segments, remove them or label only the most important series. To change a series color, select one of its segments and use the formatting controls on the Format tab or the Format Data Series pane. Selecting a single segment a second time may select just that data point, so check the selection before applying a change.

Use the legend to explain series names, not to repeat the chart title. If the category names are long, a horizontal bar chart often gives them more room than a vertical column chart. For a cleaner result, remove unnecessary gridlines or borders, but keep enough axis information for people to understand the scale.

Read the bars and understand their limits

In a standard stacked bar chart, the full bar represents the sum of the series values for that category, and each colored section represents one series. The first series starts at the axis; subsequent series begin where the previous segment ends. This makes the first segment relatively easy to compare across categories, because it shares a common starting point. Segments in the middle are harder to compare precisely: their starting positions shift from bar to bar. The final segment can also be difficult to compare because its far edge depends on all the segments before it.

That limitation matters when the main question is, for example, whether Product B sold more in one region than another. A clustered bar chart, a small data table, or a separate chart for that series may make the comparison clearer. A stacked bar works best when the audience needs to see composition and total together, rather than make exact comparisons of every component.

Negative values need extra care. Excel plots positive and negative values on opposite sides of the zero axis rather than treating a negative amount as an ordinary positive component. If a chart mixes gains and losses, explain the meaning of the signs and ensure the axis shows zero clearly. For values that represent parts of a whole, negative numbers may indicate that the data or the chart type needs reconsideration.

Reorder categories and series

The order of the worksheet data affects the visual order of the chart. To change the order of the stacked components, select the chart and use Chart Design > Select Data. In the series list, select a series and use the move-up or move-down controls. This also changes the legend order. Keep the order intentional—for example, a consistent sequence of stages or a sensible progression from smaller to larger components can make comparisons easier.

For a horizontal bar chart, the first category may appear at the bottom rather than the top, depending on the axis settings. To reverse the category order, right-click the category axis, choose Format Axis, and look for Categories in reverse order under Axis Options. Reversing categories can also affect where the value axis appears, so check the chart afterward and adjust the axis crossing option if necessary. The exact controls can vary slightly with the chart and Excel build.

Fix common stacked bar chart problems

  • The bars are stacked in the wrong direction or grouped unexpectedly: Select the chart and use Chart Design > Switch Row/Column. Confirm that each row is a category and each column is a series, or restructure the table if that better reflects the data.
  • Excel shows generic series names: Add descriptive headings to the source data or edit the series names through Chart Design > Select Data.
  • A bar is much longer than expected: Check for an included total, an accidental extra column, or values recorded in inconsistent units. Also verify that a percentage has not been entered as a whole number in some rows and as a decimal in others.
  • Some categories or values are missing: Check the selected source range and inspect blank cells, text-formatted numbers, and filters. Use Select Data to verify the chart’s data range and category labels.
  • The chart is hard to read: Reduce the number of series, shorten long labels, consider 100% stacked bars if proportions are the point, or switch to clustered bars if individual series comparisons matter more.

When the source range changes, Excel may update a chart automatically if the new data is within its recognized range, but do not assume that every added row or column is included. Select the chart and inspect Chart Design > Select Data when a new category does not appear. Converting a tidy data range into an Excel table can make ongoing additions easier to manage, though it is still worth checking the chart after changing the table structure.

When a stacked bar chart is a good choice

Use this chart when categories are naturally compared as totals made from the same components. Examples include hours by task for each project, units by product line for each sales territory, or a monthly workload split among teams. The horizontal layout is especially practical when category names are lengthy or when there are many categories, because labels can sit beside the bars.

It is less suitable when the series are unrelated, when there are so many components that the colors become difficult to distinguish, or when readers must compare precise values for every component. In those cases, separate charts, a table with conditional formatting, or a clustered bar chart may communicate the information more directly. If your reader primarily cares about share rather than volume, use 100% stacked bars—but make the loss of absolute totals clear in the title or accompanying text.

Frequently Asked Questions

How do I make a stacked bar chart in Excel?
Select the category labels and series data, including the headers, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Use Chart Design > Switch Row/Column if Excel assigns the categories and series incorrectly.

What is the difference between a stacked bar and a 100% stacked bar?
A stacked bar displays actual values, so bar lengths show category totals. A 100% stacked bar scales every category to 100% and shows the proportion represented by each series, but not the original totals.

Can I change the order of the stacked sections?
Yes. Select the chart, choose Chart Design > Select Data, then move the series up or down in the series list. The change affects both the stack order and the legend order.

Why are my categories appearing as series?
Excel has interpreted the rows and columns opposite to what you intended. Select the chart and choose Chart Design > Switch Row/Column, then check that the legend names and category axis match your data.

Should I use a stacked or clustered bar chart?
Use stacked bars when totals and their component makeup both matter. Use clustered bars when comparing individual series values across categories is the main task, because the bars share a common baseline.

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.