To add a line to a clustered column chart in Excel, select the chart, choose Chart Design > Change Chart Type > Combo, and set the data series you want to display as a line. Keep the other series as clustered columns, then choose whether the line should use the primary or secondary axis.
What a combo chart does
A clustered column chart compares values across categories by placing columns side by side. A combo chart lets you keep those columns and show a separate data series as a line on the same plot. For example, a monthly sales chart might have columns for actual sales and budget, with a line for a monthly sales target.
The line is not just decoration: it represents values in a data series, matched to the chart’s categories. Excel positions each point over the corresponding category, then connects the points. This makes a line useful for showing a target, rate, index, or other measure whose movement matters alongside the column values.
A frequent source of confusion is the difference between adding a line series and drawing a line shape. A series stays linked to worksheet values and changes when those values change. A shape is a manually drawn annotation; it does not automatically follow changes in the data. For a meaningful comparison, use a combo chart and a data series.
Change the chart to a column-and-line combo
- Click the clustered column chart to show its chart tabs.
- On the ribbon, select Chart Design > Change Chart Type.
- In the chart-type window, choose Combo under All Charts.
- In the list of series, leave the column series set to Clustered Column. Set the series you want as a line to Line.
- If needed, select Secondary Axis for the line series. Click OK.
Some Excel versions show a ready-made Clustered Column – Line option in the Combo choices. You can use it as a starting point, then confirm that each series has the intended chart type. The important setting is per series: changing one series to Line should not turn all the columns into lines.
In Excel for Microsoft 365 on Windows, the ribbon path above is the standard route. In Excel for Mac, select the chart and use the Chart Design tab and Change Chart Type; the dialog’s arrangement can differ slightly. Excel for the web may present fewer chart-editing controls depending on the workbook and current features. If you cannot find Combo or the per-series settings, open the workbook in the desktop app.
Add a data series if the line is missing
The combo-chart dialog can only plot data that is already part of the chart. If the line’s values are in the worksheet but do not appear in the series list, add them to the chart first. A typical layout has category labels in the first column, existing column-series values in the next columns, and the line values in another column. Include a heading for the new series so Excel can use it in the legend.
- Select the chart, then choose Chart Design > Select Data.
- In the Select Data Source window, choose Add under the series list.
- In Edit Series, set Series name to the heading cell and Series values to the cells containing the line’s numbers. Exclude the heading from the values range.
- Check that the horizontal category labels cover the same categories and in the same order as the new series.
- Click OK, then return to Change Chart Type > Combo and set the new series to Line.
For instance, if the chart shows January through June and the target is in a new Target column, the target range needs six numeric cells in that same month order. A mismatch in range length or ordering can put points under the wrong labels, even though the chart itself appears to work. If the source is an Excel table, adding a column beside its existing data can make it easier to maintain the chart’s source as the table grows.
Choose the right axis for the line
Use the primary axis when the line and columns measure comparable quantities and share a useful scale. If monthly sales and a sales target are both amounts in dollars, plotting them against the same vertical scale makes their relationship easy to read. The line should not need a separate scale merely because it is a different chart type.
Use a secondary axis when the line’s units or magnitude make it difficult to see on the column scale. A percentage such as conversion rate alongside revenue is a common example. Select the secondary-axis option for the line in the Combo dialog. Excel then gives the line its own vertical scale, usually displayed on the chart’s right side. If the scale is not visible or the chart needs explanation, add a vertical axis title using Chart Design > Add Chart Element > Axis Titles.
A secondary axis improves visibility, but it can also create a misleading impression: two independently scaled series may look as if they rise and fall together or meet at meaningful values when their scales do not match. Label the axes with units, use a clear legend, and consider whether readers need to compare the actual magnitudes. If both measures can reasonably share one axis, that is often easier to interpret.
Make the line readable
After changing the chart type, format the line so it is distinguishable from the columns and remains clear when printed or viewed at a small size. Click the line to select the series, then use the Format Data Series pane. Under Fill & Line, adjust the line color, width, or dash style. If points are hard to locate, enable or change markers in the pane’s Marker options.
Choose a line color with strong contrast against the chart background and the column fills. A thin line can disappear when the chart is resized; an excessively heavy line can obscure nearby columns or markers. Markers are especially helpful when the chart has only a few categories, while a plain line can look cleaner across many categories.
Keep the legend names descriptive, such as “Monthly target” rather than “Series 3.” If the line is a percentage on a secondary axis, make that clear in the legend or axis title. Avoid relying on color alone to distinguish the series: different marker shapes or a dashed line can help readers who have difficulty distinguishing colors and make the chart more robust in grayscale.
Create a horizontal target or threshold line
A target line can be made from an ordinary line series. Add a worksheet column with the target value repeated once for every category, add that column to the chart, and set its chart type to Line. For a constant target of 100 across six months, the new series should contain six 100 values. Excel connects those points into a horizontal line, and changing the target value in the source data updates the chart.
This method is usually more dependable than drawing a line shape across the plot area. A shape can stay in place while the chart’s scale changes, making it no longer represent the target correctly. A data series follows the chart’s categories and value axis. If the target represents a different unit from the columns, decide whether it belongs on the primary or secondary axis and label that choice clearly.
Use a line series for a threshold that applies across categories. Use a trendline when the goal is to show a statistical trend fitted to a data series; a trendline is calculated from the plotted values, not a user-entered target. Excel’s Chart Design > Add Chart Element > Trendline command is a separate feature and should not be used as a substitute for a fixed target series.
Common problems and how to fix them
- The line option is unavailable or the new series is absent: Add the values through Chart Design > Select Data > Add first. Then reopen the Combo settings.
- The line is nearly flat or invisible: Check whether its values are much smaller or larger than the column values. Try a secondary axis when the measures have different scales, and verify that the selected axis is appropriate.
- The line appears under the wrong categories: Recheck the category-label range and make sure the line values follow the same category order. Ensure the series contains one value for each category.
- There are gaps in the line: Check the source cells for blanks or text stored where numbers are expected. A blank is different from a zero: a zero is a plotted value. For chart-specific blank handling, open Chart Design > Select Data > Hidden and Empty Cells and review the available options.
- The chart changes when new rows are added: Confirm that the chart source includes the new data. Using an Excel table as the source can help the chart expand as table rows are added, though the series’ chart type and axis settings should still be checked.
When adjusting chart settings, use Ctrl+Z on Windows to undo a recent change; on Mac, use Command+Z. Undo is useful for a formatting mistake, but it is not a replacement for checking the worksheet data and series ranges.
When a different chart approach is better
A combo chart is a good choice when the reader needs to compare columns with a separate measure across the same categories. It may not be the clearest option for every task. If the line values are the main story and the columns add little, a line chart may communicate the pattern more simply. If the measures have unrelated units and a secondary axis would confuse the comparison, consider separate charts with aligned category labels instead.
If you only need to mark one event or annotate one point, a text box or shape can be appropriate, provided it is clearly an annotation and not presented as data. For a value that should update with the worksheet, retain it as a chart series. This distinction helps prevent a decorative line from being mistaken for a measured value or a changing target.
Frequently Asked Questions
Can I add a line to a clustered column chart without rebuilding it?
Yes. Select the existing chart and change its type to Combo. Keep the existing series as Clustered Column and set the desired series to Line; Excel preserves the chart as a combined chart.
How do I add a horizontal line for a goal in Excel?
Add a series containing the goal repeated for every category, add it to the chart, and set that series to Line. Use the primary axis if the goal uses the same units as the columns.
Should the line use a secondary axis?
Only when its scale or units make the primary axis unsuitable, such as a percentage alongside a large currency value. Label the second axis and remember that different scales can affect how the relationship appears.
Why does my line not show in the combo chart?
Common causes include the series not being added, text or blank cells in its values, a very different scale, or a series range that does not match the category labels. Check Select Data and the axis assignment.
Is a trendline the same as adding a line series?
No. A line series plots values supplied in worksheet cells, such as a target for each month. A trendline is a fitted line that summarizes a data series; it does not plot a separate set of entered values.
Related
- Excel Insert Row Below a Selected Row: Quick Steps
- Excel: Import Multiple CSV Files Into One Worksheet
- Accounting Number Format Excel Shortcut?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Bar Chart Different Color Bars: How to Set ThemYes. In Excel for Microsoft 365 on Windows, select the chart, right-click a bar, choose Format Data Series,…
- Excel Pivot Table Custom Filters: How to Use ThemTo add a custom filter to an Excel PivotTable, open the drop-down beside a row or column field,…
- Excel Smooth Line Chart: How to Create and Format OneTo create a smooth line chart in Excel for Microsoft 365 on Windows, select your data, choose Insert…
- Excel Gantt Chart Automatic? Setup, Updates, and LimitsYes. In Microsoft Excel for Microsoft 365 on Windows, a Gantt chart can update automatically when you change…
- Power Pivot in Excel for Mac: What You Can and Can’t DoNo: Excel for Mac does not include Power Pivot, so you cannot create or manage a Power Pivot…
- Side-by-Side Histogram in Excel: How to Make One EasilyTo make a side-by-side histogram in Excel, put each group’s observations in its own column, define the same…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.