Excel Custom Combo Chart: How to Build and Format One

An Excel custom combo chart combines two or more chart types—such as columns and a line—in one chart, so you can compare related data series that have different patterns or scales. In Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts > All Charts > Combo, then assign a chart type to each series and select Secondary Axis for a series when its scale requires it.

What a custom combo chart does

A combo chart plots multiple data series in the same chart area but lets each series use a different chart type. A common pairing is clustered columns for monthly sales and a line for a target or percentage. The columns make the size of each month’s sales easy to compare; the line makes the direction of the target or rate easy to follow.

“Custom” means you choose the combination rather than accepting a preset. Excel’s Combo chart options let you set the chart type for each series separately and, where appropriate, put a series on a secondary vertical axis. You are not combining two charts as separate objects: the series share one chart, its category axis, and much of its formatting.

Combo charts are most useful when the data has a meaningful relationship, such as units sold and conversion rate for the same months. They are less suitable for unrelated measures simply because both happen to be in the same worksheet. A shared display can suggest a relationship that the data does not support.

When to use one—and when not to

Consider a combo chart when the series answer complementary questions but a single chart type would make at least one series difficult to read. For example, if quarterly orders are around 1,000 to 1,500 and the on-time delivery rate is around 90% to 98%, columns and a line can show volume and service performance together. The two measures can share quarter labels while retaining distinct scales.

A combo chart can also clarify comparisons between actual results and a target. Columns can represent actual revenue while a line marks the monthly goal. If the goal is a constant threshold, a line series with the same target value repeated for each month is one practical way to display it.

Choose another chart type when the purpose is different:

Use a single-column or single-line chart when the series have comparable units and scales.
Use separate charts when readers need to judge each measure precisely or when the measures have no clear relationship.
Use a scatter chart when both axes represent numerical values and the relationship between two variables matters more than categories such as months.
Avoid a combo chart with many series. Too many colors, markers, and axes make it harder to see the message.

Arrange the data before charting

Excel needs a tidy range in which the first column identifies the categories and each subsequent column contains one series. For a monthly example, place Month in A1, Sales in B1, and Conversion rate in C1; list the months in A2:A13 and the corresponding values in B2:C13. Include headers, keep each series consistently formatted as numbers or percentages, and avoid blank rows inside the data.

Use clear, short series names because Excel may display them in the legend and chart controls. If dates are used as categories, enter real Excel dates and format them as desired rather than typing inconsistent date-like text. If the chart assigns months to the wrong axis or interprets rows as series, select the chart and use Chart Design > Switch Row/Column to change how Excel reads the range.

Percentages deserve particular attention. A value of 0.95 formatted as a percentage displays as 95%; a value of 95 formatted as a percentage displays as 9,500%. Check the underlying values before building the chart, especially if you are combining a rate with counts or currency.

Build a custom combo chart in Excel

Select the complete data range, including the header row and category labels.
On the ribbon, choose Insert > Recommended Charts, then open the All Charts tab in the dialog.
Select Combo. Excel displays the available series and a chart-type selector for each one.
Choose a chart type for each series. For example, set Sales to Clustered Column and Conversion rate to Line.
If the series use substantially different scales, select Secondary Axis for the rate series. Review the preview to see whether the result is readable.
Select OK, then add or revise the chart title, axis titles, legend, and number formats.

You can also change an existing chart: select it, choose Chart Design > Change Chart Type, and select Combo. In the dialog, choose the type and axis setting for each series. The exact dialog layout can vary slightly with Excel updates, but the key controls are the per-series chart type and Secondary Axis option.

Excel for Mac has chart-type and combo-chart controls too, though the ribbon and dialog arrangement may differ from Windows. In Excel for the web, chart-editing options can vary; if the Combo choice or a needed setting is unavailable, open the workbook in the desktop app to make the change.

Choose chart types and axes carefully

Start with the question the chart should answer. Columns are effective for comparing discrete categories, while a line is useful for showing a continuous sequence such as time. A line over columns is therefore a sensible default for actual values plus a trend, rate, or target. Avoid using a line for categories that have no meaningful order, because connecting them implies continuity.

A secondary axis is useful when the series have different units or very different numerical ranges, but it needs clear labeling. If sales are measured in dollars and a rate in percent, label both vertical axes with their units, format the rate axis as a percentage, and use a legend that identifies each series. Do not rely on color alone to explain which axis belongs to which series.

Different axis scales can make two series appear to move together even when their underlying changes are not comparable. The visual impression depends on the chosen minimum and maximum values. Keep the scales appropriate, disclose the units, and avoid adjusting them merely to make the lines look aligned. If the comparison could mislead, use two aligned charts with separate axes instead.

Format the chart for clear reading

After creating the chart, select it to access the Chart Design and Format tabs. Use Chart Design > Add Chart Element to add chart elements such as axis titles, data labels, or gridlines. The available elements depend on chart type; for instance, data labels can be useful for a small number of columns but may clutter a chart with many monthly values.

Make the series visually distinct without making the chart decorative. A restrained column color and a contrasting line with visible markers can help readers follow both. To format a particular series, select it in the chart and use Format Data Series. For a line, adjust its color, width, or marker options; for columns, adjust fill and border. Keep the legend names specific, such as On-time rate, rather than Series 2.

Give the chart a descriptive title that says what is being compared and over what period. Add axis titles when units are not unmistakable. Format dates consistently and set number formats that match the data, such as currency for revenue and percentages for rates. If the labels are crowded, widen the chart, shorten category labels, or show fewer labels rather than shrinking the text until it is hard to read.

Common problems and practical fixes

The chart shows the wrong series or categories: Check the selected range and headers. Use Chart Design > Switch Row/Column if Excel has treated rows as series instead of categories, or vice versa.
The line is nearly flat: Its values may be tiny compared with the primary-axis series. In Chart Design > Change Chart Type > Combo, try Secondary Axis for that series, then label and format the new axis clearly.
The secondary axis is missing: Reopen the Combo settings and confirm that Secondary Axis is checked for the intended series. The checkbox applies to a series, not to an entire chart type.
The percentage looks implausible: Inspect the source values and cell formats. Confirm whether the data uses decimals such as 0.95 or whole numbers such as 95 before setting the axis to percentage.
The chart looks crowded: Remove unnecessary data labels, reduce the number of series, or split the display into two charts. A combo chart does not become clearer just by adding more colors.
The line connects unexpected points: Check the category order and whether the source range contains blank or text values. Correct the source data or adjust how missing values are displayed if appropriate.

Before sharing a chart, check it at the size and in the context where it will be read. A chart that is legible on a large monitor may become difficult to interpret in a narrow report column or when printed. Include a short note about units or definitions if the chart will be separated from the worksheet that explains its data.

Combo charts versus separate charts

The main advantage of a combo chart is compact comparison: related measures appear against the same category labels. Its main risk is interpretive ambiguity, especially when the chart uses a secondary axis. Separate charts take more space but make each scale explicit and can be easier to compare when exact values matter.

A dashboard may use both approaches: a combo chart for a quick overview and a separate chart or table for detailed values. If readers may confuse the axes, or if the two measures need independent scales, separate aligned charts are often the more transparent choice.

Frequently Asked Questions

How do I add a secondary axis to a combo chart in Excel?
Select the chart, choose Chart Design > Change Chart Type, and open Combo. Check Secondary Axis for the series that needs its own scale, then choose OK. Add an axis title or clear number format so readers know what that scale measures.

Can I combine a line and column chart in Excel?
Yes. In the Combo chart settings, assign Clustered Column to one series and Line to another. A typical example is monthly sales as columns and a percentage or target as a line.

Why can’t I select Combo in Excel?
Check that you are working with a chart and a data range that contains multiple series. Combo-chart options may not be available in every Excel interface or for every chart setup. If the command is missing in Excel for the web, open the workbook in Excel for Microsoft 365 desktop and use Insert > Recommended Charts > All Charts > Combo.

Can a combo chart have more than two series?
Yes. You can assign a chart type to each series, but adding series can quickly make the display difficult to interpret. Use only the measures needed to answer the question, and avoid multiple secondary axes that leave readers unsure which scale applies.

Can I make a combo chart with two different units?
Yes, and a secondary axis is commonly used for that purpose—for example, dollars and a percentage. Label both axes and consider whether the combined view could imply a misleading relationship. Separate charts may be clearer when precise comparisons matter.

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.