Multiple Stacked Bar Chart in Excel: How to Build One

Charts & pivot tables · Updated November 20, 2026

Yes. In Excel, you can make a chart with multiple stacked bars by arranging each bar as a separate category row, then choosing Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. If you mean several side-by-side stacks within each main category, use two category-label columns so Excel groups the bars under a shared heading.

What a Multiple Stacked Bar Chart Means

The phrase can describe two related layouts. The simpler one is a stacked bar chart with many bars: each bar represents a category, and colored segments within it represent parts of that category. For example, a chart might show one bar per department, with segments for labor, materials, and other costs. Excel calls the chart type Stacked Bar; having multiple category rows produces multiple bars.

Sometimes, however, someone asking for a multiple stacked bar chart wants more than one complete stack for each main category. For example, they may want an Actual stack and a Plan stack next to each other for every department, with each stack divided into labor, materials, and other costs. Excel does not offer a separate chart type named Clustered Stacked Bar. A practical approach is to create one chart category for every stack and use multi-level category labels to show which main category the stacks belong to.

Keeping these meanings separate helps you pick the right structure. If each department needs only one stack, use a normal stacked chart. If each department needs a pair or group of stacks, use separate rows for those stacks and add a second label column.

Arrange the Source Data

Excel reads each row in the chart’s data range as a category and each numeric column as a data series. For a basic chart, put category names in the first column and the components in the columns beside them. For example:

  • Column A: Department
  • Column B: Labor
  • Column C: Materials
  • Column D: Other

Use one row per department, with numeric values for each component. A row might contain Support, 12, 8, and 4. Its stacked bar represents a total of 24 units: 12 labor, 8 materials, and 4 other. The segments should use the same series colors across all departments so readers can compare components consistently.

For side-by-side stacks within each department, add a second category-label column. A useful structure is Department, Scenario, Labor, Materials, Other. Give each row one scenario for one department—for instance, North / Actual and North / Plan. The two label columns together identify the category, while the three numeric columns make up each stack. Keep the numeric cells as numbers, not text with units typed into them; put units in a heading or axis title instead.

Use clear, nonblank headings for every data series, and avoid merged cells in the source range. Repeat the department name on each relevant row rather than leaving it blank. Repeated labels make the data easier to sort, filter, and update, and they help Excel build a dependable chart range.

Create a Basic Stacked Bar Chart

In Excel for Microsoft 365 on Windows, create the chart from a clean rectangular data range:

  1. Select the category labels, series headings, and values, including the heading row.
  2. Choose Insert > Insert Column or Bar Chart.
  3. Under 2-D Bar, select Stacked Bar. Choose 100% Stacked Bar only when you want to compare proportions rather than totals.
  4. Use the chart elements to add a useful title, axis titles where needed, and a legend that identifies the segment colors.

The horizontal axis shows the numeric scale, and the vertical axis lists the categories. Each category’s segments share a baseline end to end, so their combined length represents the row total. If Excel assigns categories and series in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. Check the legend afterward: the series names should identify the components, not the departments.

In Excel for Mac, select the same data and use the Insert tab’s chart options to choose a 2-D Stacked Bar chart; wording and gallery layout can vary slightly by release. The chart’s design and formatting controls appear when the chart is selected. Excel for the web also offers chart insertion, though some detailed formatting controls may be more limited than in the desktop app.

Show Side-by-Side Stacks for Each Category

To compare Actual and Plan as separate stacks for each department, use the five-column layout described above. Select both label columns and all the component columns, then insert a 2-D Stacked Bar chart. Excel can use the adjacent Department and Scenario columns as multi-level category labels. Each data row becomes a separate bar, while the two levels of labels communicate which department contains each scenario.

For example, the chart data could contain North / Actual with Labor 12, Materials 8, and Other 4, followed by North / Plan with 10, 9, and 3. The two bars have totals of 24 and 22, respectively. South / Actual and South / Plan would appear as two more bars. The legend remains Labor, Materials, and Other; Actual and Plan are shown in the category labels rather than as segment colors.

This distinction matters: if Actual and Plan are entered as series alongside Labor, Materials, and Other, Excel will treat all of them as parts of the same stack. That does not create two independent stacks. The separate-row layout is what makes each scenario a complete stack of its own.

Order the rows deliberately—for example, keep Actual above or beside Plan within each department—and preview the category axis. Bar charts often display the first category at the bottom, depending on axis settings. If the order reads backward, select the category axis, open Format Axis, and adjust the category order. Avoid adding extra numeric series just to create gaps; blank or spacer categories can make labels confusing and distort the chart’s reading.

Choose Stacked or 100% Stacked

A standard Stacked Bar chart preserves the actual values and total length of every bar. Use it when both the component amounts and the overall totals matter. A reader can see, for example, that one department has a larger combined workload as well as a different mix of work.

A 100% Stacked Bar chart scales every bar to the same full length. Its segments show each component’s share of that bar’s total, making composition easier to compare when categories have very different totals. But the chart no longer shows the absolute total through bar length. A department with 20 hours and one with 200 hours both occupy the same full width if their values are converted to proportions.

Choose based on the question the chart should answer:

  • Use Stacked Bar to compare totals and component amounts together.
  • Use 100% Stacked Bar to compare the proportional mix across categories.
  • Use a clustered bar chart when comparing individual components side by side is more important than showing each category’s total as a stack.

Both stacked types work best when the segments have a meaningful common order and the number of series is manageable. Many thin segments are difficult to compare, especially those that do not start at the same baseline.

Format the Chart for Clear Comparisons

Start with the reading task, then make the visual choices support it. Give the chart a title that names the measure and period, such as Department Hours by Work Type, rather than a generic title like Chart Title. If values use a unit such as dollars, hours, or units sold, make that clear in the axis title or chart context. Use a legend with concise series names and place it where it does not crowd the bars.

Use a stable color for each component across charts and periods. A familiar color mapping lets readers recognize Labor or Materials without repeatedly decoding the legend. Choose colors with enough contrast to distinguish neighboring segments, and do not rely on color alone if the chart needs to be accessible in print or for readers with color-vision differences. Direct data labels can help, but labeling every segment in a crowded chart may make it harder to read.

To change a series’ appearance, select a segment belonging to that series, right-click, and choose Format Data Series. The Format Data Series pane provides fill and series options. Gap Width controls the space between category bars: reducing it makes bars thicker, while increasing it creates more separation. The right setting depends on the number of categories and how much room the chart has; there is no single ideal value.

Consider whether a zero is a real value or a missing observation. A zero means the component was measured and had no amount; a blank may mean no data was recorded. Treating missing data as zero can create a misleading stack. Check how Excel plots blanks in your chart and set the chart’s empty-cell display appropriately if the distinction affects the message. Always compare the plotted bars with the source table after editing or refreshing data.

Common Problems and How to Fix Them

  • The bars are grouped by series instead of category: Use Chart Design > Switch Row/Column. Confirm that category names are in rows and component headings are in columns.
  • Excel treats a label as data: Check that the selected range includes the correct heading row and category-label columns, and that the values area contains numbers only.
  • The chart shows one stack per department, not Actual and Plan stacks: Put each department-scenario combination on its own row. A scenario entered as another component column will become another segment, not a separate bar.
  • The bar order looks upside down: Select the category axis and review Format Axis settings. Changing category order may also affect where the horizontal axis crosses the category axis.
  • Some bars have unexpected totals: Inspect the underlying cells for text-formatted numbers, accidental extra columns, hidden rows, or missing values. Confirm that the chart range includes only the intended components.
  • Small segments cannot be compared: Reduce the number of series, use data labels selectively, or choose a different chart type. Stacked charts make totals easy to see but do not give every segment a common starting point.

When data will grow over time, convert the source range to an Excel table with Insert > Table. A chart built from a table can generally include added table rows as the table expands. Still, verify the chart’s data range after changing its structure, especially if you add or rename component columns.

Alternatives and When to Use Them

A clustered bar chart is often clearer when the main task is comparing the same component across departments or scenarios. Its bars share a baseline, so comparing lengths is easier than comparing segments located at different positions within a stack. The trade-off is that the total for each category is not represented by one combined bar.

Small multiples—separate charts with the same scale and design—can work better when there are many components or many scenarios. They use more page space, but reduce the visual complexity of a single chart. A data table beside the chart can also provide exact values for readers who need precision that segment lengths cannot communicate.

Use a stacked chart when the relationship between the whole and its parts is important and the number of series stays readable. Use the grouped-row method for two or more stacks under each main category when the bar totals and component breakdown both matter. If the purpose is mainly ranking or precise component comparison, try a clustered bar chart instead.

Frequently Asked Questions

Can Excel make a clustered stacked bar chart directly?
Excel has Stacked Bar and Clustered Bar chart types, but not a standard chart type named Clustered Stacked Bar. To show grouped stacks, make each stack a separate data row and use multiple category-label columns to group the rows.

How do I put two stacked bars next to each other for every department?
Create one row for each department and scenario, such as North / Actual and North / Plan. Put the component values in separate columns, select the full range including both label columns, and insert a Stacked Bar chart.

What is the difference between Stacked Bar and 100% Stacked Bar?
Stacked Bar shows the actual values, so bar lengths reflect totals. 100% Stacked Bar makes every bar the same length and shows the percentage contribution of each segment, not the category’s absolute total.

Why are my series appearing as separate bars instead of stacked segments?
Excel may have interpreted the rows and columns in the opposite direction. Select the chart and use Chart Design > Switch Row/Column, then confirm that each component is a series and each intended stack is a category row.

Can I show the total above each stacked bar?
Excel does not automatically add a total label to a standard stacked bar in the same way it labels individual series. You can add labels through chart formatting or use a carefully maintained helper series, but check that the labels remain correct when the source data changes. For a simple report, a nearby table of totals may be easier to maintain.

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.