Insert a Combo Chart in Excel: Steps, Axes, and Tips

To insert a combo chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Combo Chart and pick a layout, such as Clustered Column – Line on Secondary Axis. If that button is not visible, use Insert > Recommended Charts > All Charts > Combo, choose a chart type for each series, and select Secondary Axis for a series that needs a different scale.

What a combo chart does

A combo chart combines two or more chart types in one chart area. A common example uses columns to show monthly sales and a line to show a related rate, such as profit margin. The columns emphasize the size of each month’s sales; the line makes the movement in the rate easier to follow.

Combo charts are especially useful when the series have different roles or units. For example, revenue measured in dollars and customer satisfaction measured on a 0–100 scale may be easier to understand as columns and a line than as two sets of columns. Excel can plot one series on a secondary vertical axis so the two scales can be read separately.

A combo chart is not simply a way to decorate a regular chart. Its purpose is to communicate how measures relate over the same categories or time periods. If the measures do not have a meaningful relationship, putting them together can make the chart harder to interpret.

Prepare the data before inserting the chart

Arrange the data in a rectangular table, with category labels in the first column and each series in a separate column. Include a descriptive heading at the top of every series. For example:

Column A: Month
Column B: Revenue ($ thousands)
Column C: Gross margin (%)

Each row should represent the same period for every measure. Use actual numeric values for the data, rather than typing symbols or explanatory text into the cells. For percentages, enter values as percentages or decimals and apply percentage formatting; Excel needs numbers to plot a meaningful axis. Avoid blank rows or merged cells within the range, since they can make Excel misread the data or create unexpected gaps.

Including units in the column headings helps Excel create useful series names and helps readers understand the chart. If your table uses an Excel table, adding new rows can make it easier to extend the chart’s source data later, though you should still verify that the chart includes the intended columns.

Insert a combo chart step by step

Select the category labels, series headings, and values you want to chart. Include the heading row and the category column.
On the ribbon, open Insert. In the Charts area, choose Insert Combo Chart. Depending on the ribbon layout, the command may appear as a small chart button or within a chart menu.
Choose a built-in combination that suits the data, such as Clustered Column – Line or Clustered Column – Line on Secondary Axis.
If you need control over each series, choose Create Custom Combo Chart or open Recommended Charts, select All Charts, and then select Combo. Assign a chart type to each series in the dialog.
Tick Secondary Axis for the series that uses a substantially different scale or unit. Check the preview, then select OK.

The chart appears on the worksheet. Click its title to replace the placeholder with a specific description, such as “Monthly Revenue and Gross Margin.” On Excel for Mac, the chart options are also available from the Insert tab; depending on the Microsoft 365 build, use Recommended Charts, then All Charts > Combo to configure the series. Ribbon labels and arrangement can differ slightly between Windows and Mac.

Choose chart types and axes that make sense

Use columns or bars for values that readers should compare across categories, such as quarterly units sold. Use a line for a continuous trend across ordered categories, especially dates. A line is often effective for a rate or target that is easier to compare as a trend than as another column series. The choice should reflect what the data means, not just which combination looks attractive.

Use a secondary axis when the series have different units or scales that would otherwise make one series nearly invisible. In the revenue-and-margin example, revenue might range from 20 to 100 thousand dollars while margin ranges from 10% to 35%. A single vertical scale cannot represent both units sensibly, so revenue can use the primary axis and margin can use the secondary axis.

A secondary axis does not make the measures directly comparable. Each axis has its own scale, and changing either scale can alter the apparent alignment or steepness of the line. Label both axes with their units, use a clear legend, and avoid implying that two lines or shapes match numerically just because they cross or move together visually. If the relationship is the main point, consider whether a scatter chart or separate charts would communicate it more honestly.

Customize and check the finished chart

Select the chart to show chart-specific ribbon tabs. Use Chart Design > Add Chart Element to add titles, axis titles, data labels, or gridlines. The available choices depend on the selected chart type. A useful chart title says what is being compared, while axis titles make units explicit, for example “Revenue ($ thousands)” and “Gross margin (%).”

To revise the series assignments, right-click the chart and choose Change Chart Type, then select Combo. In the combo settings, change a series from column to line, or select or clear its Secondary Axis option. You can also use Chart Design > Select Data to inspect the source range, add or remove a series, or correct category labels.

Before sharing the chart, check that the legend names match the worksheet headings, the categories appear in the intended order, and all relevant data points are included. If the two vertical axes are difficult to distinguish, give them clear titles and use restrained colors that remain readable when printed. Avoid unnecessary 3-D effects, which can distort how column heights appear.

Example: revenue columns with a margin line

Suppose a worksheet has one row per month and contains revenue and gross margin. Select the month labels and both numeric series, including their headings. In the Combo dialog, assign Clustered Column to Revenue and Line to Gross margin. Because dollars and percentages use different units, select Secondary Axis for Gross margin. This displays revenue against the left axis and margin against the right axis.

Give the chart a title that names both measures and add axis titles with units. Then check a few values against the worksheet: if March revenue is 80 ($ thousands), its column should correspond to 80 on the revenue axis; if March margin is 24%, the line point should correspond to 24% on the percentage axis. This simple check can reveal a reversed series assignment, incorrect source range, or wrongly formatted percentage values.

Common problems and how to fix them

The chart option is missing: Try Insert > Recommended Charts > All Charts > Combo. If you selected only one series, add the other series and its heading to the selected range.
Excel plots months as separate series: Select the chart, choose Chart Design > Switch Row/Column, or use Select Data to correct the category labels and series orientation.
The line is flat or hard to see: The series may be sharing an axis with values of a much larger magnitude. Reopen Change Chart Type > Combo and consider assigning the line series to the secondary axis.
Percentages look like whole numbers: Check the source values and number format. A value entered as 25 is not the same as 25% in Excel; a percentage is typically stored as 0.25 and displayed as 25%.
Some points are missing: Inspect the selected source range and the cells in it. Blank cells, text in a numeric series, or an omitted final row can affect what is plotted.

When another chart may be better

A combo chart is not automatically the best choice whenever a worksheet contains multiple measures. If all series share the same unit and scale, a clustered column chart can make comparisons more straightforward. If the reader needs to compare trends across several measures, separate charts with matching time axes may be clearer and less cluttered.

A scatter chart is often more suitable when the goal is to examine the relationship between two numeric variables, such as advertising spend and sales, because it plots one numeric measure against another. A combo chart instead aligns series by shared categories, such as dates or product names. For a small report, two aligned charts can also avoid the interpretive difficulties of a secondary axis.

Frequently Asked Questions

Can I combine a column chart and a line chart in Excel?
Yes. Select the data, choose Insert > Insert Combo Chart, and select a column-and-line option. In the custom Combo settings, assign the desired chart type to each series.

How do I put one series on a secondary axis?
Open the Combo chart settings and select Secondary Axis beside the series that needs its own scale. You can also right-click the chart, choose Change Chart Type, and adjust the Combo settings.

Can a combo chart have two lines?
Yes. A combo chart can use different types for its series, and more than one series can use the same type. Choose the types in the Combo dialog; use a secondary axis only if a series needs a different scale.

Why can’t I see the Combo chart option?
Check that you have selected multiple data series, then look under Insert > Recommended Charts > All Charts > Combo. The chart menu’s appearance can vary with window size and Excel version.

Can I change a regular chart into a combo chart?
Yes. Select the existing chart, choose Chart Design > Change Chart Type, and select Combo. Set a chart type for each series and enable a secondary axis where appropriate.

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.