Excel Combo and Stacked Charts: How to Combine Them

Yes. In Excel for Microsoft 365 on Windows, you can combine stacked columns with another chart type, such as a line, by creating a custom combo chart and assigning each data series its chart type. For example, stack two product sales series in columns and show a percentage measure as a line; put that line on a secondary axis only when its scale or units require it.

What combo and stacked charts mean

A combo chart displays different chart types in one chart area. A common combination is columns for amounts and a line for a rate or target. A stacked column chart, meanwhile, divides each column into segments: the segments represent component series, and their combined height represents the category total. Excel lets you use both ideas together by assigning a stacked-column type to the component series and a different type, often Line, to another series.

These terms describe different things. Combo refers to using multiple chart types; stacked refers to how column or bar series are arranged. Stacking is not itself a separate chart placed on top of another chart. The stacked series share category positions and normally share an axis, while another series can use a different chart type and, if needed, a secondary value axis.

A practical example

Suppose a monthly report tracks revenue from two product groups and the gross margin percentage. A stacked column for each month can show the contribution of both product groups to total revenue. A line can show gross margin, making it possible to compare the composition and scale of revenue with the movement in the rate.

Arrange the source data with one row per month and one column per series. Use clear, consistent units: the two revenue columns should both be in dollars, while the margin column should contain percentages. For example, a small table might have Month, Product A revenue, Product B revenue, and Gross margin as its four headers, followed by one row for each month. Excel uses the first column for category labels and the remaining columns as series.

The chart answers two related questions: how large was total revenue, and how was it divided between the two products? The line adds a third measure. It does not mean that margin is part of the revenue total; it is a separate measure shown against the same months.

Prepare the data before charting

Good source layout makes chart editing easier and reduces the chance that Excel interprets a row as a series or a column as a category. Keep the header row directly above the data, avoid blank rows and columns inside the range, and use actual numbers in the measurement columns. Format margin values as percentages rather than typing a percent sign into text. If the report includes a total revenue column, do not stack that total alongside its component revenues: doing so counts the same revenue twice visually.

Put time periods or other categories in the first column.
Give every series a descriptive header, such as Product A revenue or Gross margin.
Keep component series that should form a stack in the same unit and on the same scale.
Use a separate series for a metric that should be drawn as a line, and label its unit clearly.
Check for missing values, text-formatted numbers, and inconsistent category labels before inserting the chart.

If the data is already in a worksheet, select the complete rectangular range, including headers. If the chart exists and its data range needs changing, select the chart and use Chart Design > Select Data. The precise chart tools appear when a chart is selected.

Create a stacked-column and line combo chart

Select the data range, including its headers and category labels.
Choose Insert > Recommended Charts, then open the All Charts tab and select Combo. You can also use Insert > Insert Combo Chart in the Charts group when that command is available on the ribbon.
In the combo-chart choices, assign Stacked Column to each series that belongs in the stack. Assign Line to the rate, target, or other series you want drawn as a line.
For a line with a different unit or much smaller numeric scale, select Secondary Axis for that series. Leave it unchecked when the series can be read meaningfully on the primary axis.
Choose OK. Add or edit the chart title and axis titles so readers can identify what each axis measures.

The key decision in the custom combo settings is the chart type for each series, not just the name of the overall chart. Both product revenue series need to be set to Stacked Column for them to form one stack. Setting one to Clustered Column instead makes it a different column arrangement and can produce an unexpected display. The line series should remain Line, with markers if they help readers distinguish monthly points.

On Excel for Mac, use the Insert tab and the chart or recommended-chart options to reach the combo chart choices; the wording and dialog arrangement can differ by release. The same principle applies: set the component series to Stacked Column, set the other series to its intended type, and choose a secondary axis only when justified. These instructions target desktop Excel for Microsoft 365; chart-creation options can vary in Excel for the web.

Choose the right axis for each measure

A secondary axis is useful when a line series has different units from the stacked columns. Revenue might range from hundreds to thousands of dollars, while a percentage ranges from zero to one hundred. On a single dollar axis, a percentage line would not have a meaningful position; placing it on a percentage axis makes its values visible. Excel displays the secondary value axis on the opposite side of the chart, and you can format it to show percentages.

However, a secondary axis can also make a line appear to rise or fall dramatically simply because its scale is chosen independently. It does not convert the line into the same unit as the columns. Keep the axis title and number format explicit, and do not imply that a line value can be added to the column total. If the series share the same unit and a useful scale, using one axis is usually simpler to interpret.

For a percentage series, verify the underlying values and formatting. A stored value of 0.25 formatted as a percentage displays as 25%; a stored value of 25 formatted as a percentage displays as 2,500%. The axis format cannot correct incorrectly entered data. Check the worksheet values as well as the chart labels.

Format the chart so the stack remains readable

After inserting the chart, use Chart Design and Format to adjust its appearance. Select the chart title and enter a specific description, such as Monthly revenue by product and gross margin. Add axis titles from Chart Design > Add Chart Element > Axis Titles, choosing the relevant horizontal, primary vertical, or secondary vertical title. Available commands can vary slightly with the chart selection and ribbon layout.

Use related colors for the stacked components and a contrasting color for the line. The legend should identify every series, and the line should have enough contrast to remain visible over the columns. If the line is hard to follow, add markers or adjust its width. Avoid excessive gridlines, gradients, and labels on every segment when they make the main comparison harder to see.

Stacked columns make the overall total and the bottom segment easy to compare across categories. Comparing the height of a middle segment is harder because its baseline moves with the segment below it. If the main question is how each product changes month to month, rather than the total composition, a clustered-column chart or separate small charts may communicate that comparison more clearly.

Common problems and fixes

The columns are side by side instead of stacked: Open the combo settings and confirm that every component series is assigned Stacked Column, not Clustered Column. Check that the series intended to stack use the same axis.
The line is flat or nearly invisible: Its values may be much smaller than the column values, or it may be on the wrong axis. Consider a secondary axis when the units differ, then label it and check its scale.
The chart stacks the wrong measures: Remove totals from the stack, or correct the source range and series names. Stacking a total together with the parts that make up that total double-counts the quantity in the visual.
Months appear as series instead of categories: Select Chart Design > Switch Row/Column. If that does not resolve it, use Chart Design > Select Data to check the chart data range and category labels.
The line or bars have confusing labels: Confirm the header row and series names, then edit the axis titles and number formats. A secondary axis should identify its own unit, such as Gross margin (%).

When a chart looks wrong, first inspect the source data and the series assignments rather than trying to fix everything with formatting. A blank cell, an extra total, or a series assigned to the wrong axis can change the chart’s meaning even if its colors and title look polished.

When another chart may be better

A combo chart is most helpful when the series share categories but have different roles: parts versus total, or amounts versus rates. It is less suitable when readers need precise comparisons between many stacked segments, when there are many line series, or when the secondary axis could invite a misleading visual comparison.

Consider a clustered column chart if comparing individual series side by side matters more than showing a total. Use a 100% stacked column when the main question is the proportional mix in each category and the absolute totals are not the focus; each column is normalized to 100%. Use a line chart for trends across many periods, especially when the series have a common unit. Separate charts can be clearer when measures have unrelated units or when one chart becomes too busy.

A stacked area chart can emphasize changing composition over continuous time, but overlapping filled areas may be harder to read than columns for a small number of discrete periods. There is no universally best chart type: choose the form that makes the intended comparison visible without asking readers to infer what the axes mean.

Frequently Asked Questions

Can I make a stacked column and line chart in Excel?
Yes. Create a custom combo chart, assign Stacked Column to the series that form the stack, and assign Line to the other series. Add a secondary axis for the line only if its unit or scale calls for one.

Can I stack one series and leave another column series unstacked?
A combo chart can assign different chart types to different series, but mixed column arrangements can be difficult to read and may overlap depending on the setup. For a clear stacked total, assign all component series to Stacked Column on the same axis; use a line or another distinct chart type for the separate measure.

Why does my combo chart not show a secondary axis?
In the combo settings, select the Secondary Axis option for the intended series. If the chart is already made, select that series, open Format Data Series, and choose Secondary Axis under Series Options. The exact pane layout can vary by Excel release.

Should a percentage line always use a secondary axis?
No. Use one only if the percentage cannot be read sensibly on the primary scale or if its unit differs from the columns. If you do use one, label it clearly and avoid suggesting that the two axes share a scale.

Can I add a total line over stacked columns?
Yes. Add a total series to the source data and assign it Line in the combo settings. Keep the total series out of the stacked columns so it is not added to its own components. If the total and components use the same unit and scale, the line can use the primary axis.

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.