To make a side-by-side stacked column chart in Excel for Microsoft 365 on Windows, arrange each main category and subgroup in separate label columns, put the stack components in adjacent value columns, then select the table and choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Excel does not offer a chart type named “clustered stacked column”; the multi-level category axis places each subgroup’s stacked column beside the others within its main category.
What a Side-by-Side Stacked Column Chart Shows
A stacked column divides each column into colored segments, with every segment representing one component of a total. A side-by-side stacked chart places several of these columns next to one another for each larger category. It is useful when you want to compare both the makeup of a total and the totals across subgroups—for example, planned and actual sales by region, with each column split into product lines.
The chart is different from an ordinary clustered column chart. A clustered chart puts individual series next to one another, while a stacked chart builds each column upward from its components. Excel’s standard chart gallery includes stacked and clustered column options, but not a single built-in option that combines clustering and stacking. The table structure and category axis provide the practical workaround.
Prepare the Data in a Two-Level Layout
Use one row for each complete stack. Put the main category in the first column, the subgroup in the second, and the values for the stack components in the columns to the right. For instance, this table compares Plan and Actual within each region, with three product lines making up each stack:
| Region | Scenario | Hardware | Software | Services |
|---|---|---|---|---|
| North | Plan | 12 | 8 | 5 |
| North | Actual | 10 | 9 | 7 |
| South | Plan | 9 | 6 | 4 |
| South | Actual | 11 | 7 | 6 |
Each row becomes one column: North Plan, North Actual, South Plan, and South Actual. The component columns become the colored segments. Keep the rows for each main category together so the corresponding stacks appear together on the chart. Use clear, consistent subgroup labels; if one region has Plan and Actual but another has Budget and Actual, the comparison may be harder to interpret.
Include headers, avoid merged cells, and keep numeric values as numbers rather than text. A zero means the component is known to contribute nothing; a blank means no value has been provided. Decide which meaning applies before charting, because blanks and zeros can be interpreted differently and can mislead readers if used interchangeably.
Create the Chart in Excel for Windows
- Click inside the data table or select the full range, including both label columns, the component headers, and all values.
- Go to Insert > Insert Column or Bar Chart > 2-D Stacked Column. Avoid the 100% Stacked Column option unless you want every column normalized to the same height.
- Check that the horizontal axis shows both levels of labels and that each component is a separate colored series. Excel usually recognizes the two leftmost columns as multi-level category labels.
- If Excel has interpreted rows and columns incorrectly, select the chart and choose Chart Design > Switch Row/Column. Use the view that makes the component names the legend entries and each category-subgroup combination a column.
- Add a descriptive chart title, then adjust the legend, colors, and labels to make the comparison easy to read.
Excel for Mac has a similar chart-insertion workflow: select the data, use the Insert tab’s column chart controls, and choose the stacked column type. Ribbon wording and arrangement can differ slightly by platform and update. In Excel for the web, chart creation and basic formatting are available, but some detailed formatting controls may be more limited than in the desktop app.
How the Multi-Level Category Axis Works
The first label column identifies the parent group—in the example, the region—and the second identifies the subgroup, or scenario. Excel uses these adjacent label fields to display a hierarchical horizontal axis. The region label appears once for its adjacent Plan and Actual columns, visually grouping those stacks without changing the chart into a different chart type.
If the axis shows only one label level, first check that the selected range includes both label columns and that they are immediately to the left of the values. You can also right-click the horizontal axis, choose Format Axis, and look in the Labels settings for Multi-level Category Labels. The exact available controls can vary with the chart and Excel build. If labels remain crowded, widen the chart or shorten the subgroup names rather than shrinking them until they are unreadable.
There is no need to add empty rows between parent groups in the source table. Extra blank rows can create unwanted empty categories or gaps. If you need a more pronounced visual break between groups, first try formatting the axis labels and adjusting the chart’s gap width; use blank spacer data only after checking how Excel plots it in your version.
Choose Stacked or 100% Stacked
A regular stacked column preserves the values and total height of each stack. In the sample data, North Plan totals 25 (12 + 8 + 5), while North Actual totals 26 (10 + 9 + 7). The chart lets readers compare both the size of each total and the contribution of each component. It is a good choice when absolute amounts matter and the component values share a meaningful unit.
A 100% Stacked Column chart scales every column to 100%. It emphasizes the percentage mix of components, making it easier to compare composition when totals vary substantially. But it hides the difference in total size: a small total and a large total both reach the same height. If readers need both scale and composition, consider showing totals in labels or pairing the composition chart with a separate chart of totals.
Stacking works best when the components are parts of a meaningful whole, use the same units, and are nonnegative. Negative values can extend below the axis and complicate interpretation. For data with many components or many subgroups, stacked columns may become visually crowded; a simpler chart can communicate the main comparison more clearly.
Format the Chart for Clear Comparisons
Choose colors that distinguish components consistently across every stack. Keep the same component in the same color throughout, and order the series thoughtfully. The series order determines the stacking order, which affects how easy it is to follow segments across columns. To change it, select the chart and use Chart Design > Select Data; in the Legend Entries (Series) list, move series up or down.
Use a vertical value axis with units and a sensible scale. If all values are nonnegative, starting at zero preserves a fair visual comparison of total heights. Avoid unnecessary gridlines and decorative effects. A concise title should state what is being measured and, where relevant, the period or unit.
Data labels can help when there are only a few stacks and segments. Select the chart, then use Chart Design > Add Chart Element > Data Labels to choose a position. Segment labels show component values; they do not automatically provide a clean total label at the top of every stack. If totals are essential, add them carefully as a separate labeling technique or provide the totals in a nearby table. Too many labels can overlap, so test readability at the size at which the chart will be viewed.
Common Problems and Practical Fixes
- All values appear as separate columns. The chart may be clustered rather than stacked, or Excel may have read the table orientation incorrectly. Choose Chart Design > Change Chart Type > 2-D Stacked Column, then check whether the component names are the series.
- The subgroup labels or parent labels are missing. Recreate or edit the chart’s source range so it includes both label columns. In Chart Design > Select Data, inspect the chart data range and horizontal axis labels.
- The columns are in the wrong order. Sort the source rows into the desired parent-group and subgroup order. To rearrange the colored segments, change the series order through Select Data rather than sorting the category rows.
- Some columns are much taller than expected. Check for values stored as numbers in an unexpected scale, accidental duplicate rows, or a wrong chart orientation. Remember that a regular stacked chart adds the component values in each row.
- The chart is hard to read. Reduce the number of components, shorten labels, enlarge the chart, or switch to a different chart form. A chart with many narrow columns and many colored segments is difficult to compare even when the data is correct.
When Another Chart Type Is a Better Fit
Use a regular clustered column chart when comparing individual series values is more important than showing a total made of parts. Use a stacked chart when both component contribution and overall total matter. Use a 100% stacked chart when the proportions are the focus and the absolute totals are secondary. These choices are not just visual styles: they change which comparisons are easiest to make.
If there are only two subgroups and precise comparisons of each component matter, clustered columns may be easier because every component starts from the same baseline. In a stacked column, only the bottom segment shares that baseline; judging the size of upper segments across stacks is less direct. A line chart may suit time trends, while a small table alongside the chart can preserve exact values that are difficult to read from bars.
Frequently Asked Questions
Does Excel have a built-in side-by-side stacked column chart?
No. Excel provides stacked and clustered column chart types, but not a standard chart type that directly combines both. A stacked column chart with two category-label columns is the straightforward way to place subgroup stacks side by side within parent categories.
Why are my stacked columns not grouped by category?
Check that the parent category and subgroup labels are in separate adjacent columns and that both columns are included in the chart’s source range. Keep each parent group’s rows together. If Excel shows the wrong orientation, use Chart Design > Switch Row/Column.
Can I show totals above each stacked column?
Excel’s usual data-label options label the individual series segments, not necessarily the complete stack total. You can calculate totals in an additional worksheet column and use a more advanced label setup, or list the totals beside the chart. Make sure the extra labels do not obscure the segment values.
Should I use stacked or 100% stacked columns?
Use stacked columns when the actual totals and component values matter. Choose 100% stacked columns when the proportions are the focus and you are willing to give up visual comparison of total sizes.
Can I use this approach for more than two subgroups?
Yes. Add a row for every parent-category and subgroup combination, keeping the component values in the same columns. The chart can display more than two stacks per parent group, but readability declines as the number of columns and categories grows.
Related
- Randomize Names in Excel Without Repeats: Easy Methods
- Randomize Groups in Excel: A Practical Guide
- Randomize in Excel Without Repeating Numbers: 3 Ways
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Power Pivot Hierarchy: Create and Use One in ExcelA Power Pivot hierarchy is an ordered set of related columns from one table in Excel’s Data Model,…
- Excel Pivot Table Mode: Find the Most Common ValueTo find a mode with an Excel PivotTable, put the field you want to analyze in both Rows…
- Tree Chart in Excel: Create and Format a TreemapIn Excel, a “tree chart” usually means a Treemap: a chart that displays hierarchical categories as nested rectangles…
- Google Sheets Distribution Charts: Types and SetupA Google Sheets distribution chart is usually a histogram: it groups numerical values into ranges, or bins, and…
- Create an Excel Dashboard With AI: A Practical GuideYes. To create an Excel dashboard with AI, prepare clean, column-based data, ask Microsoft Copilot or another AI…
- Excel Clustered Column Chart With a Line: How to Make OneTo make a clustered column chart with a line in Excel for Microsoft 365 on Windows, select your…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.