How to Build Clustered and Stacked Combo Charts in Excel

Yes. In Excel for Microsoft 365 on Windows, use Insert > Insert Combo Chart > Create Custom Combo Chart to assign stacked columns to some series and clustered columns to another. Excel can combine those chart types, but it may overlay the columns instead of placing a stacked column neatly beside a clustered one, so the final layout often needs adjustment or a different design.

What a clustered and stacked combo chart shows

A clustered-and-stacked chart aims to show two kinds of comparison in one view. Within each category, one column is divided into segments that add up to a total; another column, or group of columns, sits beside it for comparison. For example, each month could have a stacked column showing actual sales split across three regions and a separate column showing the monthly sales target.

The words describe different arrangements. A stacked column places series on top of one another, so the total height represents their sum. A clustered column places series side by side, making individual values easier to compare. A combo chart combines chart types, such as columns and a line. It does not automatically arrange a stacked column beside a clustered column just because both types are selected.

That distinction matters: Excel treats different column chart types as separate chart groups. Their columns can occupy the same category position and overlap. The chart type selection is a starting point, not a guarantee of the side-by-side layout people usually mean by “clustered and stacked.”

When this design is useful

Use this design when readers need to see both a total made from parts and a separate comparison value for the same category. A practical example is actual monthly sales split by East, Central, and West regions, compared with one monthly target. The stacked actual column communicates the regional contributions and their total; the target column provides a benchmark.

It is less suitable when the main task is comparing each component precisely. In a stack, only the bottom segment shares a consistent baseline; the other segments start at different heights. Comparing the height of, say, the Central region across several months is therefore harder than comparing it in a clustered chart. Consider a line chart or a separate clustered chart if component-by-component comparison is the priority.

Stacking also makes sense only when the segments can be added meaningfully. Regional sales, product quantities, or expense categories may be additive. A percentage, index, or overlapping measure may not be. Do not stack a total alongside the components that create it as though all were separate parts: that counts the same amount twice and misleads the reader.

Arrange the source data

Put categories in the first column and each series in its own column, with clear headers. For the sales example, a small source table might look like this:

Month	East actual	Central actual	West actual	Target
January	40	30	20	100
February	45	28	22	105
March	42	35	23	110

Here, January actual sales total 90 (40 + 30 + 20), compared with a target of 100. The target is a separate series, not a fourth region contributing to actual sales. Keeping the meaning clear in the headers helps prevent a chart that looks plausible but tells the wrong story.

Use one row per category, such as month, department, or product.
Keep all values in compatible units and on a comparable scale where possible.
Use zero for a genuine zero, and leave a cell blank only when the value is unknown or not applicable.
Check that the actual components add to the total you intend to show.

Create the custom combo chart

In Excel for Microsoft 365 on Windows, select the complete table, including its headers. Then follow these steps:

Choose Insert > Insert Combo Chart > Create Custom Combo Chart. If a chart already exists, select it and choose Chart Design > Change Chart Type > Combo.
In the custom combo chart dialog, set East actual, Central actual, and West actual to Stacked Column.
Set Target to Clustered Column.
Leave Secondary Axis unchecked if every series uses the same unit and scale. Select it only when there is a sound reason to use a separate scale, not simply to make the chart look better.
Choose OK, then inspect the result at a readable size. Check that all months appear and that the legend identifies the series correctly.

Some Excel builds show a list of chart types for each series in the custom dialog; the available choices can depend on the chart and version. If the dialog does not offer the combination you need, start with a stacked column chart, then use Chart Design > Change Chart Type to check the available options. In Excel for Mac, the chart controls are also on the Insert and Chart Design tabs, though their placement can vary with the ribbon layout. If custom chart controls are missing or hard to manage in Excel for the web, use the desktop app for this more involved layout.

Adjust overlap, spacing, and axes

If the target column sits on top of the stacked actual column, the chart has not achieved the intended comparison, even if the legend lists the right chart types. Select a column series, open Format Data Series, and look for Series Overlap and Gap Width under Series Options. The exact controls shown depend on which series or chart group is selected. Adjust them gradually and watch whether the columns become clearer; overlap settings can affect a whole group rather than just one series.

Putting a column series on a secondary axis can create another chart group, but it does not promise a tidy side-by-side result. If you use one, make the scales comparable when the values share units: select the secondary vertical axis, open Format Axis, and set its minimum and maximum to match the primary axis. Then hide the secondary labels if they add clutter and the aligned scales make that safe. If the axes have different ranges, equal-looking column heights can represent very different values, so label the axes plainly.

For a chart that must show a stacked actual column beside a target column consistently, test a few categories and inspect the chart at its final size. Depending on the Excel version and series arrangement, you may need helper series or a different construction to control spacing. Do not rely on visual alignment alone: confirm that the chart still communicates the actual total and target accurately.

Make the chart easier to read

Use a title that states the measure and period, such as “Monthly Sales: Actual by Region and Target.” Give the stacked components related but distinguishable colors, and make the target visually different. If the target is a benchmark, a line may be easier to read than a column; that changes the chart to stacked columns plus a line and avoids the side-by-side column-group problem.

Keep the legend order consistent with the bottom-to-top order of the stack where possible.
Use data labels selectively. Labeling every segment and total can crowd a small chart.
Keep the value axis starting at zero for column charts in most comparisons; a truncated baseline exaggerates apparent differences.
Use direct labels or a brief note if readers might confuse the stacked actual total with the separate target.

For the example, the January stack should total 90 while the target remains 100. If a data label or visual inspection suggests the stack totals 190, the target may have been included in the stack by mistake. That simple arithmetic check can catch a structural error before the chart is shared.

Common problems and what to try

The columns overlap. This is the most common issue because the stacked and clustered series belong to separate chart groups. Try adjusting overlap and gap width, or test a secondary-axis group with carefully matched bounds. If the columns still cannot be separated cleanly, use a line for the benchmark or create two aligned charts.
The stack total looks wrong. Check which series are assigned to the stacked group. A target, subtotal, or already-combined total should not be stacked on top of the components that make it up.
The columns have very different apparent heights. Check whether a secondary axis is active and whether its bounds differ from the primary axis. A second scale can distort visual comparison.
Excel chose the wrong category labels. Select the chart and use Chart Design > Switch Row/Column, or use Chart Design > Select Data to correct the category axis labels and series ranges.
The chart is hard to interpret. Reduce the number of categories or series, clarify the title and legend, and consider whether a simpler chart would answer the question more directly.

Alternatives when a combo chart is awkward

A stacked column plus a line is often the clearest alternative when the separate value is a target, average, or threshold. The line can cross the stacked columns without pretending to be another component, and it avoids the need to position two column groups side by side. Keep the line on the same value scale when it represents the same unit.

For precise comparisons, use two neighboring charts with the same category order and scale: one stacked chart for composition and one clustered chart for individual values. This takes more space but is often easier to read than a crowded hybrid. A 100% stacked chart is another option when the question is about proportions rather than totals; it shows each category normalized to 100%, so it no longer communicates differences in overall size.

Frequently Asked Questions

Can Excel make a stacked and clustered column chart?
Excel can assign stacked-column and clustered-column types in a custom combo chart, but the two column groups may overlap. Creating the chart type combination is not the same as getting perfectly side-by-side columns; adjust the layout or choose an alternative if positioning is essential.

How do I make a stacked column chart in Excel?
Select the category-and-series data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. For a mixed design, use the custom combo chart controls and set the relevant series types individually.

Should I put the target on a secondary axis?
Only if a separate scale is justified. For values measured in the same units, a secondary axis can make heights misleading unless its bounds match the primary axis. A line on the primary axis is often a clearer target marker.

Can I stack positive and negative values?
Excel can plot positive and negative values in stacked columns, but positive and negative portions extend in opposite directions from zero. The visual total is not a simple single-height comparison, so explain the sign convention and check that stacking fits the question.

Why does my combo chart show columns on top of each other?
Different column types are drawn in separate chart groups, and Excel may place those groups in the same category position. Try adjusting series overlap and spacing, test a carefully aligned secondary axis, or switch the comparison series to a line.

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.