In Excel, a clustered column line chart is a combo chart: it displays one or more data series as side-by-side columns and another series as a line. Select your data, then use Insert > Recommended Charts > All Charts > Combo, choose Clustered Column – Line, and turn on Secondary Axis for the line if its values need a different scale.
What a clustered column line chart shows
A clustered column chart compares categories by placing their columns next to one another. A line chart connects values across those same categories, making the combination useful when you want to compare amounts and follow a related measure or trend at the same time. In Excel, this is a combo chart rather than a separate chart type named simply clustered column line.
For example, a monthly report could show revenue as clustered columns and conversion rate as a line. The columns make it easy to compare revenue between months; the line makes changes in conversion rate visible. If the table contains several revenue series, Excel can cluster their columns for each month while drawing the selected rate series as a line.
The chart works best when the categories line up and there is a clear reason to show the measures together. It does not make unrelated measures comparable: a shared chart can suggest a relationship even when none exists. Use a descriptive title and label the axes so readers understand what each visual element represents.
Arrange the source data
Put the category labels in the first column and each measure in its own adjacent column, with a clear header in the first row. For instance, use Month, Product A revenue, Product B revenue, and Conversion rate as the four headers, followed by one row per month. Select the headers and all the rows that belong in the chart. Including the headers lets Excel use them as series names.
Keep each row tied to one category. If months are missing, out of order, or written inconsistently, the chart can show gaps or an unexpected sequence. Use actual date values where possible and format them as months, rather than entering month names in a random order. Avoid blank rows within the data range, merged header cells, and totals mixed into the monthly records; these can cause Excel to interpret the chart range incorrectly.
Check that the column intended for the line is a single numeric series. Percentage values can be stored as decimals and displayed with percentage formatting; for example, 0.05 displayed as 5%. A value stored as text may not plot as expected. If you have multiple column series, make sure their names are distinct so the legend is useful.
Create the 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 chart dialog.
- Select Combo. In the available combo chart choices, choose Clustered Column – Line.
- Check the series list and confirm that each revenue or quantity series is set to Clustered Column and the intended measure is set to Line.
- If the line series is on a very different scale from the columns, select its Secondary Axis checkbox. Click OK to insert the chart.
Excel may offer a suggested chart before you reach the combo options. Treat that as a starting point, not a guarantee: inspect the chart type assigned to every series. If you already inserted a chart, select it and use Chart Design > Change Chart Type, then choose Combo and adjust the series settings. Ribbon labels can vary slightly with window size, but the chart-type dialog lets you set the type series by series.
Decide whether to use a secondary axis
A secondary axis is useful when the line and columns use different units or have values with very different magnitudes. Revenue might range from 20 to 100 thousand dollars, while a conversion rate ranges from 2% to 8%. Plotting both against the same vertical scale can flatten the percentage line near zero. Assigning the line to a secondary axis gives it a separate scale, usually shown on the right side of the chart.
A second axis is not automatically better. If the two series have similar units and ranges, a single axis is usually easier to read and avoids asking readers to interpret two scales. When you do use a secondary axis, label both axes explicitly, including units or percentage signs. Do not rely on color alone to explain which scale belongs to which series.
Dual axes can also make two series appear to move together or cross at a chosen point simply because the axis limits differ. That visual alignment is not proof of a meaningful relationship. Set sensible axis bounds, explain the scales, and consider a separate chart if the comparison could mislead readers.
Format the columns, line, and labels
Use a concise chart title that names both measures, such as Revenue and Conversion Rate by Month. Add axis titles when the measure or unit is not obvious. To add or edit chart elements, select the chart and use Chart Design > Add Chart Element; available choices include axis titles, data labels, and a legend. A legend is especially helpful when several column series appear alongside the line.
Make the line visually distinct without overwhelming the columns. A contrasting color, a modest line width, and small markers can help readers track individual monthly values. For clustered columns, use separate, consistent colors for each category of series. Too many bright colors, heavy gridlines, or labels on every point can make a chart crowded. Add data labels selectively when exact values matter; the table can remain the place to look up every number.
To format an axis, select it and open Format Axis from its context menu. You can adjust number display and scale settings. For a percentage line, format the secondary axis as a percentage if appropriate. Be cautious with minimum and maximum bounds: a narrow range can magnify small movements, while a zero baseline is often important for interpreting column lengths fairly.
Fix common chart problems
- The line is nearly flat. Its values may be much smaller or larger than the column values. Change the line series to a secondary axis, or use separate charts if a dual scale would confuse the audience.
- Excel made every series a column. Open Chart Design > Change Chart Type > Combo and set the intended series to Line. Confirm that the series name is the one you meant to change.
- The months or series appear in the wrong direction. Select the chart and use Chart Design > Switch Row/Column. This changes which data Excel treats as categories and which it treats as series; verify the legend and horizontal axis afterward.
- The line has gaps or unexpected zeros. Check the source cells for blanks, text-formatted numbers, or formulas returning empty text. You can also review how the chart displays empty cells through Chart Design > Select Data > Hidden and Empty Cells, where the available options determine whether gaps are shown or connected.
- The horizontal labels are crowded. Widen the chart, reduce the number of displayed labels, or use a shorter date format. If the categories are dates, make sure Excel is treating them as dates rather than unrelated text labels.
When diagnosing a problem, inspect the selected data range and series settings before changing colors or scales. Many apparent formatting problems start with Excel assigning the wrong cells to a series or interpreting the category labels incorrectly.
When to choose another chart
Use a clustered column chart alone when the goal is to compare several measures that share units and a readable scale. Use a line chart alone when the main message is change over time and the series are comparable. A combo chart is most useful when the two visual forms serve different purposes, such as columns for amounts and a line for a rate or target.
If the line represents a target, a horizontal reference line may communicate the threshold more clearly than a measure that changes by month. If the chart has many categories or many column series, it can become difficult to read; consider a line chart, a smaller set of series, or separate charts. A scatter chart is more appropriate when the horizontal values are numeric measurements and the spacing between them matters, rather than evenly spaced categories such as month labels.
Also consider whether readers need to compare exact values or see a broad pattern. A table alongside the chart can provide precise numbers, while the chart highlights trends. Splitting unrelated measures into separate panels is often clearer than forcing them into one chart with two axes.
Excel for Mac and Excel for the web
The instructions above are for Excel for Microsoft 365 on Windows. Excel for Mac also supports combo charts, though the dialog layout and ribbon arrangement can differ. Look for the chart insertion options under Insert, choose a combo chart, and verify the type and axis setting for each series before confirming. Once created, chart selection and formatting controls may appear in different locations than on Windows.
Excel for the web has a more compact interface, and some chart-formatting controls may differ from the desktop application. If you cannot find the combo option or a particular axis setting in the web interface, open the workbook in the desktop version of Excel and use the combo chart dialog there. A chart created in desktop Excel can generally be viewed in the workbook online, but check its appearance after sharing or exporting it.
Frequently Asked Questions
Can Excel make a clustered column and line chart?
Yes. Create a combo chart and assign the desired series to Clustered Column or Line. If the measures use very different scales, you can place the line series on a secondary axis.
How do I add a line to an existing clustered column chart?
Select the chart, choose Chart Design > Change Chart Type, and open Combo. Set the series you want to display as a line to Line, then confirm whether it needs a secondary axis.
Why does my line chart look flat in Excel?
The line may share an axis with columns whose values are much larger, compressing its visible movement. Try the secondary axis, check that the line values are numeric, and label the two scales clearly.
Can I have more than one line series?
Yes. In the combo settings, choose Line for each series that should be a line. Review the legend and colors so readers can distinguish the lines from one another and from the clustered columns.
Should I use a secondary axis for percentages?
Use one when the percentage series would be unreadable on the column series scale, but label the right-hand axis as a percentage. If both measures can be read clearly on one scale, keeping a single axis is simpler.
Related
- Average Shortcut in Excel: Fast Ways to Calculate Mean
- Autofit Pictures in Excel: Fit Images to Cells
- Autofit Page in Excel: Fit a Worksheet to One Page
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Combo Bar Chart in Excel: Create, Format, and Fix ItTo make a combo chart in Excel, select your data, choose Insert > Recommended Charts > All Charts…
- Excel to PowerPoint Gantt Chart: Create and Share ItTo put an Excel Gantt chart in PowerPoint, build it in Excel as a stacked bar chart, select…
- Excel Pie Chart From a Single Column: How It WorksIn Excel for Microsoft 365 on Windows, select a column of numeric values, then choose Insert > Insert…
- 3D Pie Chart in Excel: Create, Format, and Improve ItTo make a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column range containing…
- How to Make a Graph in Excel From Your Spreadsheet DataTo make a graph in Excel, arrange your information in labeled columns or rows, select the cells you…
- View Pivot Table Fields in Google SheetsTo view pivot table fields in Google Sheets, click any cell inside the pivot table; the Pivot table…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.