Can You Cluster a Stacked Bar Chart in Excel?

Charts & pivot tables · Updated November 19, 2026

Yes, but Excel does not offer a built-in chart type that both clusters and stacks bars. In Microsoft 365 for Windows, the practical workaround is to arrange each group as consecutive rows, insert a stacked bar chart, and use multi-level category labels; this puts related stacks together, though not side by side in a true cluster.

What clustered stacked bars mean

A stacked bar shows how several components add up to a total. For example, a bar for North could contain separate segments for Product A, Product B, and Product C. A clustered bar places separate bars next to one another for comparison. A clustered stacked chart combines the two ideas: each group has multiple bars, and every one of those bars is divided into components.

That layout can be useful when comparing two periods across several regions. You might want a pair of stacked bars for each region—one for 2024 and one for 2025—with each bar split into three product categories. Excel’s standard chart gallery offers stacked and clustered chart types, but not a native chart type that combines both arrangements in one straightforward choice. The distinction matters: a stacked chart with adjacent category labels can suggest grouped comparisons without actually placing bars in a cluster.

The simplest Excel workaround: group adjacent rows

For many reports, the clearest option is to create one data row for each region-period combination. Keep the component series in separate columns and put the group and period labels in two adjacent columns. For example:

Region Period Product A Product B Product C
North 2024 12 8 5
North 2025 15 7 6
South 2024 9 11 4
South 2025 13 10 7

Select the full table, including both label columns and the headers. Then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Excel uses the three product columns as series and the Region and Period columns as category labels. Because each row is its own category, the chart has one stacked bar per row; the repeated region labels visually group the period bars together.

This example produces totals of 25 and 28 for North, and 24 and 30 for South. Those totals are the sums of the segments in each row. The bars for North appear consecutively, followed by the bars for South, making it easy to scan the change between periods while retaining the composition of each total.

How to format and read the grouped chart

Excel may display the two label columns as a multi-level category axis. If the labels do not appear as expected, right-click the chart and choose Select Data. In the Horizontal (Category) Axis Labels area, choose Edit and select the cells in both label columns for the data rows. The axis can then show Region as the outer label and Period as the inner label. The exact appearance depends on the chart size and Excel’s label spacing.

  • Use a distinct, consistent color for each component across every bar. That makes changes in composition easier to follow.
  • Add data labels only when the chart remains readable. Labels on every segment can become crowded when there are many groups or series.
  • For a horizontal bar chart, Excel may place the first category at the bottom. If you want it at the top, right-click the category axis, choose Format Axis, and select Categories in reverse order.
  • Adjust the gap between bars with Format Data Series > Series Options > Gap Width. A smaller gap makes adjacent periods look more closely grouped, but too little space can blur the distinction between groups.

This approach is often called a grouped or clustered stacked bar chart in casual conversation, but technically it is a stacked chart with grouped category labels. Its bars are consecutive rather than truly side-by-side within a shared category slot. That difference is usually acceptable for a modest number of groups and periods, and the data structure is easy to maintain.

When you need true side-by-side stacks

If the requirement is specifically two or more stacks side by side for each region, the adjacent-row approach does not meet it. Excel’s regular stacked bar chart creates one stack for each category row, while a regular clustered bar chart separates series into bars instead of stacking them. There is no single standard chart-type button that tells Excel to cluster groups of stacked series automatically.

Some workbooks use helper series, blank cells, and invisible or spacer bars to imitate the missing layout. Such designs can produce a closer visual match, but they take careful planning: the plotted series order, blank versus zero values, series overlap, axis labels, and legend all affect the result. A change to the source data can also upset the spacing or labels. If you use this method, build a small prototype first and verify that the displayed totals and segments correspond to the source table. Avoid treating a decorative spacer as real data.

For a presentation where exact side-by-side grouping is essential, consider whether the chart can be split into small multiples—one stacked chart per period—or whether a different reporting tool is more suitable. Small multiples preserve a consistent component scale and can be easier to compare than a heavily engineered chart. If you only need to show the total and the component proportions, a regular stacked chart may communicate the point more clearly.

Choosing between stacked, clustered, and 100% stacked

Choose a standard stacked bar when both the total and the parts matter. In the example, North’s total rises from 25 to 28, while the colored segments show how the product mix changes. Stacking makes totals visible, but middle segments do not share a common starting point, so comparing one component across many bars can be harder than comparing it in a clustered chart.

Choose a clustered bar when comparing individual component values is more important than showing each total as a whole. The bars for Product A, B, and C can sit next to one another for each region-period combination, making direct comparisons easier, but the reader must add the series mentally to understand the total.

A 100% stacked bar is useful for comparing proportions rather than absolute amounts. Each bar is scaled to the same full length, so it highlights how the mix changes even when totals differ. In the example, North’s total is 25 in 2024 and 28 in 2025; a 100% chart would make both bars equal in overall length and hide that increase. Use it only when composition is the main question, and label the chart so readers know the bars represent percentages.

Common problems and fixes

  • The chart shows one series per row instead of one per component: Check Select Data. Use Switch Row/Column if Excel interpreted the table in the wrong direction, then confirm the category labels include the two label columns.
  • The bars are not visibly grouped: Keep each region’s periods next to one another in the source table. Add a blank row between regions only if the extra whitespace helps; a blank row may also create an empty category, so inspect the chart after adding it.
  • Zeros appear as empty-looking segments: A zero has no visible bar length, while a blank cell can be treated differently depending on chart settings. Use zero when the measured value is genuinely zero; do not replace missing information with zero unless that is what it means.
  • The chart compares inconsistent units: Stacking unrelated measures, such as dollars and customer counts, creates a total with no meaningful unit. Stack components only when they are additive and use the same unit.
  • The legend is confusing: The legend should identify the stacked components, not the group labels. Use clear series headers and, if necessary, a separate chart title or axis label to explain the periods and measurement.

Refreshing the chart as data changes

For a chart that will be updated regularly, format the source range as an Excel table with Home > Format as Table or Insert > Table. Tables can expand as you add rows, and charts based on table data can include new records as the table grows. Still, check that the category labels and series remain correct after adding data, especially if you insert a new period in the middle or add a component column.

Keep the table in a tidy rectangular layout: one row per region-period combination, one column per component, and no merged cells in the data area. Avoid inserting totals as extra data rows unless you intend Excel to plot them; otherwise, the chart may double-count visually by showing a total bar alongside the component bars. If you need a total label, use a separate annotation or a carefully designed helper series rather than adding a total as another stacked component.

Frequently Asked Questions

Can Excel make a clustered stacked bar chart directly?
No. Excel for Microsoft 365 does not provide a standard chart type that automatically clusters multiple stacked bars within each category. Adjacent rows with multi-level labels are a simple approximation; helper-series techniques can imitate a true cluster but need extra maintenance.

Can I put two stacked bars next to each other for every category?
Not with the ordinary stacked bar chart setting alone. You can place each category-period combination on its own row to group bars in sequence, or use a more involved helper-series design if side-by-side placement is mandatory.

Should I use zero or leave a cell blank?
Use zero when the value is known to be zero. Leave a cell blank when the value is unavailable or intentionally not applicable, and check how the chart displays empty cells. A blank should not be used to disguise a real zero.

Can I make this chart in Excel for Mac or Excel for the web?
The basic stacked bar chart is available in current Excel for Mac and Excel for the web, though ribbon labels and some formatting controls can differ. The Windows ribbon path above is for Microsoft 365 on Windows; check the equivalent Insert chart options and axis formatting controls in your version.

When should I choose a 100% stacked bar instead?
Use it when the main goal is to compare shares of each total, not the totals themselves. Because every bar is normalized to 100%, absolute differences between categories are no longer visible.

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.