Clustered Column Line Combo Chart in Excel: How-To

To make a clustered column and line combo chart in Excel for Microsoft 365 on Windows, select your category labels and data series, then choose Insert > Insert Combo Chart > Create Custom Combo Chart. Set the series you want as bars to Clustered Column, set the other series to Line, and select Secondary Axis for the line if its values use a different scale.

What a clustered column and line combo chart shows

A combo chart places two chart types in one plot area. Clustered columns compare amounts across categories, while a line makes a second series easier to follow as a trend. For example, columns might show monthly product sales and a line might show the average selling price. The columns answer how much was sold; the line shows how the price changed over the same months.

Clustered columns are useful when each category has multiple column series to compare side by side, such as sales for two regions in each month. If there is only one column series, the columns still work, although they will not be grouped beside another series. A line series can be plotted against the same vertical scale as the columns or against a secondary vertical axis. The right choice depends on the units and range of the data, not merely on which option makes the line look more dramatic.

This chart is sometimes called a column-line combo chart. It is not a special formula or worksheet function; it is a chart type that combines two visual encodings. The underlying data remains in ordinary worksheet cells and can be edited like any other chart source data.

Choose data that makes the comparison meaningful

Arrange the source data with one category column and a separate column for each series. Include a header for each series, and avoid blank rows or merged cells inside the range. For instance, an illustrative monthly table could have Month, Units Sold, and Average Price as its three headers. The first series could be 420, 460, 510, 485, 550, and 590 units from January through June; the second could be prices of 12, 12.5, 13, 12.8, 13.4, and 14 dollars.

In that example, units sold are naturally represented by columns and average price by a line. Because the numbers and units differ, the price line may be difficult to interpret on the units axis. A secondary axis can provide a separate price scale. The chart should make the meaning of both scales explicit with axis titles, such as Units sold and Average price ($). These numbers are only an example; they do not describe a real company or market.

Before creating the chart, check that each row represents the same category for all series. If one column contains months and another contains dates for a different reporting period, the chart may align values that do not belong together. Also decide whether the category order is chronological, alphabetical, or otherwise intentional. A line joining categories implies a sequence, so arbitrary category order can suggest a trend that the data does not support.

Create the combo chart in Excel for Windows

Put the category labels in the first column and series names in the top row. Select the complete rectangular range, including headers.
On the ribbon, choose Insert > Insert Combo Chart > Create Custom Combo Chart. If the combo-chart button is not visible, choose Insert > Recommended Charts, open the All Charts tab, and select Combo.
In the combo chart dialog, choose Clustered Column for the series that should appear as bars and Line for the series that should appear as a line. Excel lets you set the chart type for each series separately.
If the line has a different unit or scale, select the Secondary Axis checkbox for that series. Leave it unchecked when both series use the same units and a shared scale is useful.
Choose OK. Review the category labels, legend, and axes; then add a descriptive chart title and axis titles where needed.

The series names in the dialog should match the headers in your selected range. If the chart puts the months in the legend instead of along the horizontal axis, use Chart Design > Switch Row/Column. This changes how Excel interprets the selected rows and columns; it does not alter the worksheet data. You can also use Chart Design > Select Data to inspect or adjust the chart’s data range and series.

In Excel for Mac, the chart options can be reached from Insert > Recommended Charts and the All Charts tab, then Combo; the exact ribbon arrangement can vary by release. The key setting is the same: assign Clustered Column or Line to each series and enable Secondary Axis for the appropriate series. Excel for the web may expose fewer chart-formatting controls than the desktop app, so use the Windows or Mac desktop version if a needed combo-chart setting is not available.

Decide whether the line needs a secondary axis

A secondary axis is appropriate when the two series use unlike units, such as dollars and units sold, or when their values are far apart in magnitude. It gives the line a scale of its own, usually shown on the right side of the chart, while the columns use the primary axis on the left. Read both axes carefully: a line value should be interpreted using the scale assigned to it, not the column axis.

Separate scales can also make a modest change look visually large. The shape and apparent steepness of a line depend partly on the range chosen for its axis. This does not make a secondary axis automatically misleading, but it does mean the scale needs to be visible and explained. Use axis titles, sensible bounds, and a clear legend. Avoid choosing bounds solely to make the line appear to rise or fall sharply.

If both series measure the same thing in comparable units, try keeping them on one axis first. A shared scale makes direct magnitude comparisons easier. If one series becomes nearly flat because the other has much larger values, consider whether the comparison is still useful. A separate chart, indexed values, or a carefully explained secondary axis may communicate the relationship more honestly.

Format the chart so readers can interpret it

Click the chart to show the Chart Design and Format tabs. Use Chart Design > Add Chart Element to add or edit a chart title, axis titles, legend, and gridlines. In some ribbon layouts, a Chart Elements button appears beside the selected chart as a shortcut. Use titles that name the measure and unit rather than generic text such as Series 1. For example, label the left axis Units sold and the right axis Average price ($).

Choose contrasting but coordinated colors for the columns and line. A line with markers can help readers identify monthly values, particularly when the chart is small or printed. To change the line appearance, select it and use Format Data Series; to change the columns, select a column series and format that data series. Keep the legend labels meaningful, and do not rely on color alone if the chart will be viewed in grayscale or by someone with color-vision differences.

Check the horizontal axis labels for crowding. If there are many dates, showing every label may make the chart difficult to read. Widening the chart, shortening labels, or reducing the number of displayed intervals can help. Do not remove categories from the source data just to make the chart less crowded unless omitting those values is analytically justified.

Common problems and how to fix them

The line is almost flat or invisible: Its values may be small relative to the column values. In Change Chart Type, assign the line series to a secondary axis if the units or scale warrant it; then verify the right-hand scale and title.
The wrong series appears as a line: Open Chart Design > Change Chart Type and check the type assigned to each named series. The chart dialog can list series in an order that is not obvious from the worksheet.
Months appear as separate legend entries: Excel may have interpreted rows as series. Try Chart Design > Switch Row/Column, then confirm that months are on the horizontal axis and the measures are in the legend.
The chart includes blank categories or unexpected values: Use Chart Design > Select Data to review the chart data range and each series. Check for stray cells included in the selection or headings that were left out.
The line connects categories in a surprising order: Check the order of the source rows and the horizontal-axis settings. A line chart connects points in category order; it does not automatically sort category labels into the order you intended.
The axes make the result seem contradictory: A dual-axis chart can show the line rising while the columns fall, or make two series look closely aligned, depending on the scales. Read both axis ranges and explain the separate units rather than judging from the crossing or visual alignment alone.

When another chart type may be clearer

A clustered column and line chart is useful when the two measures share categories but serve different roles. It is not the best choice for every two-series comparison. If the measures use the same unit and direct comparison matters, clustered columns on one axis may be easier to read. If the main purpose is to show how two numeric variables relate, a scatter chart may be more suitable because both axes represent numeric values rather than named categories.

If the line represents a percentage, make that clear in its series name and axis title. Do not assume that a percentage belongs on a secondary axis just because it is a percentage; the decision should reflect the comparison and readability. For a small number of categories, two aligned charts can sometimes be clearer than one dual-axis chart. Separate charts avoid competing scales while preserving the same time or category order.

A stacked column chart answers a different question: it emphasizes a total and the parts that make up that total. It is generally not interchangeable with clustered columns, which put series side by side for comparison. Choosing the chart based on the question helps prevent a visually attractive chart from implying a relationship the data does not establish.

Frequently Asked Questions

Can I make a clustered column and line chart with a secondary axis in Excel?
Yes. Use Insert > Insert Combo Chart > Create Custom Combo Chart, assign Clustered Column and Line to the relevant series, and select Secondary Axis for the line when a separate scale is appropriate.

How do I change a column series to a line after creating the chart?
Select the chart and choose Chart Design > Change Chart Type. In the Combo options, set the desired series to Line, then confirm whether it needs a secondary axis.

Why is my line not visible in an Excel combo chart?
The line may be plotted against an axis with a much larger range, may have the same color as the background, or may be assigned to the wrong series. Check its chart type, axis assignment, scale, and formatting.

Should I always put the line on a secondary axis?
No. Use one axis when the measures share units and a common scale supports the comparison. Use two axes when separate units or ranges make the line unreadable, and label both scales clearly.

Can I have more than one line or column series?
Yes. In the custom combo settings, assign a chart type to each series. Several column series can be clustered together, and one or more series can be lines, though adding too many series can make the chart crowded.

Does changing the chart type change my worksheet values?
No. Changing a series from columns to a line changes how the chart displays the selected data, not the values stored in the cells. Editing those cells can update the chart because it remains linked to its source range.

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.