To add a line to a column chart in Excel for Microsoft 365 on Windows, add the line’s values as a data series, select the chart, then choose Chart Design > Change Chart Type > Combo and set that series to Line. Turn on Secondary Axis for the line if its values use a very different scale from the columns.
This creates a combo chart: columns show one measure and a line shows another on the same category labels. The line is linked to worksheet data, so it updates when those values change.
Prepare the worksheet data
Excel needs one value in the line series for each category in the chart. Put categories in the first column and each measure in its own adjacent column, with a clear header row. For example, a monthly sales chart might use Month, Orders, and Target as three columns. Each month should have an orders value and a target value.
Keep the category labels and series aligned row by row. If the chart already uses the month column for its horizontal labels, the new series should have the same number of data points in the same order. A blank, extra value, or mismatched range can make the line stop early or appear under the wrong month. Avoid including the header cell as a numeric value when specifying the series values.
If the chart is based on an Excel table, adding a new column beside the existing data often lets the chart recognize the added series automatically. If it does not, add it manually through Select Data. Ordinary cell ranges may need to be edited or expanded when new rows or columns are added later.
Add the line series to an existing chart
First, make sure the line’s data is available in the worksheet. Then add that range to the chart as a series:
- Select the column chart so the chart tabs appear on the ribbon.
- Choose Chart Design > Select Data.
- In the Select Data Source dialog, choose Add under Legend Entries (Series).
- For Series name, select the header cell for the line measure. For Series values, select only that measure’s numeric cells, not the header.
- Choose OK to close the series dialog, then OK again to return to the chart.
At this point Excel may display the new values as another set of columns. That is expected: adding a series does not automatically make it a line. The next step changes the chart type for that series while leaving the existing column series intact.
Change the added series to a line
With the chart selected, open Chart Design > Change Chart Type, then choose Combo in the chart-type list. In the combo settings, Excel shows each series and its chart type. Leave the existing measures as column types, such as Clustered Column, and choose Line for the series you just added. Select the secondary-axis checkbox for that line only if the scales warrant it, then click OK.
If you are creating a chart from scratch, select the full data range, including labels and headers, and use Insert > Insert Combo Chart or the combo-chart options in the Insert Chart dialog. Choose a column type for the main measure and Line for the other one. The precise layout of chart options can vary slightly with ribbon window size, but the chart type is the same.
Check the result before formatting: the columns should still represent the original measure, and the line should follow the values from the added series. If the line is missing, verify that the series has valid numeric values, that its range is correct, and that its chosen chart type is Line rather than Column.
Decide whether to use a secondary axis
A secondary vertical axis is useful when the column and line measures have substantially different units or ranges. For example, monthly orders might range from 400 to 900 while a customer satisfaction score ranges from 0 to 5. If both series use the same left axis, the satisfaction values may sit almost on the baseline and be difficult to read. Assigning the line to the right-hand axis gives it a scale that makes its changes visible.
Use the checkbox next to the line series in the Combo chart settings to place it on a secondary axis. Excel then displays a right-side vertical scale for that series. Add axis titles when the units are not self-evident, such as Orders on the left and Satisfaction score (0–5) on the right. A secondary axis changes the visual scale, not the underlying values.
Do not add a second axis automatically just because the chart offers one. When both measures share a unit and comparable ranges, a single axis is usually easier to interpret. Two independently scaled axes can make a line appear to rise or fall in close alignment with the columns even when the numerical relationship is weaker than the picture suggests. Label both axes clearly and avoid implying that unlike units are directly comparable.
Format the line so it is easy to read
Once the combo chart is in place, make the line visually distinct without letting it compete with the columns. Select the line and use the formatting controls on the Format Data Series pane to adjust its color, width, and markers. A contrasting color and modest marker size can help readers follow individual monthly values. Keep the column colors consistent so the two measures remain easy to distinguish.
Use a chart title that describes the comparison, such as Monthly Orders and Target. If the legend names are generic, rename the worksheet headers to meaningful labels or edit the series name in Select Data. Axis titles are especially helpful when the line uses a secondary scale. Data labels can be useful for a small number of points, but labeling every point in a busy chart may obscure the line and columns.
For a target or threshold line, repeat the target value in the data row for every category. For example, if a monthly target is 700 orders, enter 700 alongside each month and plot that series as a line. This produces a horizontal reference line that changes only if the target data changes. A drawn shape can look similar, but it is not tied to the data and may not stay aligned if the chart or values change.
Choose the right chart setup
A column-and-line combo chart works best when the two measures share the same categories but communicate different kinds of information. Columns are effective for comparing amounts across discrete groups, while a line emphasizes a sequence or pattern across those same groups. Typical combinations include actual results with a target, sales with a percentage rate, or production volume with an index.
- Use a line series on the same axis when the measures share units and a useful scale.
- Use a secondary-axis line when the units or value ranges differ enough to hide one series, and label both scales.
- Use two separate charts when the measures need different category groupings or when the dual scales would confuse readers.
- Use a simple column chart when the added line does not answer a clear comparison question.
A line connects points in category order; it does not prove that intermediate values were measured. With months or other categories, the connecting segments help show direction, but the chart should not imply continuous measurements if the data is only a set of separate observations. Consider a scatter chart for two numerical variables where the horizontal positions represent actual numeric values rather than equally spaced labels.
Fix common combo-chart problems
- The line appears as columns. The series was added but its chart type was not changed. Reopen Chart Design > Change Chart Type > Combo and set the intended series to Line.
- The line is almost flat or invisible. Its values may be small compared with the column values. Test the secondary axis, and confirm that the line series is numeric rather than stored as text.
- The line is plotted against the wrong months. Check the category label range and the order of the line values. Each line value must correspond to the category in the same row.
- Only part of the line appears. Inspect the source range for blanks, text, or missing values. Also confirm that the series range includes all intended rows and no unintended header or total cells.
- The chart has an unwanted extra series. In Select Data, remove the mistaken series or edit its range. This can happen if the full worksheet range was selected when adding data.
- The line overlaps the columns in a confusing way. Adjust the series colors and axis choice, or use separate charts. A secondary axis is not a remedy if it makes the comparison misleading.
When Excel seems to ignore a data change, click the chart and inspect Chart Design > Select Data to verify the series range. If the chart uses a fixed cell range, new worksheet rows may sit outside it. Extending the source range or converting the source data to a table can help keep future additions included.
Excel for Mac and Excel for the web
In current desktop Excel for Mac, the general workflow is similar: select the chart and use the chart design controls to change its type to a combo chart, then assign Line to the desired series. Ribbon placement and dialog appearance can differ from Windows, so look for Change Chart Type and the Combo options rather than relying on identical screen positions.
Excel for the web can edit many chart properties, but the available combo-chart controls may differ from the desktop app and can depend on the workbook and current web interface. If you cannot assign a different type to an individual series or set a secondary axis, open the workbook in the Excel desktop app and make the change there. The underlying worksheet data remains the same.
Frequently Asked Questions
Can I add a line to a column chart without creating a new chart?
Yes. Add the line values as another series through Chart Design > Select Data > Add, then change that series to Line in Chart Design > Change Chart Type > Combo. Excel updates the existing chart rather than requiring a separate chart.
How do I add a horizontal target line to a column chart?
Create a target data column with the same target value repeated for every category, add it as a series, and set its type to Line. If the target uses the same units and scale as the columns, keep it on the primary axis.
Why is my line at the bottom of the chart?
The line values may be much smaller than the column values, so the shared vertical scale compresses the line. Assigning it to a secondary axis can make it legible, but check that the second scale is labeled and does not distort the intended comparison.
Can I put only one series on a line and keep the rest as columns?
Yes. The Combo settings let you choose a chart type for each series independently. Keep the other series as columns and set only the selected series to Line.
Can I add a line to a column chart in Excel for the web?
Possibly, depending on which chart controls are available in your web session. If the web version does not expose combo-series or secondary-axis settings, open the file in desktop Excel for the full chart controls.
Related
- Comparison Plot in Excel With R²: Steps and Meaning
- Company Invoice Template in Excel: Setup and Tips
- Compare Lists in Excel: Find Matches and Differences
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: How to Ignore Blank Rows and ValuesYes. In Excel for Microsoft 365 on Windows, open the pivot field’s drop-down and clear the (blank) item…
- Excel Pivot Table: How to Keep Formatting on RefreshTo keep formatting when an Excel PivotTable refreshes, select the PivotTable, open PivotTable Analyze > Options, and on…
- Insert Line Sparklines in Excel: Steps, Tips, and UsesTo insert a line sparkline in Excel for Microsoft 365 on Windows, select the cell or cells where…
- Excel Pie Chart: Remove Zero-Value LabelsTo remove a zero-value label from an Excel pie chart, click the chart, click the label once to…
- Excel Chart Types: How to Choose the Right Chart for DataThere is no single best Excel chart type: choose the one that makes your data’s main message easiest…
- Excel Pivot Table Sort by Sum ColumnTo sort an Excel pivot table by its Sum column, right-click any value in that column, choose Sort,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.