Excel Combo Chart: Stacked Bar and Line

In Excel for Microsoft 365 on Windows, you can combine stacked columns and a line by selecting your data, choosing Insert > Insert Combo Chart > Create Custom Combo Chart, and assigning the column series to Stacked Column and the metric series to Line. If by “stacked bar” you mean horizontal bars, note that Excel’s built-in combo chart uses stacked columns for this combination; a true horizontal stacked bar with an overlaid line needs a different approach.

What a stacked column and line combo chart shows

A stacked column chart divides each column into colored segments, so readers can see both the total for a category and how its parts contribute. A line series adds a second kind of information, often a rate, target, or measurement that changes across the same categories. For example, monthly columns might show sales from three product groups, while a line shows the monthly customer satisfaction score.

This pairing is useful when the series are related by category but differ in meaning or scale. The stacked columns answer questions such as “How much did each group contribute?” The line can reveal a trend that is harder to see in the segments alone. A combo chart does not automatically make unrelated data meaningful, though: the category positions and the relationship between the measures should make sense to the reader.

Prepare the data before inserting the chart

Put category labels in the first column and give each data series its own column header. Keep the values for each category on one row. A small example could have Month, Online sales, Store sales, Wholesale sales, and Return rate as its five headers. The first three measures become the stacked column segments, while Return rate becomes the line.

Use consistent categories and make sure values are numeric. Avoid blank rows inside the data range, merged cells, and totals mixed into the category list. If you include a grand total as another plotted series, Excel may stack it on top of the component values and make the chart misleading. Keep totals outside the plotted range unless you have a specific reason to show them.

Use short, recognizable category labels; long labels can crowd the horizontal axis.
Use clear series names in the header row so the legend explains the chart without guesswork.
Check that every series has a value for each category, or decide how blanks should appear before charting.
Keep units in mind. Sales dollars and a percentage are different measures, even when both are recorded by month.

Create the combo chart in Excel for Windows

For a standard worksheet range, follow these steps in Excel for Microsoft 365 on Windows:

Select the category labels and all the series headers and values, including the series intended to become the line.
Choose Insert > Insert Combo Chart > Create Custom Combo Chart. If the Combo Chart button is not visible in your ribbon layout, use Insert > Recommended Charts, then open the All Charts tab and choose Combo.
In the combo chart dialog, set each component series to Stacked Column. Set the series you want to display as a line to Line. If the line’s values use a substantially different scale, select Secondary Axis for that series.
Check the category axis and series assignments in the preview. Choose OK to insert the chart.
Add a chart title and axis titles where they will clarify the measures and units.

Excel may guess the intended arrangement when you first use Insert > Insert Combo Chart. Review every series in the dialog rather than accepting the guess: a series can end up as a column when it should be the line, or the wrong series can be put on a secondary axis. If the chart already exists, select it and use Chart Design > Change Chart Type to reopen the chart-type choices.

Choose whether the line needs a secondary axis

A secondary vertical axis is often needed when the line and stacked columns have different units or very different value ranges. For instance, sales might be in thousands of dollars while return rate runs from 0% to 10%. Plotting both on one vertical scale can flatten the percentage line near the bottom or make the columns hard to interpret. In the custom combo dialog, enable Secondary Axis for the line series; Excel then displays a second vertical scale on the right.

A second axis solves a scale problem, but it can also make visual comparisons look more dramatic or more modest depending on the chosen bounds. Label both axes with their units, use a clear legend, and avoid implying that a one-unit movement on one axis equals a one-unit movement on the other. If the units and ranges are already comparable, keep the series on one axis when that produces a legible chart.

Format the chart so the data stays readable

After inserting the chart, select a chart element to format it. Chart Design provides chart-type, layout, and style controls; the Format tab offers controls for the selected element. Use a restrained color scheme: give each stacked component a distinct but related color, and make the line visually distinct with a contrasting color and, if helpful, markers.

Check the column spacing and line visibility. If there are many categories, a thick line or large markers can obscure the columns. If there are only a few categories, markers can make individual readings easier to identify. Data labels can help with a small chart, but labeling every segment, total, and line point often creates clutter. Consider labeling only the key series or adding a data table if exact values matter more than a compact visual.

Use descriptive axis titles such as Revenue (thousands of dollars) and Return rate (percent), not merely Left axis and Right axis. Set number formats that match the units: percentages should look like percentages, and currency or large values should be formatted consistently. A clear legend should identify both the stacked components and the line. If the legend labels are vague, improve the source column headers rather than relying on colors alone.

Worked example: monthly sales and return rate

Imagine a table with one row per month and three sales channels: Online, Store, and Wholesale. The stacked column shows the combined monthly sales, with one segment for each channel. A Return rate series becomes a line, plotted against the secondary axis because it is a percentage rather than a sales amount. The chart can then show whether sales composition changes in the same months that returns rise or fall.

Before drawing a conclusion, check that the return rate is defined consistently for every month. A rate based on orders may not be comparable to one based on units sold. Also check whether months have equal coverage; a partial current month can make both the total and the rate misleading. A combo chart displays the values provided, but it cannot correct inconsistent definitions or incomplete data.

Stacked bar versus stacked column: an important distinction

In Excel terminology, columns are vertical and bars are horizontal. The built-in combo chart workflow is designed to pair chart types such as columns and lines. So when readers ask for a “stacked bar and line,” they may mean a stacked column chart with a line, which is the straightforward option described above, or they may specifically need horizontal bars.

If horizontal stacked bars are essential, Excel does not offer the same simple built-in stacked-bar-plus-line combo selection. You can use a stacked bar chart and show the other measure in a separate aligned chart, or create a more involved custom construction using an XY scatter series and carefully matched axes. The latter requires more setup and can break when the chart is resized or categories change. For most reports, stacked columns with a line are easier to maintain; for long category names, a separate horizontal bar chart may be more readable.

Common problems and how to fix them

The line is nearly flat. Its values may be tiny compared with the column values. Edit the combo settings and put the line on a secondary axis, then label that axis clearly.
The wrong series appears as the line. Open Chart Design > Change Chart Type and assign the correct series individually in the combo settings.
The columns are not stacked. The series may be set to Clustered Column. Change each component series to Stacked Column.
Categories appear in the wrong order. Check the source row order and the category-axis settings. Excel may also interpret dates as a date axis; use a text category axis if equally spaced category labels are intended.
The line does not line up with the columns. Confirm that the line and columns use the same category labels and that the data ranges include the same rows.
The chart looks crowded. Reduce the number of categories, remove unnecessary labels, or split the information into two charts rather than shrinking text until it becomes unreadable.

Excel on Mac and Excel for the web

Excel for Mac also supports combo charts, although ribbon placement and dialog appearance can differ by release. Select the data and look for the Combo chart option on the Insert tab. If it is not shown in the initial chart gallery, open the chart insertion or chart-type dialog and choose Combo, then assign Stacked Column and Line to the relevant series. The key settings are the same: chart type per series and, when needed, a secondary axis.

Excel for the web has a more limited chart-editing interface than the Windows desktop app, and available options can vary. If you cannot find a custom combo setting or cannot change one series independently, open the workbook in the desktop app to create or adjust the chart. The chart can then be saved in the workbook and viewed online, though some detailed formatting controls may remain desktop-only.

Frequently Asked Questions

Can Excel combine a stacked column chart and a line chart?
Yes. Use a custom combo chart, set the component series to Stacked Column, and set the separate measure to Line. Use a secondary axis when its scale or unit makes a shared axis hard to read.

How do I add a line to an existing stacked column chart?
Select the chart and choose Chart Design > Change Chart Type. In the Combo options, change the intended series to Line, keep the contributing series as Stacked Column, and select Secondary Axis for the line if appropriate.

Can I make a horizontal stacked bar and line combo chart?
Not as a simple built-in combo chart in Excel. The standard workflow supports stacked columns with a line. For horizontal bars, use a separate aligned chart or a more complex custom construction, and test it after editing the data or resizing the chart.

Should the line always use a secondary axis?
No. Use one only when the units or value ranges make the line unreadable on the column axis. A secondary scale can help visibility, but label it clearly because the two axes do not share the same units.

Why is the line missing from my combo chart?
It may be assigned the wrong chart type, use blank or nonnumeric source values, or be plotted on a scale that makes it difficult to see. Recheck the series assignment, source range, and axis bounds in the chart settings.

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.