Double Stacked Bar Chart in Excel: How to Create One

Charts & pivot tables · Updated November 19, 2026

To create a double stacked bar chart in Excel, put each bar you want to compare on its own row, with one column for its main category, one for its group, and one column per stacked segment. Select the data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar (or Stacked Column). Excel does not have a separate chart type called “double stacked bar”; this layout creates two or more stacked bars for each category.

What “double stacked bar chart” means

The phrase can describe a few different charts. Often, someone wants to compare two stacked bars within each category—for example, actual and target sales for each region, with each bar divided into product lines. In that case, the key is to make a separate data row for every region-and-group combination. The result is a cluster of stacked bars under each region label.

Sometimes “double” means a bar with two segments, or a chart with two data series. Those are different things: a regular stacked bar can contain any number of component series, while a double-stacked layout usually refers to multiple complete stacks beside one another. If you only need one stack per category, use a standard stacked bar chart and add the component series as columns.

Excel’s built-in chart gallery includes Stacked Bar and 100% Stacked Bar, as well as the corresponding column charts. It does not offer a single built-in “clustered stacked bar” option that automatically builds pairs of stacks from a conventional wide table. Organizing the data as individual bars in rows is a straightforward way to get the intended comparison without complex chart workarounds.

Arrange the data for two stacks per category

Use one row for each bar, and keep the parts of the stack in separate numeric columns. For an actual-versus-target comparison, a worksheet might look like this:

Region Measure Hardware Software Services
North Actual 40 25 15
North Target 35 30 20
South Actual 30 20 25
South Target 32 24 22

Here, each row becomes one bar. Hardware, Software, and Services are the segments stacked inside it. Region and Measure together identify the bar, so Excel can use them as the two levels of category labels. Keep the labels consistent, and enter zero or leave a value blank where a segment genuinely has no value. Avoid putting totals in the segment columns: Excel will stack a total on top of its components and make the bar misleadingly long.

For a chart comparing two years, the group column could be Year, and the segment columns could be departments. For a product mix comparison, the group might be Store A and Store B, with product categories as the segments. The data structure stays the same even when the labels change.

Create the stacked bar chart in Excel

  1. Put the category and group labels in the first two columns, followed by one numeric column for every component. Include the headers.
  2. Select the complete data range, including both label columns and all segment values.
  3. Choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar for horizontal bars. Choose 2-D Stacked Column if vertical columns suit the comparison better.
  4. Check that each row appears as a separate bar and that the segment headers appear in the legend. Excel should use the first two columns as multi-level category labels.
  5. If Excel has interpreted the data in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. Keep the orientation that gives one complete stack for each row.
  6. Add a descriptive chart title and, if needed, axis titles through Chart Design > Add Chart Element. Use the legend to identify the stacked components.

The exact gallery wording can vary slightly with the ribbon display, but the chart is in the Insert tab’s column-or-bar chart menu. In Excel for Mac, use the Insert tab and the chart menu to choose the same stacked bar or stacked column type; ribbon arrangement can differ by window size and version. Excel for the web also offers stacked chart options, although some formatting controls may be more limited than in the desktop app.

Choose horizontal bars or vertical columns

A stacked bar chart runs horizontally, while a stacked column chart runs vertically. They represent the same kind of stacked values, but each makes different labels and comparisons easier to read. Horizontal bars are often a good choice when region names or group labels are long, or when there are many categories. Vertical columns can work well with a short list of categories and labels that fit along the horizontal axis.

In either orientation, the first segment in the series order starts at the axis, and the other segments extend from it. Excel uses the series order to determine the stack order and the legend order. If a segment appears in an unexpected position, use Chart Design > Select Data and adjust the series order rather than changing the data values. Keep the same series order across every group so viewers can compare the same colors and positions between bars.

Format the chart for clear comparisons

A double-stack chart can carry a lot of information, so make the grouping and segment identities apparent. Use a concise title that says what the values measure and, where useful, the time period. Keep the colors for Hardware, Software, and Services consistent in every bar. If Actual and Target need to be distinguished, use the axis labels or a clear group label rather than giving the same component different colors in different stacks.

  • Use a zero baseline. Stacked bars rely on bar length to show magnitude. A value axis that starts above zero can distort that visual comparison.
  • Label selectively. Data labels can help with a small chart, but labeling every segment in a crowded chart may make it harder to read. Consider labels for totals or key segments only.
  • Check the series order. Place the most important or consistently compared segment near the baseline, where its length is easiest to compare.
  • Use sensible number formats. Show units such as dollars, units sold, or hours on the value axis or in the title. Avoid making readers infer the scale.
  • Limit decorative effects. Strong gradients, 3-D effects, and unnecessary gridlines can obscure the segment sizes and make comparisons less reliable.

To add labels, select the chart and choose Chart Design > Add Chart Element > Data Labels, then choose a position. The best position depends on whether the segment is wide enough to hold a label. If a label is cramped or overlaps another, remove it or use a legend and axis labels instead.

When to use a 100% stacked chart

Choose 100% Stacked Bar when the main question is about composition: what share of each bar comes from each segment? Excel scales every complete bar to the same length, so the chart emphasizes proportions rather than totals. In the example, Actual and Target bars can be compared by the share contributed by each product line even if their overall totals differ.

That scaling also hides differences in total size. A region with 80 units and a region with 800 units can both appear as bars of equal length in a 100% stacked chart. If the total matters, use ordinary Stacked Bar, or show the totals separately with clear labels. Do not use the 100% version just because the input values are percentages; first decide whether viewers need to compare proportions, absolute amounts, or both.

Common problems and how to fix them

  • Excel makes one bar per component instead of stacking them. The selected chart may be Clustered Bar rather than Stacked Bar, or the rows and columns may be interpreted incorrectly. Choose the 2-D Stacked option and check Chart Design > Switch Row/Column.
  • Only one label level appears. Confirm that both label columns were included in the selected range and that the numeric columns follow them. If needed, use Chart Design > Select Data to inspect the chart data range and category axis labels.
  • There is an unwanted bar for a total. Remove the total column from the plotted range. A total is not another component and should not be stacked with the parts that make it up.
  • The stacks are hard to compare. Remember that only the first segment in each stack shares a common baseline. The starting point of later segments depends on the values before them, so their lengths are harder to compare across bars. Consider a clustered bar chart if comparing each component precisely is more important than showing the total composition.
  • Blank rows or missing values create confusing spaces. Check whether blank rows were included in the range and whether missing values mean zero or unknown. A true zero and an unavailable measurement are not always the same; label or handle missing data deliberately.
  • Category labels are out of order. Sort the source table into the order you want before charting, or adjust the category-axis settings. Keep the two rows for each category together so the paired comparison remains obvious.

If the chart is linked to an Excel table, adding rows to that table can make the source range easier to maintain. Still, verify that the chart includes new categories and series after changing the data. A chart can look plausible while omitting a recently added row, so check its source range when results seem incomplete.

Stacked bars versus other chart choices

A stacked chart answers questions about both the total and its composition. It is useful when the pieces add up to a meaningful whole, such as sales by product line or hours by work type. A clustered bar chart puts component bars side by side instead, making it easier to compare the same component across regions or groups. The trade-off is that totals are less visually immediate.

A line chart may be better when the main point is a trend across many time periods. Stacked areas can show composition over time, but they are not a direct substitute for paired bars when readers need to compare distinct groups. For a chart with just two segments, a stacked bar can work, but a clustered bar might be clearer if the audience needs to compare both values independently rather than understand their combined total.

Before choosing, ask what the reader should notice first: the total, the shares, or the value of each component. Ordinary stacked bars emphasize totals and the first segment; 100% stacked bars emphasize shares; clustered bars emphasize individual component values. No chart type makes all three comparisons equally easy.

Frequently Asked Questions

Can Excel make a clustered stacked bar chart automatically?
Excel does not provide a dedicated built-in chart type with that name. You can create the common two-stacks-per-category layout by putting each complete stack on its own row and using category and group columns for multi-level axis labels.

How do I put two stacked bars next to each other for every category?
Make two rows per category, one for each group, and put the stack components in separate value columns. Select both label columns and the values, then insert a 2-D Stacked Bar or Stacked Column chart.

What is the difference between Stacked Bar and 100% Stacked Bar?
Stacked Bar preserves the values and makes the combined total visible. 100% Stacked Bar scales each complete bar to the same length to compare component shares, so it does not show differences in total size through bar length.

Why are my bars not stacking?
Check that you selected a Stacked chart rather than a Clustered chart. Also inspect the row and column orientation; Chart Design > Switch Row/Column can correct a layout that Excel interpreted in the wrong direction.

Can I add totals to a stacked bar chart?
Yes, but do not include the total as another stacked component, because that double-counts the parts. Use data labels or a separate total display, and make clear how the totals relate to the component values.

Make the comparison easy to interpret

A useful double-stacked bar chart starts with tidy data: one row per bar, one label for the broader category, one label for the group, and one numeric column per segment. Choose ordinary stacking when totals matter, 100% stacking when proportions matter, and a different chart when individual segment comparisons are the priority. After inserting the chart, verify the grouping, series order, labels, and scale so the visual tells the same story as the worksheet.

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.