Excel Stacked Bar Chart Combo: Build and Format It

Yes, Excel can combine chart types, but a horizontal stacked bar chart paired with a line or another chart type is not a dependable, one-click combo in Microsoft 365 for Windows. Excel’s reliable built-in approach is to combine a stacked column chart with a line; if you specifically need horizontal stacked bars, check the chart-type choices available for your data or use a separate-chart alternative.

What “stacked bar chart combo” can mean

The phrase can describe two different things. A stacked bar chart already combines several data series: Excel draws their values as adjacent segments within one horizontal bar for each category. For example, a bar for each product could be divided into sales from three regions. That is a stacked chart, but it is not technically a combo chart.

A combo chart, in Excel terminology, places different chart types together in one chart area. A familiar example is columns for monthly sales and a line for a target. A request for a “stacked bar chart combo” often means a stacked bar with a line, markers, or another series displayed differently. The distinction matters because Excel’s combo-chart interface does not offer every possible pairing of chart types.

Also watch the terminology: in Excel, a bar chart has horizontal bars, while a column chart has vertical columns. Stacked bar and stacked column charts use similar data, but their orientation changes which combinations Excel can create conveniently.

What Excel supports reliably

In Excel for Microsoft 365 on Windows, the built-in combo-chart feature is designed for supported combinations of chart types, especially column, line, and area charts. A stacked column chart with a line is a common, practical combination. The line can show a target, rate, or other measure while the columns show components of a total.

A horizontal stacked bar combined with a line is less straightforward. Depending on the chart and the available chart-type choices, Excel may not offer a suitable bar-and-line combination in the custom combo dialog. Do not assume that every chart type can be paired with every other type just because Excel has a Combo category. If the needed type is absent from the list, the interface does not support that combination for the selected chart.

When the horizontal orientation is essential, a stacked bar by itself may communicate the comparison more clearly than a forced combo. If the second measure is essential too, consider a separate aligned chart, a data table beside the bars, or a stacked column-and-line chart if changing orientation would still serve the reader.

Prepare the data before inserting a chart

Arrange the source as a rectangular table: one category column followed by one column for each stacked component and any additional measure. Use one header row, consistent category labels, and numeric values. Avoid blank rows or merged cells inside the range, since they can make Excel interpret the data in unexpected ways.

For example, a monthly report could use columns for Month, Online, Store, Wholesale, and Target. Online, Store, and Wholesale are the segments that add up to the stacked total. Target is the separate measure you might show as a line in a stacked-column combo chart. Give the target values in the same units as the stacked total if you want direct visual comparison; if they use different units, the chart may need a secondary axis.

Keep the stacked components in neighboring columns and make their meaning clear in the headers.
Use the same unit and scale for components that contribute to a total.
Do not include a grand-total column as another stacked component. Doing so stacks the total on top of its own parts and exaggerates the result.
Include a separate target or rate series only when it answers a distinct question.

For a stacked chart, Excel adds the component series together visually. In an ordinary stacked chart, the bar’s overall length represents the sum of those component values. A 100% stacked chart instead scales each category to 100%, making proportions easy to compare but hiding differences in total size.

Create the reliable stacked-column-and-line combo

If a vertical chart is acceptable, this is the most dependable native combo for showing stacked contributions alongside a separate measure:

Select the complete data table, including its headers.
On the ribbon, choose Insert > Insert Combo Chart > Create Custom Combo Chart. Depending on the ribbon layout, the Combo chart button is in the Charts group.
In the dialog, choose a stacked column type for each component series. Set the separate measure, such as Target, to Line.
If the line uses a substantially different unit or scale, select its Secondary Axis option. Use that option only when a second scale will make the chart easier to interpret.
Select OK, then add a useful chart title and axis titles from Chart Design > Add Chart Element.

Check the result rather than assuming Excel assigned every column the intended role. If the categories and series are reversed, select the chart and choose Chart Design > Switch Row/Column. You can also right-click an individual series, choose Change Series Chart Type, and adjust that series if the command is available.

The exact chart-type list can vary with the chart and Excel build. If you cannot choose a horizontal Bar type for one series in the combo dialog, switching to a stacked column plus line is the practical built-in solution—not a sign that the data table is necessarily wrong.

When to use a secondary axis

A secondary axis gives one series its own value scale, usually displayed on the right side of the chart. It can help when, for example, stacked columns show sales in thousands while a line shows a percentage. Without a separate scale, the percentage may appear almost flat or the columns may become hard to read.

However, a secondary axis can also make a chart misleading. Readers may compare the line’s height with the columns even though the two vertical scales have different units and ranges. Label both axes with units, keep the scales visible, and explain what the line measures. If the line and stacks use the same unit, try one axis first; separate scales are not automatically better.

For a stacked chart, the columns or bars show accumulated component values. A line plotted against a secondary scale does not become part of that stack. It is a separate measure drawn over the same category positions. A clear legend and an explicit axis title help readers distinguish the two.

Horizontal stacked bars: practical alternatives

Horizontal bars are often preferable when category names are long or when readers need to compare many categories. If the combo dialog does not offer the horizontal bar-and-line pairing you need, choose an alternative based on the question the chart should answer:

Use a stacked bar alone when the main purpose is to compare category totals and their component makeup. Put the second measure in a nearby table or label.
Use a stacked column and line when showing the second measure in the same chart is more important than keeping horizontal bars.
Place two charts together when both the horizontal stack and the extra measure matter. Use the same category order and align the chart areas so readers can compare categories across them.
Use a 100% stacked bar when the central question is about each component’s share, not the total. Keep actual totals available elsewhere if size differences matter.

Overlaying separate charts to imitate an unsupported combo is possible in some situations, but it is fragile. Resizing, changing category counts, or editing axes can break the alignment. It is usually a poor choice for a chart that will be refreshed or maintained by other people.

Format the chart so the comparison is clear

Choose a small, consistent set of colors for the stacked components and use a contrasting line color with a visible marker if the chart is dense. Keep the legend order aligned with the stack order where possible. If one series is the focus, emphasize it without making the other segments indistinguishable.

Use a descriptive title such as “Monthly sales by channel and target” rather than “Chart 1.” Name the axes and include units, such as “Sales (thousands of dollars)” and “Target.” If the chart has a secondary axis, label it plainly and make the line’s meaning clear in the legend or a note.

For many categories, horizontal bars can be easier to read than columns, but a long legend can still crowd the plot. Consider sorting categories by total when that supports the comparison, shortening labels, or splitting the chart into meaningful groups. Avoid adding data labels to every segment if they overlap; label only the values readers need, or use a companion table for exact figures.

Common problems and fixes

The chart is clustered instead of stacked: Select the chart, then use Chart Design > Change Chart Type and choose the stacked variant for the relevant series.
The wrong data appears in the legend: Check that the header row and category column were included. Use Chart Design > Select Data to review the data range and series names.
Excel treats categories as series, or vice versa: Try Chart Design > Switch Row/Column, then verify the legend and category axis.
The line is nearly flat: Check whether it has a different unit or much smaller values than the stacked totals. A secondary axis may help, but label it clearly.
The total looks too large: Make sure a total column has not been included as another component in the stack.
The desired chart type is unavailable: Excel does not support every pairing through the combo interface. Use a supported stacked-column combo or select one of the alternatives above.

When the source data changes, a chart based on a properly structured Excel table can expand to include added rows more conveniently than a chart based on a fixed range. To make a range a table, select it and choose Insert > Table; confirm whether the table has headers. Check the chart after adding data, especially if new series or categories were introduced.

Frequently Asked Questions

Can I combine a stacked bar chart and a line chart in Excel?
Sometimes the chart-type choices available for a particular chart include the combination you want, but Excel does not provide a reliable universal stacked-horizontal-bar-plus-line preset. If Bar is not offered for the series in the custom combo dialog, use a stacked column-and-line chart or a separate aligned chart instead.

What is the difference between a stacked bar and a stacked column chart?
Both show component values stacked within each category. A bar chart displays the categories along the vertical axis with horizontal bars; a column chart displays vertical columns. Excel’s built-in combo options work more reliably with stacked columns and lines.

How do I add a target line to a stacked chart?
For a supported combination, include the target as its own data series, create a custom combo chart, set the component series to stacked columns, and set the target series to Line. Add a secondary axis only if the target uses a different scale, and label that axis.

Should I use a secondary axis for the line?
Use one when the line’s units or value range make it unreadable on the main scale. Label both scales and explain the line’s unit. If both measures share a scale, a single axis is usually easier to interpret.

Is a 100% stacked bar the same as a regular stacked bar?
No. A regular stacked bar preserves the component values and total lengths. A 100% stacked bar scales every category to 100%, so it emphasizes proportions and makes total-size differences unavailable in the plotted bar lengths.

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.