Combo Chart in Excel: How to Create and Use One

To make a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart, and pick a chart combination such as Clustered Column–Line. To put one series on a separate scale, use Insert > Insert Combo Chart > Create Custom Combo Chart and select Secondary Axis for that series.

What a Combo Chart Shows

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 target. The columns make the amount in each month easy to compare, while the line makes the target trend visible across the same months.

Combination charts are useful when the series describe related information but benefit from different visual forms. They can also display series with very different numerical ranges by placing one series on a secondary vertical axis. That can make small values visible beside much larger ones, but it also makes careful labeling important: the two axes have separate scales.

A combo chart is not simply a chart with several colors. You choose a chart type for each data series, such as a column for revenue and a line for units sold. Excel plots those series together against shared category labels, usually dates or names, and can optionally add a second value axis.

Prepare the Data Before Creating the Chart

Organize the source data in a simple rectangular range. Put category labels in the first column and give each measurement its own column with a clear heading. For example, a monthly report might have Month, Sales, and Target as its three headings, followed by one row per month. Excel uses the headings as series names and the month entries as category labels.

Use one row for each category, such as a month, product, or region.
Use one column for each series you want to plot.
Keep numerical values numeric. Text such as a currency symbol typed into a cell can stop Excel from treating the entry as a number.
Include headers, but avoid blank rows or columns inside the selected range.

If the chart places months in the legend and series along the horizontal axis, the data orientation may be reversed. Select the chart and choose Chart Design > Switch Row/Column. This works best when the data is arranged consistently; it changes which rows or columns Excel interprets as series, rather than changing the source values.

Create a Combo Chart in Excel for Windows

For a straightforward combination such as columns and a line, use Excel’s built-in combo chart options. The exact options shown depend on the selected data and the chart combination available in that Excel version.

Select the complete data range, including the headings and category labels.
On the ribbon, choose Insert > Insert Combo Chart. In the chart menu, select a suitable preset, such as Clustered Column–Line or Clustered Column–Line on Secondary Axis.
If the preset does not match your needs, choose Create Custom Combo Chart. In the dialog, choose a chart type for each listed series.
If one series needs its own scale, select the Secondary Axis checkbox beside that series.
Choose OK, then review the chart title, axes, legend, and labels. Resize or move the chart if it obscures worksheet data.

You can also change a chart that already exists: select it, then choose Chart Design > Change Chart Type > Combo. Set the type for each series and select Secondary Axis where appropriate. In Excel for Mac, combo charts are also available, though ribbon placement or wording can differ by release; use the Insert tab or Chart Design tab and look for the Combo chart type or Change Chart Type controls. Excel for the web has a more limited chart-editing interface than the desktop app, so some detailed combo-chart settings may require opening the workbook in Excel for Windows or Mac.

Choose the Right Chart Type for Each Series

Choose chart forms that clarify the relationship, not merely ones that look different. Clustered columns work well for comparing discrete categories. A line is often suitable for a continuous sequence, especially dates, because it emphasizes movement over time. A second column series can be useful for comparing two quantities across the same categories, though two sets of columns may become crowded.

For example, a shop could show monthly sales as columns and its monthly sales target as a line. If both measurements are dollars on the same scale, they can share one vertical axis. If the target is a percentage of a different measure, or if a separate metric such as website visits is included, a secondary axis may be appropriate. Use a chart type that suits the data: a line joining unrelated categories can suggest continuity that does not exist.

Keep the number of series manageable. A chart with several lines, multiple column groups, and two axes can be difficult to read even if Excel allows it. If readers need to compare many categories or measures, consider splitting the information into separate charts or using a small dashboard of charts instead.

When to Use a Secondary Axis

A secondary axis is useful when two series have different units or substantially different ranges. Suppose monthly sales are between 20,000 and 40,000 dollars, while a conversion rate is between 2% and 5%. Plotting both on one scale can flatten the percentage series near the bottom. Assigning the rate to a secondary axis gives it a readable scale on the opposite side of the chart.

To add or remove that axis, select the chart and open Chart Design > Change Chart Type > Combo. In the series list, check or clear Secondary Axis beside the relevant series, then confirm the change. Excel displays a second vertical axis, usually on the right. Add axis titles so readers can identify the measure and units for both scales.

Two axes can create a misleading impression if readers assume they share a scale. The line may appear to rise or fall in step with the columns simply because the axis bounds make the shapes look similar. Avoid adjusting scales just to make the series visually align. Explain each axis clearly, and use separate charts if the relationship between the measures is not meaningful.

Format the Chart for Clear Reading

After building the chart, add a specific chart title rather than leaving a generic label such as Chart Title. For example, Monthly Sales and Target communicates more than Sales. If the chart has a secondary axis, add axis titles that include units, such as Sales ($) on the left and Conversion rate (%) on the right.

Use the Chart Elements button next to the selected chart to add or remove items such as axis titles, data labels, gridlines, and a legend. You can also use Chart Design > Add Chart Element. The legend should make it clear which series is the line and which is the column. Distinct colors and line markers can help, but do not rely on color alone: markers or data labels can improve accessibility for readers who have difficulty distinguishing colors.

Data labels are useful when exact values matter, but labeling every point in a long time series can clutter the chart. Consider labeling only important points or using a nearby data table for exact figures. Keep gridlines subtle, and avoid decorative effects that compete with the data. If the chart has many dates, reduce label density or widen the chart so the date labels do not overlap.

Common Problems and How to Fix Them

The wrong series is a line or column: Open Chart Design > Change Chart Type > Combo and assign the intended type to each series. Check the series names against the worksheet headers.
The chart uses the wrong categories: Select Chart Design > Select Data and review the chart data range and horizontal axis labels. Correct the selected range if it omitted the category column or included an extra field.
A series looks almost flat: Check whether its values are much smaller than the other series. A secondary axis may help when the measures warrant it, but first confirm that the units and data are correct.
Dates appear in an unexpected order: Verify that the source cells contain real Excel dates rather than text that only looks like dates. Also check whether the chart is using a date axis or treating entries as categories.
The legend or labels are confusing: Improve the source column headings, then use the chart’s Select Data controls if the series names need correction. Add axis titles when two scales are present.

When a chart changes unexpectedly after editing the worksheet, inspect its source range. Adding rows outside a fixed chart range may not add those rows to the chart automatically. Converting the source data to an Excel table can help the range expand as rows are added, but review the chart after changing the table or its layout.

Combo Charts Compared with Other Options

A combo chart is best when two related series need different visual treatment or, occasionally, separate scales. A single chart type is usually simpler when the measurements share units and purpose. For example, if the goal is to compare sales across regions, a bar or column chart may be clearer than adding a line solely for variety.

Separate charts are often preferable when the measures have little direct relationship, when two axes could confuse readers, or when the chart becomes crowded. A scatter chart is more appropriate when the goal is to examine the relationship between two numerical variables; a typical combo chart uses categories on the horizontal axis instead. A table may be better when readers need to look up precise values rather than recognize a pattern.

Frequently Asked Questions

How do I add a secondary axis to a combo chart in Excel?
Select the chart and choose Chart Design > Change Chart Type > Combo. Check Secondary Axis beside the series that needs a separate scale, then choose OK. Label both axes so readers know what each scale measures.

Can I make a line-and-column chart in Excel?
Yes. Select the data, then use Insert > Insert Combo Chart and choose a column-and-line preset. For more control, choose Create Custom Combo Chart and set the type for each series.

Why can’t I see the Combo chart option?
Check that you selected chartable data with at least two series, and try the desktop version of Excel. The available chart options depend on the app and version; Excel for the web may not expose every detailed chart control available in Microsoft 365 for Windows or Mac.

Can a combo chart have more than two data series?
Yes. You can assign a chart type to each series, and a series can use the secondary axis. More series are not always more informative, however; too many lines, columns, or scales make comparisons harder.

Should I always use a secondary axis when values differ?
No. Use one only when the different scales are appropriate for the comparison and can be labeled clearly. If separate scales would imply a relationship that is not meaningful, use separate charts instead.

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.