Excel Grouped Stacked Bar Chart: How to Create One

Charts & pivot tables · Updated November 19, 2026

Excel does not offer a built-in chart type that combines clustered bars with stacked segments. You can create the same visual by arranging the data so each group has its own chart category, leaving unrelated series blank, and then inserting a stacked bar or column chart.

What a grouped stacked chart shows

A grouped stacked chart places two or more separate stacks beside one another for each main category. The stack height or length shows a total, while its colored segments show the contributions that make up that total. For example, you might compare Retail and Online sales in each region, with each channel’s bar split into Product and Service sales.

This is different from a standard stacked chart, where Excel puts every series for a category into one stack. It is also different from a clustered chart, where series appear beside one another but are not stacked. Excel’s chart types include stacked and clustered options, but not a direct combination that automatically clusters multiple stacks.

The workaround below uses a stacked chart and a helper-table layout. It works for vertical columns as well as horizontal bars; choose the orientation that makes your category names and comparisons easiest to read.

Prepare the data with a helper table

Give every bar its own row. Use one column for the main category and another for the subgroup that should sit beside it. Then make a separate value column for each stack component and subgroup. For the sales example, the table could look like this:

  • North | Retail | Product—Retail: 70 | Service—Retail: 30 | Product—Online: blank | Service—Online: blank
  • North | Online | Product—Retail: blank | Service—Retail: blank | Product—Online: 45 | Service—Online: 55
  • South | Retail | Product—Retail: 60 | Service—Retail: 40 | Product—Online: blank | Service—Online: blank
  • South | Online | Product—Retail: blank | Service—Retail: blank | Product—Online: 50 | Service—Online: 50

Put the headers in the first row and the records beneath them. In a real worksheet, the columns might be A:F, with Region and Channel in A:B and the four value series in C:F. Leave cells for the other subgroup genuinely empty rather than entering zero. A zero can be a meaningful measured value; a blank signals that this series does not belong in that subgroup’s stack.

Keep the row order consistent: list each region’s Retail row next to its Online row, then move to the next region. If your groups have more than two components or subgroups, add the corresponding series columns and rows. The table is a charting layout, so it can be placed on a separate worksheet from the original data.

Build the stacked chart in Excel

  1. Select the full helper table, including both label columns, the series headers, and the data rows.
  2. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Stacked Column for vertical bars. For horizontal bars, choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar.
  3. Check that Excel has treated the value columns as separate series and the Region and Channel columns as category labels. The chart should show two adjacent stacks for each region.
  4. If the chart is oriented incorrectly, use Chart Design > Switch Row/Column. If that does not give the intended result, choose Chart Design > Select Data and check the chart data range and category-axis labels.

When Excel recognizes both label columns, it can display them as a multi-level category axis: the subgroup labels appear under each bar and the main category labels group the adjacent bars. If it shows only one label level, open Chart Design > Select Data and set the horizontal (category) axis label range to include both label columns. Excel for Mac has the same general chart commands in its ribbon, though the arrangement can vary by window size. Excel for the web also supports standard chart insertion and editing, but some formatting controls may be more limited than in the Windows desktop app.

Format the stacks so the comparison is clear

In this example, the chart has four series: Product—Retail, Service—Retail, Product—Online, and Service—Online. Excel may assign all four different colors by default. To make the chart easier to interpret, give the two Product series the same color and the two Service series another shared color. The Retail and Online labels identify which bar contains each stack. This uses color to show component type rather than making every subgroup a different visual category.

To change a series color, select one of its segments, right-click, and choose Format Data Series. In the formatting pane, open Fill & Line > Fill > Solid fill and choose a color. Repeat for the corresponding series in the other subgroup. If the legend labels are too long, shorten the series headers in the helper table to names such as “Retail Product” and “Online Product,” while keeping them distinct enough to understand.

Add a descriptive chart title and, where needed, axis titles. For a stacked column chart, the vertical axis should state the measure and units, such as “Sales ($ thousands).” For a horizontal stacked bar chart, the value axis runs horizontally. Keep the legend visible unless the labels make each stack’s contents unmistakable. Avoid 3-D chart styles: perspective can make segment sizes harder to compare.

Choose between bars, columns, and 100% stacks

Use a stacked column chart when the main categories are short and the reader should scan values from left to right. Use a stacked bar chart when category names are long, when there are many categories, or when horizontal labels would otherwise be crowded. With horizontal bars, Excel may show the categories in an order that looks reversed; select the category axis and use Format Axis to adjust the category order if needed.

A regular stacked chart is appropriate when actual totals matter. In the example, each stack totals 100, but other data might produce different totals. A 100% stacked chart scales every bar to the same overall length and displays segment proportions instead. It is useful for comparing composition, but it hides differences in total size: a bar totaling 100 and one totaling 1,000 both occupy the same full length. Use the 100% option only when the share of each component is the point of the chart.

Understand the trade-offs of the workaround

The helper-table approach is useful because it creates side-by-side stacks without requiring a special chart type or add-in. It also keeps the values in normal Excel cells, so you can update the table and let the chart reflect those changes. However, the chart’s legend lists separate series for each subgroup. If there are many groups and many components, that legend can become unwieldy and the setup takes more maintenance.

Stacking also affects what comparisons are easy. The first segment in each stack starts at the same baseline, so it is relatively easy to compare that component across bars. Segments higher in a stack start at different positions, making their lengths harder to compare precisely. If comparing each component across groups is more important than showing totals, consider a clustered column or bar chart instead. If both totals and individual component comparisons matter, a small set of separate charts may be clearer than forcing every measure into one display.

Common problems and fixes

  • All values appear in one stack: Check that the table has a separate row for each subgroup and that the subgroup’s values are in its own series columns. A regular one-row-per-region layout with all values filled in will naturally create one stack per region.
  • Bars appear as separate unstacked series: Confirm that you selected a 2-D Stacked chart, not a Clustered chart. If needed, use Chart Design > Change Chart Type and choose the stacked option.
  • Unexpected zero-height segments or misleading totals: Check for zeros where you intended blanks, and inspect the source cells for formulas that return zero. Do not replace missing data with zero unless zero is what the data means.
  • Axis labels are confusing: Include both the main category and subgroup label columns in the axis label range. Make the subgroup names short and consistent, and check that the source rows are in the desired order.
  • There is too much empty space: Select a bar, open Format Data Series, and adjust Series Options > Gap Width. A smaller gap makes bars wider; a larger gap separates them more. If you need a larger visual break between main categories only, a blank row with blank values can create a spacer, but it also affects the axis labels.

Alternatives when the chart gets crowded

For a small number of categories, the helper-table stacked chart is usually a practical choice. For a large dataset, consider splitting the display into one chart per subgroup, using small multiples with a shared value axis. That makes segment comparisons easier and avoids a long legend. A clustered chart may also be a better fit if readers need to compare each component directly rather than see the composition of each total.

PivotCharts can summarize and filter source data, but they do not remove the underlying limitation: Excel still does not provide a native chart type that automatically clusters multiple stacks. A PivotChart may be useful for interactive summaries, while the helper table gives you direct control over the arrangement. If you use a PivotChart, verify its chart layout and labels after changing fields; it may not preserve the exact side-by-side stack arrangement you want.

Frequently Asked Questions

Can Excel make a grouped stacked bar chart directly?
Not as a single built-in chart type. Use a stacked bar or column chart with a helper table that assigns each subgroup its own category row and series columns.

What is the difference between a grouped and a stacked bar chart?
A grouped, or clustered, chart places series beside one another. A stacked chart layers series in one bar to show a total and its parts. A grouped stacked chart combines the two arrangements, with multiple stacks beside one another for each main category.

Should I use blanks or zeros in the helper table?
Use blanks for series that do not belong to a particular subgroup’s stack. Use zero only when the measured value is actually zero; otherwise, the chart may imply a value that was not recorded.

Can I make the bars horizontal instead of vertical?
Yes. Select 2-D Stacked Bar instead of 2-D Stacked Column from the Insert chart menu. The helper-table structure is the same.

Why does my chart show too many legend entries?
Each subgroup’s component columns are separate chart series, so Excel lists them separately. Use concise series names and matching colors for equivalent components, or consider separate charts if the legend becomes difficult to read.

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.