How to Build a Combo Chart in Excel with a Secondary Axis

To build a combo chart in Excel, select your data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign a chart type to each data series, and select Secondary Axis for any series that needs a different scale. A combo chart is useful for showing related measures—such as monthly sales as columns and a target rate as a line—in one chart without making one measure hard to read.

What You’ll Need

A table with one category column, such as months, and at least two numeric data series.
A header for each column or row so Excel can identify the series and use meaningful chart labels.
Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac has similar chart options, though the exact placement may vary; if you cannot find the combo-chart button, use Insert > Recommended Charts > All Charts > Combo. Excel for the web may offer fewer chart editing controls, so open the workbook in the desktop app if a setting is missing.

Step-by-Step

Arrange and check the source data. Put the shared categories in the first column and each measure in its own adjacent column. For example, use columns labeled Month, Revenue, and Margin, with one month per row. Keep the headers in the first row, avoid blank rows or columns inside the range, and make sure the numeric series contain numbers rather than values stored as text. A combo chart works best when the series refer to the same categories. If you want to compare actual results with a target, include both as separate series alongside the category labels.
Select the full table, including headers. Click a cell in the data range and press Ctrl+A if the range is a clean, contiguous table. Check that the selection includes all category labels and all series, but does not include totals or unrelated notes below the data. You can also drag across the exact range. If your data is in an Excel table, clicking within it usually lets Excel recognize the complete table. Confirm the selection before inserting the chart; missing a column now can make the chart look as if a series has disappeared.
Insert a custom combo chart. On Windows, go to Insert > Insert Combo Chart > Create Custom Combo Chart. In some ribbon layouts, the combo-chart command appears in the Charts group as a small chart icon with a dropdown. The Custom Combo dialog lists your data series and provides a chart-type menu for each one. If the command is not visible, try Insert > Recommended Charts > All Charts > Combo. On Mac, use the equivalent Combo option under Insert or the All Charts tab in Recommended Charts.
Choose a chart type for each series. A common, readable pairing is Clustered Column for counts or amounts and Line for a rate, percentage, or trend. Set the type in the dropdown beside each series name. You can also use a line for a target or benchmark so it is easy to compare against the columns. Avoid choosing chart types merely because they are available: select forms that make the measures easy to distinguish and make sense for the relationship you are showing.
Put a differently scaled series on a secondary axis. If one measure is much smaller or uses a different unit—for example, revenue in thousands and a margin percentage—select the Secondary Axis checkbox for that series in the dialog. Excel will add a scale on the right side of the chart. The primary axis is normally on the left. A secondary axis is not automatically needed just because you have two series; use one when the scales or units make the series difficult to read together. Make the units clear in the axis titles so readers do not mistake the two scales for one.
Create the chart and inspect its orientation. Select OK to insert the chart. Check that the horizontal axis shows your categories and the legend identifies each series. If Excel has treated rows as series when you expected columns, select the chart and choose Chart Design > Switch Row/Column. This is especially useful when your categories are laid out across the top row instead of down the first column. If the wrong categories appear, return to the source selection or use Chart Design > Select Data to review the chart’s data range and labels.
Add a useful title and axis labels. Select the chart, then use Chart Design > Add Chart Element to add or edit a chart title and axis titles. Name the chart for the comparison, such as Monthly Revenue and Margin. Label the left and right axes with both the measure and its unit, for example Revenue ($ thousands) and Margin (%). The legend should use the source headers; if those names are vague, change the headers in the worksheet or edit the series names through Chart Design > Select Data. Clear labels help viewers understand what each plotted scale represents.
Format the chart and verify the message. Use the chart buttons or the Chart Design and Format tabs to adjust the legend, colors, gridlines, and number formats. Give the line and columns distinct, high-contrast colors, and use markers on a line if they help readers identify individual observations. If the percentage axis should show percentages, right-click that axis, choose Format Axis, and set its number format appropriately. Resize the chart so its labels are not clipped. Finally, compare several plotted points with the worksheet values and confirm that each series is using the intended axis.

Common Mistakes

Putting every series on one axis. When a small percentage is plotted beside large currency values, it may flatten against the bottom of the chart. Assign the differently scaled series to a secondary axis when that improves readability.
Using a second axis without identifying it. Two scales can make a chart confusing, and changing their bounds can make the visual relationship appear stronger or weaker. Label both axes, state the units, and avoid implying that two measures move together for a causal reason.
Including totals or blank rows in the selected range. A total can become an extra category or distort the scale; blank rows can create gaps. Select only the intended observations and series.
Choosing a chart type that obscures the comparison. Two lines can overlap, while several column series can become crowded. Use a simple pairing, and check that the chart type suits the data and the story.
Leaving generic labels in place. Names such as Series 1 or Axis Title make a chart harder to interpret. Use descriptive headers, a meaningful chart title, and unit labels.

Tips

Use a line for a measure that represents a trend, rate, or target across ordered categories. Use columns when comparing quantities across categories. These are common choices, not strict rules.
Keep the secondary axis bounds sensible and consistent with the data. Do not adjust them solely to make the line appear to match the column pattern; that can give readers a misleading impression.
Use a short, descriptive title and direct axis labels rather than relying on readers to infer the meaning from the legend alone.
If you expect to add more months or records, convert the source range to an Excel table with Home > Format as Table before creating the chart. Charts based on a table can expand as rows are added, although you should still check that new series and formatting appear as intended.
Keep the number of series limited. A combo chart is most useful when it clarifies one comparison; adding many colors, lines, and axes can make it harder to read than separate charts.

Troubleshooting

The combo option is missing. Confirm that you are using the desktop Excel app and have selected a suitable data range with multiple series. Try Insert > Recommended Charts > All Charts > Combo. If you are working in Excel for the web and cannot access the required chart controls, open the file in the Windows or Mac desktop app.

A series is invisible or nearly flat. It may be plotted against a scale that is too large for its values. Select the chart, open Chart Design > Change Chart Type, and assign the series to a secondary axis if it uses a substantially different scale or unit. Check that its chart type is appropriate and that the source values are numeric.

The wrong series or categories appear. Select the chart and choose Chart Design > Select Data. Review the chart data range, series names, series values, and horizontal category labels. Use Switch Row/Column if Excel interpreted your layout in the opposite direction. Correct the source range if it includes extra cells or misses data.

The chart has gaps, unexpected zeroes, or incorrect dates. Inspect the worksheet for blank cells, text values in numeric columns, and dates stored as text. Correct the source cells and check the chart again. For a gap caused by an empty cell, select the chart and use Chart Design > Select Data > Hidden and Empty Cells to choose how empty cells are displayed, where that option is available.

The line looks misleading after changing the axis. Review the bounds and units on both axes in Format Axis, then label the axes clearly. A secondary axis can make two series visually cross or align even when their values have different units. If the dual scale distracts from the point, consider separate charts instead.

Frequently Asked Questions

What is a combo chart in Excel?

It is one chart that combines two or more chart types, such as columns and a line. It lets you compare related data series while presenting each in a form suited to its values.

When should I use a secondary axis?

Use one when a series has a substantially different scale or unit from another series and would otherwise be difficult to see. Label both axes and interpret the comparison carefully because each axis has its own scale.

Can I change the chart type after creating the chart?

Yes. Select the chart and choose Chart Design > Change Chart Type. Select Combo, set the type for each series, and choose a secondary axis where appropriate.

Can I make a combo chart with three series?

Yes. The Custom Combo dialog lets you choose a chart type for each listed series, and you can assign a series to the secondary axis. Keep the display uncluttered and make every series easy to identify.

Why does my combo chart show the wrong months or categories?

Excel may have selected an incorrect data range or interpreted rows and columns differently than you intended. Use Chart Design > Select Data to check the category labels and series, or choose Switch Row/Column to change the orientation.

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.