Excel does not have a chart type called a double stacked column chart, but you can create the common version—a pair of stacked columns for each category—by arranging the data in a helper table and inserting a 2-D Stacked Column chart. Use one label column for the main category, another for the pair name, and one value column for each segment in the stacks.
What people mean by a double stacked column chart
The phrase is informal, so it can describe more than one visual. Most often, a reader wants two stacked columns side by side within each main category. For example, each region might have one stack for Plan and another for Actual, with each stack divided into product groups. In Excel chart terminology, this is a clustered stacked column chart: the columns are clustered as pairs, and each individual column is stacked.
Excel for Microsoft 365 on Windows offers Stacked Column and 100% Stacked Column chart types, but not a built-in chart type that combines clustering and stacking automatically. A helper table lets you represent the two columns as separate category entries while keeping their components as stacked series. Excel then places the entries next to each other on the category axis.
Sometimes “double stacked” means two layers of information, or a column with a second scale. Those are different chart design problems. The method below is for side-by-side stacks under each category; it does not create two independent vertical axes or a stack within a stack.
Arrange the source data for paired stacks
Set up the data with two adjacent category-label columns, followed by one column for every component that should form a segment. For instance, a regional sales comparison could use this layout:
| Region | Scenario | Hardware | Software |
|---|---|---|---|
| North | Plan | 42 | 28 |
| North | Actual | 48 | 25 |
| South | Plan | 35 | 30 |
| South | Actual | 32 | 37 |
Each row represents one complete stack. Hardware and Software are the stacked series; Plan and Actual are the paired entries within each region. The first two columns provide a two-level category axis, with Region as the outer label and Scenario as the inner label. Keep the rows in the order you want the groups to appear.
This layout scales to more than two stacks per category. Add a scenario row for each stack, such as Prior Year, Plan, Forecast, and Actual. Add another value column for each component that belongs in every stack. If a component is not relevant to one scenario, use a blank or a genuine zero only when that accurately represents the data. A zero communicates a measured value of zero; a blank can imply that no value is available.
Create the stacked column chart in Excel
In Excel for Microsoft 365 on Windows, select the entire table, including both label columns, the series headers, and the values. Then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Excel should use Region and Scenario as category labels and create a colored segment for each value series.
- Check that every row is a stack and every component has its own value column.
- Select the complete rectangular range, including the Region and Scenario labels.
- Choose Insert > Insert Column or Bar Chart > 2-D Stacked Column.
- Confirm that each Region has adjacent Plan and Actual columns, and that Hardware and Software segments appear within each column.
- If Excel has interpreted rows and columns the wrong way, select the chart and choose Chart Design > Switch Row/Column.
The exact gallery appearance can vary with the Excel window size, but the chart type is named Stacked Column, not Clustered Column. Clustered Column places series side by side; choosing it would separate Hardware and Software rather than stack them. On Excel for Mac, select the data, use the Insert tab’s chart controls, and choose a Stacked Column chart; the gallery layout and wording can differ by Mac release.
Format the grouping and make the chart readable
Excel generally recognizes multiple adjacent label columns as a multi-level category axis when they are included in the selected range. The outer Region labels should group the Plan and Actual labels beneath them. If the chart instead shows an unexpected axis or the wrong number of series, check the selected range first, then use Chart Design > Select Data to review the chart data range, series, and horizontal axis labels.
Useful formatting choices include:
- Keep series colors consistent. Hardware should have the same color in every stack, as should Software. That makes the legend meaningful across regions.
- Use a descriptive title. A title such as “Regional sales: plan and actual” tells readers what the pairs represent.
- Choose a sensible gap width. Right-click a column, select Format Data Series, and adjust Gap Width. A smaller gap makes the columns wider; a larger gap separates them more. A standard chart does not offer independent gap settings for the two columns within each pair and the gap between region groups.
- Keep labels selective. Data labels on every segment can become crowded. Add labels when the exact amounts matter, or leave values on the vertical axis and use the legend to identify components.
- Use an appropriate axis scale. A zero baseline matters for column comparisons. Avoid truncating the vertical axis in a way that exaggerates differences in total height.
For a presentation, consider whether readers need the segment values, the total for each stack, or both. Excel’s standard data labels can show series values, but displaying totals above stacks may require a separate total series or manual labels. Any added total series needs careful formatting so it does not visually change the stacked amounts.
Understand what the chart does and does not compare
A stacked column’s full height represents the sum of its segments. In the example, the North Plan total is 70 (42 + 28), while North Actual is 73 (48 + 25). The column heights make that total comparison visible, and the colored segments show how each product group contributes.
Stacking is less effective when the main question is how one component changes across many categories. Only the bottom series shares a common zero baseline; the starting position of upper segments depends on the segments below. Comparing Hardware is straightforward if it is always the bottom series, but comparing Software heights across regions is harder. If component-by-component comparisons are the priority, use a clustered column chart instead, or create separate charts for the components.
A 100% Stacked Column chart answers a different question. It normalizes every stack to 100%, emphasizing the proportion contributed by each component while hiding differences in total size. Choose it only when composition is the focus and totals are not the main comparison. It would make the North Plan and Actual columns the same height even though their totals are 70 and 73.
Common problems and practical fixes
- The chart shows one stack per region, not two. The Scenario labels may be missing from the selected range, or the chart range may omit that column. Include both category columns and check Chart Design > Select Data.
- Hardware and Software appear side by side. Excel likely inserted a Clustered Column chart. Change the type through Chart Design > Change Chart Type and choose Stacked Column.
- Excel treats a label as a data series. Check that the header row and data columns are arranged consistently and that the selected range starts and ends in the intended cells. Chart Design > Switch Row/Column can correct a reversed interpretation, but it cannot repair a malformed source table.
- There are gaps or unexpected short stacks. Look for blank cells, text in numeric columns, or zeros that were entered to stand for missing data. Use blanks for unavailable measurements and zeros for real zero values, then check how the chart displays the missing entries.
- The category labels look repetitive. Repeated Region names are useful in the source table because they keep each row explicit. Excel can group repeated outer labels on a multi-level axis; if the visual grouping is unclear, widen the chart or simplify the labels.
- The order of series is inconvenient. In Chart Design > Select Data, review the series list and move series to change the stacking order. The order also affects which series appears nearest the baseline.
For data that changes regularly, convert the source range to an Excel table with Insert > Table before creating the chart. Tables make the source easier to extend and can help a chart include newly added rows, although you should verify the chart after changing the table structure. Avoid inserting decorative blank rows between regions in the source; they can create empty categories and make the chart harder to maintain.
When to use a different approach
The helper-table method is usually the clearest option when every category has the same set of paired stacks and component series. It keeps the data in a recognizable tabular form and uses Excel’s ordinary stacked-column chart behavior rather than relying on elaborate chart tricks.
Choose a clustered column chart when the key task is comparing individual series values directly—for example, comparing Hardware Plan with Hardware Actual across regions. Choose a 100% stacked chart when the relative mix matters more than totals. A small-multiple layout, with one simple chart per scenario, may be easier to read when there are many scenarios or many segments. If you need distinctly different spacing between pairs and between groups, or highly customized labels, a more advanced chart construction may be needed; the standard stacked-column options do not control those gaps separately.
Do not confuse this chart with a secondary-axis combination chart. A second vertical axis is sometimes used to plot a different kind of measure, such as sales alongside a rate. That requires a deliberate scale and can mislead if readers assume both measures share units. It is not necessary for a pair of stacks, where all segment values should normally use the same unit and scale.
Frequently Asked Questions
Does Excel have a double stacked column chart type?
No. Excel for Microsoft 365 has stacked and 100% stacked column chart types, but not a built-in clustered stacked option. A helper table with two category-label columns creates the common side-by-side stacked layout.
How do I put two stacked columns next to each other for every category?
Give each desired stack its own row, repeat the main category in the first label column, and put the pair name in the second. Add one value column per stack component, select the whole table, and insert a 2-D Stacked Column chart.
Can I make three or more stacked columns in each group?
Yes. Add a row for each scenario or comparison member under every main category. The chart will place those entries next to one another, though a large number of columns can make each one too narrow to read.
Why are my series clustered instead of stacked?
The selected chart type is probably Clustered Column. Use Chart Design > Change Chart Type and select Stacked Column. Also confirm that the component names are separate series headers, not category labels.
Should I use stacked or 100% stacked columns?
Use Stacked Column when total amounts and component amounts both matter. Use 100% Stacked Column when you want to compare each component’s share of a total and do not need to compare the totals themselves.
Can I control the gap inside a pair separately from the gap between groups?
Not with the ordinary Gap Width control on a standard stacked-column chart. That setting applies across adjacent category columns. If separate spacing is essential, consider another layout or a more customized chart design.
Related
- Count Numbers vs Count in Excel PivotTables
- Copy Paste in Excel: Keep Column Widths When Pasting
- Copy an Entire Excel Spreadsheet to a New File
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Histogram in Excel: How to Create and Customize OneYes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic…
- EBITDA Waterfall Chart in Excel: Build It Step by StepTo make an EBITDA waterfall chart in Excel, list opening EBITDA, each positive or negative driver, and closing…
- Excel Pivot Chart: How to Remove ButtonsTo remove the buttons from an Excel PivotChart in Microsoft 365 for Windows, select the chart, open the…
- Excel Chart Format Code for Millions: Examples and TipsTo show Excel chart values in millions, apply the custom number format #,##0,,"M"; for one decimal place, use…
- Excel Waterfall Chart Final Column: Set It as a TotalIn Excel for Microsoft 365, select the chart’s final data point, right-click it, and choose Set as Total.…
- Create an Org Chart in Excel from Your Employee DataYes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.