Grouped Stacked Column Chart in Excel: How to Make One

Charts & pivot tables · Updated November 20, 2026

Excel does not offer a chart type named grouped stacked column chart, but you can build one with a standard 2-D Stacked Column chart and a carefully arranged data table. Give each group its own set of component series, place the groups in separate category rows, and add blank spacer rows if you want a visible gap between groups.

What a grouped stacked column chart shows

A stacked column chart combines two comparisons in one view. The height of each column shows a total, while its colored segments show how that total is divided among components. Grouping places related stacked columns beside one another so readers can compare those totals and their composition across a larger category, such as a quarter or region.

For example, suppose a company wants to compare Product A and Product B sales for two channels, Online and Retail, in each quarter. Each channel should appear as a separate stacked column within a quarter, and each column should be divided into Product A and Product B. A regular clustered column chart would show the channel comparison but not stack the products. A regular stacked column chart would stack the products but needs a data layout that gives each channel its own category position.

The workaround is useful, but it is not an automatic chart setting: Excel treats each channel’s component columns as separate data series. You may need to adjust the legend and colors to make the relationship between matching components obvious.

How the data layout works

Set up one row for each combination of main category and group. Use separate series columns for each group’s stacked components. In the example below, the main category is quarter, the groups are Online and Retail, and the components are Product A and Product B:

  • Columns A and B contain the category labels: Quarter and Channel.
  • Columns C and D contain Online Product A and Online Product B.
  • Columns E and F contain Retail Product A and Retail Product B.
  • For an Online row, enter its values in C and D and enter 0 in E and F. For a Retail row, do the reverse.

That means a Q1 Online row might have values of 40 and 25 in the Online columns, with zeros in the Retail columns. A Q1 Retail row might have values of 30 and 35 in the Retail columns and zeros in the Online columns. The chart will draw one stack for each row, using the group-specific series that contain values. The matching group-specific component series should be formatted with the same color—for example, both Product A series in blue—so the legend and bars are easier to interpret.

For multiple quarters, list the rows in a consistent order, such as Q1 Online, Q1 Retail, a spacer row, Q2 Online, Q2 Retail, and so on. Repeat the quarter label on both rows. If the labels are in two adjacent columns, Excel can use them as a multi-level category axis, with the quarter as the parent label and the channel beneath it. A spacer row with blank category labels and zero values creates a visual break between quarters. It is optional; without it, the categories remain adjacent.

Build the chart in Excel for Microsoft 365

  1. Arrange the source data as described above, including clear series headings and the two category-label columns. Use zeros for the group-specific series that do not apply to a row.
  2. Select the full data range, including headings, both category-label columns, and any spacer rows.
  3. On Windows, choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Choose Stacked Column, not 100% Stacked Column, unless you specifically want every column scaled to 100 percent.
  4. Check that the chart has a column for each populated category row and that its vertical stacks are made from the expected components. If Excel has interpreted the data in the wrong direction, select the chart and use Chart Design > Switch Row/Column.
  5. If the quarter and channel labels do not both appear, use Chart Design > Select Data to inspect the chart data range and category axis labels. Include both label columns in the category range.
  6. Add a descriptive chart title and, when useful, axis titles from Chart Design > Add Chart Element. Make the title say what the values measure and what groups are compared.

In Excel for Mac, select the data and use Insert > Column or Bar Chart > Stacked Column. The chart design controls are available when the chart is selected; their precise placement can vary with the ribbon layout. Excel for the web also supports column charts, though some detailed formatting and chart editing options may differ from the desktop app.

Make the groups and stacks easy to read

Because the chart uses separate series for each group, thoughtful formatting is important. Choose a consistent color for each component across groups, then use a variation such as a lighter shade, a border, or a pattern to distinguish the groups if color alone is not clear. For instance, use blue for Product A in both channels and orange for Product B in both channels. If you also distinguish Online from Retail, make that distinction consistent throughout the chart and explain it in the legend or a subtitle.

To change the spacing, right-click a column and choose Format Data Series. In the Format Data Series pane, adjust Gap Width. A smaller gap makes columns wider; a larger gap creates more separation between category positions. Since the chart uses category rows rather than a native cluster setting, changing Gap Width affects the overall spacing, not just the space between the groups. Spacer rows offer a straightforward way to create a larger break between quarters.

Keep the vertical axis scale consistent when comparing totals. Avoid removing the axis or truncating it in a way that exaggerates small differences. Data labels can help when exact values matter, but labeling every segment in a chart with many categories can make it crowded. Consider labeling totals or using a nearby table for exact values instead.

Choose the right stacked chart type

Use a standard Stacked Column chart when the actual totals matter and the component values share a meaningful unit, such as units sold, hours, or dollars. The full height of each column represents the sum of its segments. Because totals can differ, this chart lets readers compare both overall size and composition, although small segments may be difficult to compare precisely.

Use a 100% Stacked Column chart when the main question is how each total is divided proportionally. Excel scales every stack to the same height, so segment sizes represent shares rather than absolute amounts. This makes composition easier to compare when totals vary, but it hides the total-size comparison. A regular clustered column chart is a better choice when comparing individual component values is more important than seeing the combined total.

A useful check is to ask what a reader should compare first: total size, share of total, or individual component values. If all three are equally important, one chart may not communicate them well. A paired chart or a compact table alongside the chart can be clearer than adding more labels and colors to a single view.

Common problems and fixes

  • The chart shows one stack per quarter instead of separate group stacks: Check that each group has its own component series and that each group occupies its own data row. A single pair of component columns will create only one stack for each category row.
  • All series appear in the legend as unrelated items: Rename the series headings to make their roles explicit, such as Online—Product A and Retail—Product A. Keep corresponding component colors consistent across those entries.
  • Blank values create confusing category behavior: Use zero for the group-specific series that do not apply to a row. A zero contributes no segment height but keeps the series and row structure predictable. Keep spacer-row labels blank so the axis does not display an unintended category name.
  • The columns are too close together or too far apart: Adjust Gap Width in Format Data Series, then review the chart at its intended display size. Add spacer rows between main categories when a stronger group boundary is needed.
  • The category axis displays duplicated or awkward labels: Use separate columns for the main category and subgroup, repeat labels in a consistent order, and verify the category label selection through Chart Design > Select Data. Excel may show multi-level category labels when both columns are included.
  • One segment appears to be missing: Check that the source value is numeric, that the correct data range is selected, and that the series has not been excluded in Select Data. Also confirm that the segment is not simply too small to notice at the current scale.

Keep the chart maintainable as data changes

Use clear headings and preserve the same row pattern as new periods or groups are added. If you append rows outside the original chart source range, Excel may not include them automatically. Select the chart and inspect Chart Design > Select Data, or expand the source range. Converting the source into an Excel table can make it easier to maintain a growing dataset, but verify that the chart includes the new rows after adding data.

Keep the source table separate from presentation tweaks. For example, do not replace a missing measurement with zero unless zero is genuinely the right value; a missing observation and a measured zero have different meanings. If missing data should not be plotted, handle it deliberately and check how Excel displays empty cells in the chart. Spacer rows are a formatting device, not data records, so keep them visually and logically distinct from real observations.

Before sharing the workbook, check that the chart still makes sense when printed or viewed at a smaller size. Include units in the axis title or chart title, use readable text, and do not rely on color alone to identify series. A concise note can explain that each column is a group total and its segments are components.

Frequently Asked Questions

Does Excel have a grouped stacked column chart type?
Not as a separate built-in chart type in the standard chart menu. The common approach is to create a Stacked Column chart using separate series for each group and arrange the category rows to place group stacks side by side.

How do I put a gap between groups?
Add a blank category row between groups or main categories, with blank category labels and zero values in the series columns. You can also adjust Gap Width, but that changes general column spacing rather than creating a group-only gap.

Can I use this chart with more than two groups?
Yes. Add a separate set of component series for every group, and give each group its own row within each main category. As groups and series multiply, the legend can become difficult to read, so test whether a simpler chart would communicate the comparison better.

Why do the component colors repeat as separate legend entries?
Each group-specific component is a separate Excel series, even if two series represent the same component. Give matching components the same color and use descriptive series names so readers can connect the entries.

Should I use stacked or 100% stacked columns?
Choose Stacked Column to compare actual totals and their components. Choose 100% Stacked Column to compare proportions when the total size is less important; it makes every stack the same height.

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.