Clustered Stack Column Chart in Excel: How to Make One

Charts & pivot tables · Updated November 19, 2026

Excel does not offer a chart type named Clustered Stacked Column, but you can create the same visual by arranging each category-and-group combination on its own row, then inserting a 2-D Stacked Column chart. Excel plots each row as a separate stacked column, so the columns for each group sit beside one another under a shared category label.

What a clustered stacked column chart shows

A clustered stacked column chart combines two comparisons. The clusters compare groups within a category, while the stacked segments show how each group’s total is made up of several parts. For example, a regional sales chart could place two columns beside each other for two years, with each column divided into product types.

The distinction between categories, groups, and segments matters when you prepare the data. In that example, Region is the main category, Year is the subgroup, and product types are the stacked series. A normal stacked chart with Region as its only category would combine all the years into one stack per region; it would not create a separate stack for each year.

Excel’s chart is technically a stacked column chart with multi-level category labels, rather than a separate built-in clustered-stacked chart type. The result can still communicate the intended comparison, but the data layout is what creates the side-by-side stacks.

Set up the source data

Put the main category and the subgroup in separate columns, followed by one column for each segment that will make up a stack. Give every row one category-and-subgroup combination. Keep the subgroup rows together within each category, and use the same subgroup order throughout the table.

Region Year Core Support Other
North 2024 40 15 5
North 2025 32 12 8
South 2024 28 10 2
South 2025 35 9 6

Here, North has one stack for 2024 and another for 2025, and South has the same pair. Each stack has three segments: Core, Support, and Other. The chart’s legend will identify those segments, while the category axis can show Region and Year as two levels.

Use one row per stack, even if the source information is arranged differently. If your data is in a long list with columns for Region, Year, Product, and Value, summarize it into this wide layout first—for example, with a PivotTable—so each product type becomes a separate value column. Avoid merging cells in the chart source; merged labels can make ranges harder to select and maintain.

Create the chart in Excel for Windows

  1. Select the complete data range, including the headers and both label columns. In the example, that means selecting the Region, Year, Core, Support, and Other columns for all four data rows.
  2. Choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Do not choose 100% Stacked Column unless you specifically want every stack scaled to the same height.
  3. Check the chart. Each table row should appear as a column, with the three segment series stacked in it. The axis should show the group labels under their shared region labels.
  4. If Excel uses the wrong rows or columns, choose Chart Design > Switch Row/Column and inspect the result. For this layout, the segment names should be the series in the legend and each category-subgroup row should be a separate plotted position.
  5. If the labels are missing or incorrect, choose Chart Design > Select Data. Confirm that the chart data range includes both label columns and all segment columns. The horizontal axis label range should include the Region and Year columns, while the legend entries should list Core, Support, and Other.

Excel normally recognizes adjacent text or date label columns as a multi-level category axis when both are included in the selected range. If you see only one label level, revisit the axis label range in Select Data and include both columns. In Excel for Mac, the chart options are also on the Insert tab, though ribbon wording and placement can vary slightly by release; choose the stacked column chart and include both label columns in the source selection.

Format the stacks and category labels

Make the relationship between the two levels of comparison easy to read. Use a descriptive chart title such as Sales by Region and Year, and keep the legend labels short but meaningful. Excel uses the series names from the header row, so improve those names in the worksheet rather than leaving generic headings such as Series 1.

To change the order of the segments, select Chart Design > Select Data, then use the move-up or move-down controls under Legend Entries (Series). Series order determines the stack order. The first series is generally placed at the bottom of a positive stack, so put the segment you want at the base first. The legend order changes along with the series order.

For column spacing, select a column and open Format Data Series, then adjust Gap Width. A smaller gap makes columns wider; a larger gap gives them more separation. Gap Width affects the columns across the chart, not just the space between each pair of groups. If the category groups are not visually distinct enough, a larger overall gap can help, but it may also make individual columns narrow.

Use colors consistently for the same segment in every stack. For instance, if Core is blue, keep it blue for every region and year. Avoid assigning a different color to every individual column: that makes the segment legend harder to interpret and obscures the common structure. Data labels can be added from Chart Design > Add Chart Element > Data Labels, but labels on every segment may crowd a chart with many groups.

Choose stacked or 100% stacked

A regular stacked column chart preserves the actual values and total height of each stack. In the example, North in 2024 totals 60 (40 + 15 + 5), while North in 2025 totals 52 (32 + 12 + 8). The visible height difference is meaningful because the totals differ.

A 100% stacked column chart scales each stack to 100%, making it useful when the question is about composition rather than total size. It would make it easier to compare what share of each region-year total came from Core, Support, and Other. However, it hides the difference between a total of 60 and a total of 52 unless you show the totals separately. It is a common mistake to use 100% stacked columns when readers need to compare both component amounts and overall totals.

Stacking is most effective when the segments have a meaningful whole and readers need to see both the total and the breakdown. Only the bottom segment shares a common baseline across columns, so comparing middle segments precisely can be difficult. If accurate comparison of every component is the main goal, clustered columns or a line chart may be clearer.

Common problems and fixes

  • All the data appears in one stack per category: Your rows may represent only the main category, or the subgroup may have been added as a series instead of a category label. Put one category-subgroup combination on each row, and use the segment columns as the chart series.
  • The chart has one label level: Reopen Chart Design > Select Data and set the horizontal axis label range to include both the main-category and subgroup columns. Check that both columns have a value for each data row.
  • There are too many legend entries: The group field may have been split into separate value series. In the intended layout, each component is a series and the group is a row label. Reduce the number of components or use another chart design if the number of segments is itself too large.
  • Some stacks look shorter or incomplete: Check for blank cells, text stored where numbers are expected, or values omitted from the source range. Also confirm that rows have not been sorted so that group labels are separated from their categories.
  • The order of columns is wrong: Sort the source rows into a consistent category-then-group order. To change the order of segments within each stack, change the series order in Select Data rather than rearranging the category rows.

Negative values require care: Excel can plot negative stack values below the horizontal axis, so a column may extend both upward and downward. The visual total is then not a simple sum of positive segments. Explain what positive and negative values mean, and consider a different chart if that layout would confuse the audience.

When another chart is a better choice

For two or three groups with a few segments, clustered stacks can be a compact way to compare totals and composition together. As categories, groups, or segments multiply, the chart can become crowded. A useful rule is to keep the number of stacks per category small and make the series count manageable; the exact limit depends on label length, chart size, and how closely readers need to compare values.

Choose a regular clustered column chart when comparing individual components matters more than showing how they add to a total. Choose a 100% stacked chart when proportions are the focus and totals are secondary. A small-multiple layout—one chart for each group—can be easier to read when there are many groups, especially if every chart uses the same scale. A PivotChart can help when readers need to filter or rearrange a larger dataset, but the chart still needs a suitable category-and-series structure.

There is no single best alternative for every dataset. Consider the question first: are readers comparing total size, component size, proportion, or change over time? A chart should make that comparison apparent without requiring a close reading of every label.

Frequently Asked Questions

Does Excel have a built-in clustered stacked column chart?
No. Excel has stacked and clustered column chart types, but not a single built-in type that combines clustered groups of stacks. A stacked column chart with a two-level category axis is a practical way to create the clustered-stacked appearance.

How do I put two stacked columns side by side for each category?
Give each stack its own row, repeat the main category for each subgroup, and include the subgroup in a second label column. Use the component values as the series columns, select the whole range, and insert a 2-D Stacked Column chart.

Can I use a PivotTable for the source data?
Yes. A PivotTable can summarize long-form data so the component fields appear as separate value columns and each category-subgroup combination has a row. Check the PivotTable’s row and column arrangement before charting, because a different arrangement can produce a different chart structure.

Why are my columns stacked instead of clustered?
In this method, each individual column is supposed to be stacked. The columns are clustered because separate rows create adjacent category positions. If all subgroup values appear in the same stack, check that the subgroup is in the category labels, not included as another segment series.

Can I make the chart update when I add rows?
Convert the source range into an Excel Table with Insert > Table, making sure that My table has headers is selected. Charts based on a table generally expand as rows are added, but keep the two label columns and component columns in the same structure and confirm the chart includes new rows.

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.