Microsoft Excel Combo Charts: How to Create and Format

A Microsoft Excel combo chart displays two or more data series as different chart types, such as columns for sales and a line for profit margin. In Excel for Microsoft 365 on Windows, select the data, choose Insert > Insert Combo Chart, then pick a chart type for each series and enable a secondary axis when the series use very different scales.

What an Excel combo chart shows

A combo chart combines chart types in one plot so that related measures can be compared without forcing them into the same visual form. A common example is monthly revenue shown as columns alongside a line for the percentage of orders delivered on time. The columns make the changing revenue totals easy to compare; the line emphasizes the movement in the rate.

Excel assigns each series its own chart type. Some combinations are especially useful because they answer different questions at once:

Clustered columns and a line: compare amounts with a rate, target, or index.
Columns and a line on a secondary axis: compare a large-scale quantity, such as units sold, with a smaller-scale measure, such as conversion rate.
Stacked area and clustered columns: show how a total changes over time while comparing another measure, where the data and chart options suit that view.

A combo chart is not simply two charts placed beside each other. The series share a plot area and category axis, making their timing or categories easier to compare. That shared space can also create confusion if the scales, labels, or visual styles are not clear.

When to use one—and when not to

Use a combo chart when the series belong to the same story but have different roles. For example, a store might compare monthly sales revenue with the number of transactions. A line for transactions can reveal whether revenue rose because of more purchases or because the average purchase was larger. Another useful case is actual results as columns with a target shown as a line.

It is usually a good fit when:

The series share the same categories, such as months, products, or regions.
One series is better understood as a trend, rate, or benchmark than as another set of bars.
The measures can be distinguished through chart type and, if needed, separate axes.

A combo chart is less helpful when the measures have no meaningful relationship, when there are many series, or when a second axis would make the chart hard to interpret. Separate charts can be clearer for unrelated metrics. If the main purpose is to show parts of a whole, a suitable stacked chart may communicate that structure better. A dual axis does not prove that two measures are related; it only gives them separate scales in one view.

Prepare the data before creating the chart

Arrange the worksheet in a simple table with one category column and a separate column for each data series. For example, put month names in column A, revenue in column B, and delivery rate in column C, with descriptive headers in row 1. Use one row per month and avoid blank rows or merged cells inside the table. Select the headers and the data when inserting the chart so Excel can label the series correctly.

Check the data before charting. Revenue should be numeric values, not numbers stored as text, and percentages should be entered consistently as percentages or decimals with percentage formatting. Make sure each row refers to the same month across all series. If one series has missing values, decide whether the gap should remain visible or whether the data needs correction; a chart cannot make incomplete source data reliable.

Use categories at a consistent level of detail. Mixing monthly totals with daily rates in the same rows can lead to a misleading comparison. Also consider whether a rate should be weighted: the average of several percentages is not always the meaningful overall percentage. The chart displays the values supplied to it, so the source data should reflect the question you intend to answer.

Create a combo chart in Excel for Microsoft 365

Select the category labels, series headers, and values in the worksheet.
On the ribbon, choose Insert > Insert Combo Chart. Depending on the ribbon layout, the combo-chart button appears in the Charts group.
Choose a suggested combination, or select Create Custom Combo Chart to assign a chart type to each series.
In the combo chart dialog, use the chart-type list beside each series to choose the desired type, such as Clustered Column or Line.
For a series that needs a different scale, select its Secondary Axis checkbox. Leave it unchecked when the primary axis is suitable.
Choose OK, then review the chart title, axes, legend, and data.

If the data is already charted, select the chart and choose Chart Design > Change Chart Type > Combo. Assign chart types and axis settings in the dialog, then confirm. This changes the existing chart rather than requiring you to start over. If Excel has put categories into the series or series into categories, try Chart Design > Switch Row/Column and check whether the result matches the table.

Excel for Mac has comparable chart options, though ribbon placement and dialog appearance may differ by release. In Excel for the web, chart creation and formatting controls can differ from the Windows desktop app; if a particular combo or axis setting is unavailable in the browser, open the workbook in the desktop version and use the Chart Design controls.

Understand the secondary axis

The secondary axis is a second value scale, usually displayed on the right side of the chart. Use it when two measures have substantially different units or ranges. For instance, monthly revenue might range from $20,000 to $80,000 while a delivery rate ranges from 85% to 99%. Plotting both against one scale would flatten the percentage series near the bottom; a separate percentage axis makes its variation visible.

That visibility comes with a responsibility: two axes can make small changes appear dramatic or make unrelated trends look as though they move together. Read each line or column against the axis that belongs to it, and label both scales with units. Do not imply that one unit equals another. If the chart is for a report, state clearly which series uses the right-hand axis.

To adjust an axis, select the axis labels, right-click, and choose Format Axis. The Format Axis pane lets you adjust settings such as bounds, units, number format, and display options. Use bounds that preserve context rather than selecting limits solely to exaggerate a change. For rates, a scale that starts at zero is not always the most useful choice, but a truncated range should be conspicuous and explained where the chart could otherwise mislead.

Format the chart for readability

Start with a specific title that names the measures and period, such as Monthly Revenue and Delivery Rate. Add axis titles through Chart Design > Add Chart Element > Axis Titles, then label the horizontal and vertical axes with meaningful categories and units. The secondary value axis should also have a title if its units are not obvious.

Give each series a clear visual identity. A line with markers can be easier to follow across categories than a plain line, while columns should have enough contrast against the chart background. Avoid relying on color alone to distinguish measures: use the legend, direct labels where practical, and distinct line or marker styles. Keep gridlines light enough that they support reading values without competing with the data.

Data labels are useful for a few important points, but labeling every point can clutter a chart with many months or categories. Consider labeling the final value, a target, or a notable outlier instead. Remove decorative effects that do not clarify the comparison. Before sharing, check that the chart remains understandable when printed in grayscale or viewed at a smaller size.

Common problems and practical fixes

The combo option is unavailable or the chart looks wrong: confirm that the selected range includes category labels and at least two data series. Try selecting the chart and using Chart Design > Change Chart Type > Combo.
The wrong series appears as a line: reopen the combo settings and assign the chart type to the intended series by its name. Check the source headers if the names are unclear.
Months appear as separate series: use Chart Design > Switch Row/Column, then inspect the legend and horizontal axis.
A series seems almost flat: its scale may be very different from the primary series. Consider a secondary axis, but label it clearly and assess whether a separate chart would be less confusing.
The chart changes unexpectedly after adding data: check the chart’s source range and whether the new rows or columns are included. An Excel table can make expanding data ranges easier to manage, but verify that the chart includes the intended fields.
Dates are spaced oddly: check that the source cells contain valid dates and review the horizontal axis settings. Category axes and date axes do not always space labels in the same way.

When a chart communicates a surprising result, inspect the source values and axis bounds before changing the design. A visually polished chart can still be wrong if its data range omits a month, includes a total row, or uses inconsistent units.

Combo charts compared with alternatives

A combo chart is often compared with a dual-axis line chart, but the terms describe different things. A combo chart uses multiple chart types; it may use one axis or two. A dual-axis chart uses two value axes; the plotted series could use the same chart type or different types. The choice of chart type and the choice of axis are separate decisions.

Use a standard line chart when all series are comparable measures over time and a single scale works. Use clustered columns when the focus is comparing amounts across categories. Use a scatter chart when the horizontal values are numeric measurements rather than evenly spaced categories, or when examining a relationship between two numeric variables. Use small, separate charts when a shared plot would need too many colors or axes. The clearest chart is the one that answers the reader’s question without requiring them to guess which scale applies.

Frequently Asked Questions

How do I add a secondary axis to an Excel combo chart?
Select the chart, choose Chart Design > Change Chart Type > Combo, and select the Secondary Axis checkbox for the relevant series. Confirm the change, then label the right-side axis with its units.

Can I make a column-and-line chart in Excel?
Yes. Select the data, open Insert > Insert Combo Chart, and choose a column type for one series and Line for the other. Add a secondary axis only if the measures need separate scales.

Why is the combo chart option grayed out?
Check that the selection contains a category column and multiple numeric series, or select an existing chart and use Chart Design > Change Chart Type. If the option is still unavailable, try the desktop Excel app and confirm the chart type and data arrangement.

Can a combo chart have more than two series?
Yes. Excel’s custom combo settings let you assign chart types to multiple series, though additional series can make the result difficult to read. Use a small number of clearly labeled measures and consider separate charts when the plot becomes crowded.

Should I always use a secondary axis for a line series?
No. Use one only when the series’ units or scale make a shared axis unsuitable. A secondary axis can clarify a comparison, but it can also exaggerate apparent relationships, so label it and interpret it cautiously.

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.