How to Add a Combo Chart in Excel: A Clear Walkthrough

To add a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts > All Charts > Combo, assign a chart type to each series, and select Secondary Axis for any series that needs a different scale. A combo chart puts two chart types, such as columns and a line, in one chart so you can compare related measures that are hard to read on the same scale.

For example, monthly sales might work well as columns while the sales growth rate appears as a line. Before you begin, arrange the information in a simple table with column headings, category labels, and at least two data series. The steps below use a column-and-line example, but the same process works with other combinations offered in Excel.

What You’ll Need

An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The desktop app offers the most complete combo-chart setup. If you are using a Mac, look for the same chart options under Insert and Chart Design; labels and ribbon layout can vary slightly by release. Excel for the web may not show every custom combo option, so open the workbook in the desktop app if you cannot find it.
A rectangular data range with headings in the first row and category labels in the first column. For example, use Month, Sales, and Growth Rate as headings, then enter one month per row.
At least two meaningful data series to plot. Decide which measure should be columns and which should be a line, and whether either needs its own vertical axis.

Step-by-Step

Arrange and check the source data. Put category names, such as months or product names, in the first column. Give each value series a clear heading in the top row. Keep the table contiguous: avoid blank rows or columns inside it, merged cells, and notes mixed into the data. Enter actual numeric values for the measures. If a series contains percentages, format those cells as Percentage so the chart and its labels reflect the intended units. A compact example would have Month in column A, Sales in column B, and Growth Rate in column C.
Select the full table, including headings. Drag across the category labels and every series you want in the chart. Including the headings helps Excel name the series and including the category column gives the horizontal axis useful labels. If the range is an Excel table, click a cell in the table and check that Excel has recognized the full range; if it has not, select the full range manually. Do not include unrelated totals unless you specifically want a total plotted as another category.
Open the combo-chart choices. On the ribbon, choose Insert > Recommended Charts. In the Insert Chart window, select the All Charts tab, then choose Combo in the chart-type list. This route lets you set a different chart type for each series before inserting the chart. If you already inserted a chart, select it and go to Chart Design > Change Chart Type, then choose Combo. On some releases, the direct Insert Combo Chart button may also be available on the Insert tab.
Assign a chart type to each series. In the Combo options, use the chart-type dropdown beside each series name. For a familiar comparison, set Sales to Clustered Column and Growth Rate to Line. Check the series names carefully; if Excel has guessed that rows are series and columns are categories, the names may not match your intended measures. You can change the assignments here before you click OK.
Choose whether a series needs a secondary axis. If one measure is much larger than the other, or the measures use different units, select the Secondary Axis checkbox beside the smaller-scale series. In the example, sales might be thousands of dollars while growth is a percentage; putting both on the same vertical scale can flatten the percentage line. A secondary axis gives that series a separate scale, usually displayed on the right side of the chart. Click OK to create the chart.
Check the chart’s direction and categories. Review the horizontal axis to make sure it lists your months, products, or other categories in the intended order. If Excel has plotted each month as a separate series, select the chart and choose Chart Design > Switch Row/Column. Check the legend too: it should identify the measures, not repeat every category. Switching rows and columns changes how Excel groups the selected data, so switch back if the series or labels become less clear.
Add a descriptive title and axis labels. Select the chart title and replace the default text with a title that says what is being compared, such as Monthly Sales and Growth Rate. To add axis titles, select the chart and choose Chart Design > Add Chart Element > Axis Titles, then choose the relevant horizontal, primary vertical, or secondary vertical title. Label units where they matter, such as Sales ($) or Growth (%). If the secondary axis is not obvious, a clear title is especially useful.
Format the scales and series for readability. Right-click an axis and choose Format Axis to review its bounds, number format, and display units. For a percentage series, confirm that the axis shows percentages rather than unexplained decimals. If the two axes have different ranges, avoid making visual comparisons based only on line height; separate scales can make changes appear more or less dramatic. Use a distinct line color and markers if the line is difficult to distinguish from the columns. Keep the legend visible and remove decorative effects that compete with the data.
Resize and confirm the finished chart. Drag a corner handle to make the chart large enough for its title, legend, and axis labels. Check a few plotted values against the source cells, especially if the chart includes blanks, zeros, or filtered rows. If the data will grow, consider converting the source range to an Excel table using Home > Format as Table before building or updating the chart. Save the workbook after confirming that the chart communicates the comparison accurately.

Common Mistakes

Using a secondary axis just because it is available. A second scale can help when units or magnitudes differ, but it can also make a small movement look large. Use it only when it makes both series legible, and label the axis so readers know what it measures.
Choosing the wrong data orientation. If the legend lists months instead of measures, Excel may be treating rows as series. Try Chart Design > Switch Row/Column, then check that categories and series now match your intended story.
Including totals or unrelated columns. A grand total plotted alongside monthly values can distort the scale and make the individual bars look tiny. Select only the categories and measures you want readers to compare.
Leaving headings vague or missing. Without clear headers, the legend can show generic names such as Series 1. Add meaningful column headings in the source table and update the chart if needed.
Making the chart visually busy. Too many series, colors, labels, and gridlines make a combo chart difficult to interpret. Focus on a small number of related measures and remove elements that do not support the comparison.

Tips

Choose chart types based on what each series represents. Columns are effective for comparing amounts across categories; a line is useful for showing a trend across an ordered sequence such as dates.
Keep the category sequence consistent. For a time series, sort dates from earliest to latest before charting so the line does not jump back and forth.
Use a secondary axis when two measures have different units or scales, not merely because one series is hard to see. If both measures are comparable and legible on one scale, a single axis is simpler.
Give the two chart types distinct, accessible colors and check that the line remains visible when printed or viewed in grayscale. Markers can help distinguish individual line values.
When the source is an Excel table, adding rows to the table can make the chart’s source data easier to maintain. Confirm that new categories appear in the chart after expanding the table.
Consider whether the chart could mislead. Two vertical axes can have different minimums and maximums, so the apparent crossing or slope of the line is not a direct measure of the relationship between the series.

Troubleshooting

The Combo option is missing. Confirm that you are using the desktop version of Excel and that a chart or valid data range is selected. Try selecting the data first, then open Insert > Recommended Charts > All Charts > Combo. If you are in Excel for the web and cannot find the custom controls, choose Open in Desktop App and create or edit the chart there.

The line is flat or difficult to see. The series may be plotted against a scale dominated by much larger values. Select the chart, open Chart Design > Change Chart Type > Combo, and enable Secondary Axis for that series. Then format the axis and verify its number format. If the scale is already separate, check that the source values are numeric and not stored as text.

Excel plots the wrong series or categories. Select the chart and choose Chart Design > Switch Row/Column. If that does not solve it, use Chart Design > Select Data to inspect the chart data range, edit a series, or correct the category-axis labels. Ensure the range includes the intended headings and labels but excludes unrelated cells.

The chart has blank categories, unexpected zeros, or gaps. Check the source range for blank cells, text in numeric columns, and formulas returning empty text. In a chart, select Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed; available choices can vary with chart type and Excel release. Also check whether filters or hidden rows are affecting what is displayed.

The secondary axis or its labels are not visible. The series may not have been assigned to the secondary axis, or the axis title may not have been added. Reopen Chart Design > Change Chart Type > Combo and check the series’ Secondary Axis box. Then add the secondary vertical axis title through Chart Design > Add Chart Element > Axis Titles.

Frequently Asked Questions

What is a combo chart in Excel?
A combo chart displays two or more data series using different chart types in the same chart, such as columns for sales and a line for a rate. It is useful when the measures are related but communicate different kinds of information.

Can I make a combo chart with only one data series?
A combo chart is intended to combine chart types across multiple series, so you generally need at least two series to make a meaningful combination. If there is only one measure, choose a single chart type instead.

When should I use a secondary axis?
Use one when a series has a different unit or scale and would otherwise be unreadable beside the other series. Label both axes clearly, and explain the units so readers do not mistake the separate scales for a direct visual comparison.

Can I change a regular chart into a combo chart?
Yes. Select the existing chart, choose Chart Design > Change Chart Type, select Combo, assign a chart type to each series, and set any needed secondary axis. Click OK to apply the change.

Can I create a combo chart in Excel for Mac?
Many current desktop versions of Excel for Mac provide combo-chart options. Select the data and look under Insert for Recommended Charts or chart types; for an existing chart, check Chart Design > Change Chart Type. The exact layout can differ from Windows, so use the Combo option if it is available in your release.

Why does my chart show Series 1 and Series 2?
Excel may not have included the heading cells in the selected range, or the headings may be blank. Add clear headers to the source data, then update the chart’s data range through Chart Design > Select Data or recreate the chart with the headings included.

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.