Excel Side-by-Side Stacked Bar Chart: How to Make One

Charts & pivot tables · Updated November 19, 2026

Excel does not have a built-in chart type that clusters multiple stacked bars in one category. A practical workaround is to put each group on its own row, use two category-label columns, and insert a regular Stacked Bar chart; Excel can then display the group bars together under each main category.

What a side-by-side stacked bar chart shows

A stacked bar divides each bar into segments, with each segment representing a component of the total. A side-by-side version places two or more of those bars next to one another for each main category, so readers can compare both the overall totals and their composition. For example, a sales report might show a Plan stack and an Actual stack beside each other for every region, with each stack divided into product lines.

The phrase can be confusing in Excel. A standard Stacked Bar chart stacks all selected series into one bar for each category. It does not automatically create separate stacks for two groups. Excel has Clustered Bar and Stacked Bar chart types, but no ordinary built-in chart type that combines clustering and stacking in that exact way. The data-layout workaround below creates paired stacks as separate category rows and uses a multilevel category axis to show which rows belong together.

Set up the source data

Use one row for every main-category and group combination. Put the main category in the first column, the group name in the second, and the components to be stacked in the remaining columns. For example:

Region Period Product A Product B Product C
North Plan 30 20 10
North Actual 24 25 8
South Plan 22 18 15
South Actual 26 16 14

Here, each row becomes one stacked bar. North has a Plan bar and an Actual bar; South has the same pair. Product A, Product B, and Product C form the segments in every bar. Keep the two label columns immediately to the left of the numeric data, and use a clear heading for every column. Sort the rows first by Region and then by Period so the paired bars appear together and in a predictable order.

For a fair comparison, ensure that each group has the same set of component columns. If a component is absent in a particular group, enter zero when that absence genuinely means no amount. A blank may also plot as no segment, but zero is clearer for readers and avoids ambiguity in the source data. Do not use a text entry such as “n/a” in a numeric series if you expect Excel to chart it as a value.

Create the chart in Excel for Microsoft 365

  1. Select the complete data range, including both label columns, all component columns, and the headers.
  2. On Windows, choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Choose Stacked Bar, not 100% Stacked Bar, unless you specifically want to compare proportions rather than totals.
  3. Check that the chart has one bar for each data row and that the Region and Period columns appear as category labels. Excel normally uses adjacent text columns to create a multilevel category axis.
  4. If the series or labels are assigned incorrectly, select the chart and choose Chart Design > Switch Row/Column to check the alternative arrangement. If needed, use Chart Design > Select Data to inspect the chart data range and series.
  5. Give the chart a descriptive title, then add a legend and data labels if they help explain the comparison.

Excel for Mac has the same basic chart approach: select the table and use the Insert tab to choose a 2-D Stacked Bar chart. Ribbon wording and the position of chart-formatting controls can differ slightly by Mac release, but the underlying data layout is the same. Excel for the web also supports common chart insertion and formatting, though some detailed formatting controls may be more limited than in the desktop app.

How the paired-bar layout works

The first two columns are not plotted as numeric series; they identify the bar and its parent category. Excel uses Region as the outer category and Period as the inner category, so the axis can visually group Plan and Actual beneath North, then beneath South. Each row still has its own bar. In a horizontal bar chart, those bars appear as neighboring rows vertically; “side by side” describes their pairing within each category group, not two bars sharing the same horizontal baseline in one row.

The numeric columns are the actual stacked series. In the North Plan example, the total bar length is 60 (30 + 20 + 10). North Actual totals 57 (24 + 25 + 8). The corresponding South totals are 55 for Plan and 56 for Actual. The chart therefore lets a reader compare both total length and the contribution of each product. The figures are illustrative; the chart simply plots the values in the selected cells.

Keep the same component in the same series column throughout the table. That makes Product A the same color in every bar, and likewise for the other products. If rows are arranged inconsistently or product values shift to different columns, the segments will no longer communicate a consistent category.

Choose stacked bar, 100% stacked, or clustered

  • Stacked Bar is appropriate when both totals and component amounts matter. Bar length represents the total, so larger totals are visibly longer.
  • 100% Stacked Bar scales every bar to the same length. It emphasizes each component’s share of its group, but hides differences in total size. In the example, North Plan and North Actual would both extend to 100% even though their totals differ.
  • Clustered Bar places series next to one another rather than stacking them. It can make individual component values easier to compare across groups, but it does not show each group as a single segmented total.

Use a stacked chart when the components are meaningful parts of a whole and readers need to see the total. If precise comparison of middle segments is important, remember that those segments do not share a common starting point across bars. A clustered chart or a small-multiple layout may make those individual values easier to compare.

Format the chart for clear comparisons

Use a stable color for each component and keep the legend order consistent with the stack order. If the legend or stack order is not intuitive, select the chart and open Chart Design > Select Data; the series list lets you adjust series order. In a stacked bar, series order determines the sequence of segments, so make sure the visual order is easy to follow.

To change spacing, right-click a bar and choose Format Data Series. In the formatting pane, adjust Gap Width. A smaller gap makes the bars thicker and the pairs more prominent; a larger gap separates bars more. Excel does not provide a separate gap-width control for each parent category in this workaround, so avoid shrinking the gaps so much that readers cannot distinguish one group from another. If the chart has many regions, consider reducing the number shown or enlarging the chart rather than forcing every label into a cramped space.

Data labels can show segment values, but labels on small segments may overlap or become hard to read. Add them only when they clarify the chart. A useful alternative is to label total values at the ends of bars and leave component values in the table or tooltip. Include units in the chart title or axis title—for example, “Sales (thousands of dollars)”—and check whether the horizontal value axis should begin at zero. For bar lengths representing amounts, a zero baseline is generally important because a truncated scale can exaggerate differences.

Common problems and fixes

  • Excel makes one stack per region instead of a pair. Confirm that each group has its own row and that both label columns are included in the selected range. If the chart still treats the data unexpectedly, use Chart Design > Select Data to check the chart range and series.
  • The group labels do not appear. Make sure Region and Period are adjacent text columns to the left of the values. If the axis shows only one label level, inspect the axis formatting options for multilevel category labels and confirm that the chart includes both label columns.
  • Bars are in the wrong order. Sort the source rows in the desired sequence. To reverse the displayed category order, right-click the category axis, choose Format Axis, and use the axis options; the exact effect can depend on whether the value axis crosses at the maximum category.
  • Totals look wrong. Check that the chart type is Stacked Bar rather than 100% Stacked Bar, and verify that each component is numeric and placed in the correct row. A 100% chart displays proportions, not raw totals.
  • Colors change or the legend is confusing. Keep components in fixed columns and rename unclear headers. Format a series once so that the same component has a consistent color throughout the chart.

When a different approach is better

The repeated-row method is a good fit when there are a few groups per category and the main goal is a readable comparison of totals and composition. It also keeps the source table in a straightforward, auditable form. It is less suitable when there are many groups, when every bar needs a custom position, or when the group bars must occupy precisely controlled slots with custom spacing.

For more complex presentations, consider separate charts with the same scale, small multiples, or a PivotChart built from appropriately structured data. Separate charts can make each comparison less crowded, though aligned scales and matching colors are important. A PivotChart can help when users need to filter or summarize categories interactively, but the chart type still needs to match the analytical goal. If exact clustered-and-stacked positioning is essential, a carefully designed helper table or a custom charting tool may be needed; that adds maintenance and should be documented so later users understand the transformed data.

Frequently Asked Questions

Can Excel make a clustered stacked bar chart directly?
Not as a standard chart type in Excel for Microsoft 365. Use separate rows for each group, include two category-label columns, and create a Stacked Bar chart to show grouped stacks through the category axis.

What is the difference between a stacked bar and a 100% stacked bar?
A Stacked Bar chart preserves the actual total lengths. A 100% Stacked Bar chart makes every bar the same length and shows each component as a proportion of its total.

Can I make the bars vertical instead?
Yes. Use Insert > Insert Column or Bar Chart > 2-D Stacked Column. The same row-based data can create paired stacks along the horizontal category axis, though long category labels may be harder to read.

Why are my two bars not grouped under the same category?
Usually, the chart range is missing one of the label columns, or the source rows are not sorted so matching categories are together. Include both label columns and place each category’s group rows consecutively.

Should I use blanks or zeros for a missing component?
Use zero when the component’s value is genuinely zero. A blank can be appropriate for unavailable data, but it should not imply a known zero; explain missing values separately so viewers do not mistake them for no contribution.

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.