Combo Chart in Excel: How to Create and Format One

To make a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign a chart type to each series, and tick Secondary Axis for any series that needs a separate scale. Choose OK, then add a clear title and axis labels so readers can understand the comparison.

What a combo chart shows

A combo chart, also called a combination chart, displays two or more data series using different chart types in one chart area. A familiar example pairs columns with a line: columns show monthly sales, while a line shows profit margin. The shared horizontal axis keeps each month aligned, making it easier to compare patterns than placing two separate charts side by side.

Combo charts are especially useful when the series describe related things but differ in scale or emphasis. A sales value might be measured in dollars while a conversion rate is a percentage. The chart can show both without treating the percentage as if it were a dollar amount. A combo chart is not automatically clearer, though: if the series are unrelated, have too many categories, or use confusing scales, separate charts may be a better choice.

Prepare the worksheet data

Arrange the information in a simple table before inserting the chart. Put the category labels in the first column and each data series in its own column, with a descriptive heading in the top row. For example, a monthly report might have Month, Revenue, and Profit margin columns. Excel uses the headings as series names and the month entries as horizontal-axis labels.

Use one row for each category, such as a month, product, or region.
Keep each series in a consistent unit. Do not mix percentages and dollar amounts in one column.
Include the column headings when selecting the data, and avoid blank rows or columns inside the table.
Check that percentage values are stored as percentages and that dates are genuine Excel dates when date spacing matters.

For a concrete example, imagine a table with January through June in column A, revenue in column B, and profit margin in column C. Revenue might range from $42,000 to $58,000, while margins range from 8% to 14%. These series share a monthly story, but their units and numerical ranges make a separate scale sensible for the margin. Select the full table, including its headings, before creating the chart.

Create the combo chart in Excel for Windows

Select the category labels, headings, and numeric values in your table. If the data is in a continuous block, click in it and press Ctrl+A to select the current data region; check that the selection includes the intended columns.
Open the Insert tab. In the Charts group, click Insert Combo Chart, then choose Create Custom Combo Chart. If that button is not visible in your ribbon layout, use Insert > Recommended Charts > All Charts > Combo.
In the custom combo dialog, find each data series and choose its chart type. For the example, set Revenue to Clustered Column and Profit margin to Line.
Tick Secondary Axis beside Profit margin if you want the percentage line to use a scale on the right side of the chart. Leave the box clear for series that should share the primary, left-hand axis.
Review the preview and confirm that the categories and series are oriented correctly. Click OK to insert the chart.

You can also change an existing chart rather than starting over. Select it, open Chart Design > Change Chart Type, choose Combo, and set the type and axis for each series. The available combinations can depend on the chart types Excel supports in that chart and workbook, so use the preview to confirm the result before closing the dialog.

When to use a secondary axis

A secondary axis is useful when series have different units or very different ranges. In the revenue-and-margin example, plotting both against the same dollar-scale axis would make values between 8% and 14% appear close to zero. Giving the margin line a right-hand percentage axis makes its changes visible. Format that axis as a percentage and choose sensible bounds so readers can interpret it.

A second axis is not a way to make every line look important. Because each axis has its own scale, the two series can appear to rise or fall together even when their numerical relationship is weak. A carefully chosen minimum and maximum can also exaggerate or flatten variation. Label both axes with units, keep the scales appropriate to the data, and explain the measure in the legend or chart title. If the point is simply to compare direction rather than magnitude, consider whether a separate chart or an indexed measure would communicate the comparison more honestly.

Choose chart types that fit the question

Start with the question the chart should answer. Columns are effective for comparing values across discrete categories; lines are generally helpful for showing a trend across ordered time periods. A column-and-line pairing is common because the two marks are visually distinct, but the best choice depends on the data and audience.

Columns plus a line: compare an amount with a rate, target, or other trend series.
Two line series: compare trends over time when both use a readable, shared scale.
Columns plus an area series: show a quantity alongside a continuous measure, but use transparency and restrained colors to avoid hiding the columns.

Avoid adding a separate series just because Excel offers another chart type. Too many lines, markers, and colors make the chart harder to read. If a series has a different unit, identify that fact directly rather than relying on color alone. Also check the category order: time should normally run from earliest to latest, and a chart with reversed or alphabetically sorted dates can suggest the wrong story.

Format the chart for easy reading

Once the chart is created, select it to show the Chart Design and Format tabs. Use Chart Design > Add Chart Element to add a chart title, axis titles, data labels, or a legend. Exact options can vary slightly with the Excel build, but the chart elements menu is the central place to add or remove these items.

Give the chart a title that states what is being compared and, where useful, the period covered. Label the primary axis with the unit, such as Revenue ($), and label a secondary axis as Profit margin (%). Keep the legend names concise and meaningful. Use contrasting colors for the two series, but do not depend on color alone to distinguish them; a line marker or different line style can help when a chart is printed in grayscale or viewed by someone with color-vision differences.

For a line series, select the line and use the formatting controls to adjust its color, width, or markers. For a secondary axis, right-click that axis and choose Format Axis to set number formatting and bounds. Avoid adding data labels to every point if they overlap. A few labels, a clear axis, and a readable legend are often more useful than a crowded chart. To move or resize the finished chart, drag its border or corner handles.

Common problems and how to fix them

The chart displays the wrong categories: Select the chart and use Chart Design > Switch Row/Column, or return to Select Data and check the category-label range.
The line is almost flat: If it has a different unit or much smaller values, edit the combo settings and assign it to the secondary axis. Do not do this merely to make a preferred visual effect; explain the second scale.
Excel chose the wrong chart type: Open Chart Design > Change Chart Type > Combo and set each series manually.
Months appear in an odd order: Check the source table’s row order and whether the labels are true dates or text. Correct the source data or category-axis settings rather than rearranging the chart by eye.
The chart has blank spaces or unexpected zeros: Inspect the source cells for blanks, text-formatted numbers, or formulas returning empty text. Use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed when that option is available.

When a chart looks wrong, check the source range first. A chart cannot reliably correct an accidental extra column, missing heading, or number stored as text. Editing the underlying data structure is often faster and safer than trying to compensate with formatting.

Excel on Mac and Excel for the web

In Excel for Mac, the overall process is similar: select the data, open the Insert tab, choose a combo chart or use the chart recommendations, and set the type and axis for each series. Ribbon placement and wording can differ between Mac releases, so Chart Design > Change Chart Type is a useful route for modifying a chart after insertion. Excel for the web also provides chart creation and formatting, but the available controls can differ from the Windows desktop application. If a particular combo setting is missing in the browser, open the workbook in the desktop app and make the change there.

Combo charts are also distinct from a PivotChart: they are ordinary charts based on a selected data range, while PivotCharts are connected to PivotTable data and have their own interaction and chart-type constraints. If your source is a PivotTable, confirm that the chart type you need is supported for that PivotChart before planning a report around a particular combination.

Frequently Asked Questions

Can I create a combo chart with two lines in Excel?
Yes. In the custom combo dialog, assign the Line chart type to both series. If they use different units or very different scales, you can assign one series to the secondary axis, but label both axes clearly.

How do I add a secondary axis to an existing Excel chart?
Select the chart, open Chart Design > Change Chart Type > Combo, and tick Secondary Axis for the series that needs it. You can also select a series, open Format Data Series, and choose the secondary-axis option when it is available for that chart.

Why is the combo chart option unavailable?
Check that you selected a suitable data range and are working in an Excel version with combo-chart support. Some chart sources and chart types, including certain PivotChart scenarios, restrict available combinations. Try a regular chart based on a normal data range or update the chart through Change Chart Type.

Can I use a combo chart without a secondary axis?
Yes. Assign different chart types while leaving all series on the primary axis. This is appropriate when the series share units and a common scale remains readable. If their units differ, do not imply that the values are directly comparable just to avoid a second axis.

Can I make a combo chart in Excel for the web?
Excel for the web supports many chart tasks, but its controls may not match the Windows desktop version exactly. If you cannot find the required combo or secondary-axis controls, open the workbook in the desktop version of Excel and edit the chart there.

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.