Excel Stacked Column Chart for Multiple Groups Explained

Charts & pivot tables · Updated November 19, 2026

Yes—Excel can show multiple groups in a stacked column chart by using one or more category columns for the groups and separate data series for the segments stacked inside each column. Select the data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column; the key is arranging the source data so Excel can tell categories from stack segments.

What multiple groups means in a stacked chart

The phrase multiple groups can describe two different things. A group might mean a category such as a region, month, or scenario; or it might mean one of the values that should appear as a segment inside a column. Excel treats these roles differently, so deciding which meaning you need is the first step.

In a stacked column chart, each column represents a category, and the colored sections within it represent data series. For example, a column for North in Q1 could stack Hardware and Software sales. To show several regions and quarters, use region and quarter as category fields and Hardware and Software as the series. The result is a run of stacked columns, with the axis showing which region and quarter each column belongs to.

A standard stacked chart does not automatically create independent sets of stacked columns with a separate cluster for every second dimension. Excel’s basic chart type stacks series within each category. If you want several stacks side by side under a larger category, make that second dimension another category field. This distinction helps avoid trying to use a legend series to do a category’s job.

Arrange the source data

For a chart with region and quarter as groups, set up the data in columns like this:

  • Column A: Region
  • Column B: Quarter
  • Column C: Hardware
  • Column D: Software

Each row should describe one region-quarter combination, with numeric values for each segment. For example, North, Q1, 12, 8 means Hardware contributes 12 and Software contributes 8 to that category’s total. A following row could be North, Q2, 15, 11, followed by South, Q1, 9, 13. Keep the labels in the first two columns and the values in adjacent columns, with a single header row.

This layout gives Excel two category-label fields and two data series. Avoid adding a separate total column to the selected data unless you intentionally want Total to become another stack segment. If a total is useful for reference, keep it outside the chart range or use a chart design that deliberately displays totals.

For a simpler chart with one category field, use one row per category and one numeric column per stack segment. For example, a list of regions in column A and departmental sales in columns B through D produces one stacked column per region, divided into three departments.

Create the stacked column chart

  1. Check that the category labels and numeric series have headers and that the data range has no completely empty rows or columns inside it.
  2. Select the full range, including the header row and both category columns if you are using two levels of labels.
  3. Choose Insert > Insert Column or Bar Chart > 2-D Stacked Column.
  4. Review the chart. If Excel has treated rows as series and columns as categories, select the chart and choose Chart Design > Switch Row/Column.
  5. Use Chart Design > Add Chart Element to add or adjust a chart title, axis titles, legend, or data labels as needed.

In Excel for Microsoft 365 on Windows, those commands are on the ribbon when the chart is selected. Excel for Mac has comparable chart-insertion and chart-design controls, though ribbon placement and some formatting panes can differ. Excel for the web supports creating and editing many common chart types, but some detailed formatting controls available in the desktop app may be limited.

Show nested group labels on the category axis

When the source includes two adjacent text columns before the values, Excel can use them as a multi-level category axis. In the example, the Region and Quarter columns form the category labels, while Hardware and Software form the stacks. This lets readers see the quarter labels grouped beneath their region without adding a separate legend entry for every region-quarter combination.

Excel may display a region label once across a run of quarter labels rather than repeating it at every tick. That is an axis-labeling choice, not a missing data point. Keep the group values repeated in the source rows rather than merging cells: merged cells can make the range harder to edit, sort, and reuse. If the hierarchy does not appear, select the chart, choose Chart Design > Select Data, and check that the intended category-label range includes both text columns. Depending on the chart and version, the horizontal axis label range can be edited in the Select Data Source dialog.

Multi-level labels describe the relationship between categories; they do not change the arithmetic. Each individual column still shows the series values for one row or category combination. If a region has four quarters, its four columns remain separate stacks, not one stack whose sections are the quarters.

Put several stacked columns side by side within a group

Suppose you want to compare Actual and Budget for each region, with each column divided into departments. Use three kinds of fields: Region and Scenario as category columns, then one numeric column per department. Each region-scenario row becomes its own stacked column. The axis can show Actual and Budget as neighboring categories under each region, while the department series form the colored segments inside each stack.

This is the most straightforward way to make multiple stacks appear under a shared group in an ordinary Excel chart. It is not a special clustered-stacked chart type: Excel is drawing adjacent categories on a hierarchical axis. For example, a region with Actual and Budget rows produces two neighboring stacks, each split into the same department series.

If the chart must show stronger visual gaps between regions, consider adding spacing through category layout or using a PivotChart or a carefully designed helper-data table. Test the result after sorting or filtering because spacer rows and manually arranged helper data can be fragile. Excel does not offer a single standard chart command that turns two dimensions into independently clustered stacks while preserving every possible category arrangement.

Choose between stacked and 100% stacked

Use a regular Stacked Column chart when both the total and the composition matter. A column’s full height represents the sum of its segments, so regions with higher totals appear taller. This makes it useful for comparing overall volume as well as the contribution of each series, provided the values share the same units.

Use a 100% Stacked Column chart when the main question is how each category’s total is divided proportionally. Every column is normalized to 100%, so the chart emphasizes share rather than absolute size. A small region and a large region can have columns of equal height even when their totals differ greatly. Include the actual totals in a table or labels if readers need that context.

A standard stacked chart can make it difficult to compare middle segments across categories because those segments do not share a common baseline. If comparing each department’s exact value is more important than showing the total composition, a clustered column chart or a line chart may be clearer.

Format the chart for readability

Start with the legend and category labels. Give every series a short, distinct name in the source headers; these names become legend labels. If the chart has many series, the stacks become thin and the legend becomes crowded. Combining minor categories into Other can help, as long as the grouping remains meaningful and is explained.

  • Use a clear chart title that states the measure and period, such as Quarterly sales by region and product.
  • Keep series colors consistent across charts, especially when readers compare Actual and Budget or multiple departments.
  • Use data labels selectively. Labels on every small segment can overlap; showing totals or labeling only important segments may be easier to read.
  • Check the vertical axis units and number format. Currency, percentages, and unit counts should not be mixed in one stack.
  • Adjust column spacing only after the chart structure is correct. The Gap Width setting changes the space between category columns, not the grouping logic.

To adjust the appearance, select the relevant chart element and use the Format tab or the Format pane. A stacked chart’s series are already stacked by its chart type, so changing gap width will not turn the chart into a clustered-stacked chart.

Fix common grouping problems

If there is one column per series instead of one column per category, Excel may have interpreted the data orientation differently than intended. Select the chart and try Chart Design > Switch Row/Column. If the legend contains region names when it should contain product names, check which columns are included as series and which are used for category labels through Chart Design > Select Data.

If the chart shows only one category level, confirm that both category columns were included in the selected range and that they sit next to one another before the numeric series. Check for blank headers, unexpected text in the values, or an accidentally omitted label column. When adding data later, use Chart Design > Select Data to update the chart’s range if Excel has not included the new rows automatically.

If a column is taller than expected, remember that a stacked column’s height is the sum of its series values. Check whether a total was mistakenly included as another series, which would count the component values and the total together. Also confirm that missing values and zeros are being used intentionally: a zero contributes no visible segment, while a blank may be handled differently depending on the chart and source.

Finally, do not interpret a large segment as a percentage unless the chart is normalized or the values are already percentages. In an ordinary stacked chart, the segment height represents its numeric value, and the full column represents the sum.

When another chart type is a better fit

A stacked column chart is suitable when categories are discrete and the goal is to show totals made up of components. For time trends with many dates, a stacked area chart may communicate the changing composition more smoothly, though it can make individual series harder to compare. For a small number of time periods, columns are often easier to read.

Choose a clustered column chart when the most important task is comparing individual series side by side rather than seeing their combined total. A table with conditional formatting can work better when the audience needs exact values across many groups. A PivotChart can be useful when the source is a larger structured dataset and readers need to filter or rearrange fields, but its chart still follows the same core distinction between category fields and series.

Frequently Asked Questions

Can Excel make a stacked column chart with two group fields?
Yes. Put the two group fields in adjacent text columns before the numeric series, include both columns when selecting the chart data, and use them as multi-level category labels. The numeric columns become the stack segments.

Can I stack columns and cluster them at the same time?
Excel does not provide a simple built-in clustered-stacked column chart type. A common approach is to make the clustering dimension another category field, so each group contains adjacent stacks. More elaborate layouts require helper data or a different chart design.

Why does Excel show the wrong items in the legend?
The legend lists data series, not category labels. Use Chart Design > Switch Row/Column or Chart Design > Select Data to correct the series and category ranges.

How do I show the total above each stacked column?
Excel may not automatically label stack totals as a separate value. You can add total labels using a helper series or place totals in adjacent cells and use a suitable data-label setup. Keep the helper series from changing the visible stack, and verify the result after editing the data.

Should I use stacked or 100% stacked columns?
Choose stacked columns when actual totals matter. Choose 100% stacked columns when the comparison is about each group’s proportions, and make the loss of absolute-size information clear to readers.

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.