Excel Bar Chart With Line Overlay: How to Create One

To make an Excel bar chart with a line overlay, select your category labels and data series, then choose Insert > Insert Combo Chart > Create Custom Combo Chart. Assign the main series to columns or bars and the comparison series to Line; use a secondary axis if their values have very different scales.

What a bar chart with a line overlay shows

This is a combination chart: it displays two kinds of data in one chart area. The bars make the size of a value easy to compare across categories, while the line makes a second series and its movement across those categories visible. For example, bars could show monthly sales in dollars and a line could show the average customer rating. The chart lets readers see both series together without pretending they measure the same thing.

People often use “bar chart” informally to mean any chart made of rectangular bars. In Excel, however, a column chart has vertical bars and a bar chart has horizontal bars. The standard and most dependable Excel combo-chart example is a column chart with a line. If you specifically need horizontal bars, check the available chart-type choices in the custom combo dialog; Excel’s supported combinations can vary by chart type and version. The distinction matters because a line is naturally drawn across categories on a horizontal axis, which fits a column-and-line chart particularly well.

Prepare the data before charting

Arrange the information in a simple table. Put the categories in the first column and each measure in its own adjacent column, with a clear heading in the first row. For instance, list months in column A, revenue in column B, and conversion rate in column C. Each row should represent the same month in every series. Avoid blank rows inside the data and merged cells in the chart range, since they can make Excel interpret the categories or series incorrectly.

Use consistent units and meaningful labels. If one series is a percentage, enter it as a percentage rather than a whole number that merely looks like one. Check that numbers are stored as numbers, not text, and that dates or month names appear in the intended order. Select the headings along with the values so Excel can use the headings as series names and the first column as category labels. If the table includes unrelated totals or notes, leave them outside the selected range.

Create the combo chart in Excel for Windows

In Microsoft Excel for Microsoft 365 on Windows, use these steps:

Select the category labels, series headings, and data values you want in the chart.
Open the Insert tab and choose Insert Combo Chart in the Charts group, then choose Create Custom Combo Chart. Depending on the ribbon layout, you may need to open the chart menu to see the combo options.
In the dialog, choose a chart type for each series. Set the main measure, such as revenue, to Clustered Column. Set the measure to display as a line, such as conversion rate, to Line.
If the series have very different units or magnitudes, select Secondary Axis for the line series. If they are comparable and a shared scale is meaningful, leave it unchecked.
Choose OK, then add a descriptive chart title and axis titles where they help explain the measures.

If you already have a chart, select it and go to Chart Design > Change Chart Type > Combo. Set the chart type for each series and apply the secondary axis option as needed. This is often quicker than deleting a chart and starting again. Excel for Mac has similar chart tools, though the ribbon layout and menu placement can differ by release; look under Insert for combo charts or select a chart and use Chart Design > Change Chart Type. Excel for the web has fewer chart-formatting controls in some builds, so a complex combo chart may be easier to finish in the desktop app.

Decide whether to use a secondary axis

A secondary axis is useful when the series use different units or have sharply different ranges. If monthly sales run from 20,000 to 80,000 while a rate runs from 0% to 10%, a single vertical scale may flatten the rate line near the bottom or make one series difficult to read. Putting the line on a secondary axis gives it a separate scale, usually shown on the right side of the chart, while the columns retain the primary scale on the left.

That extra scale is not a conversion between measures. It does not make dollars and percentages directly comparable; it simply allows both sets of values to be drawn visibly. The apparent steepness and position of the line depend on its axis limits, so a secondary axis can make a modest change look dramatic. Label both axes with their units, use clear series names, and avoid implying that the line and columns share a common numerical scale. If the values use similar units and ranges, a single axis is generally easier to interpret.

Format the chart so the relationship is clear

Once the chart exists, select it to open the Chart Design and Format tabs. Use Chart Design > Add Chart Element to add titles, axis titles, a legend, or data labels. A useful title describes the measure and period, such as Monthly Revenue and Conversion Rate. Name each axis explicitly, for example Revenue ($) on the left and Conversion Rate (%) on the right. This is especially important when a secondary axis is present.

Make the two series visually distinct without relying on color alone. A contrasting line color, visible markers, and a moderate line width can help the line stand out from the columns. Keep the column fill simple, and consider a restrained gridline treatment so the values remain readable. If the chart is printed in grayscale or viewed by someone with color-vision differences, marker shapes or a dashed line can provide another visual cue. Put the legend where it does not cover the data; for a small chart, direct data labels may be clearer than a distant legend.

Use data labels selectively. Labeling every column and every line point can overcrowd a chart with many categories. You might label only the line, only important points, or the most recent value. For a presentation, explain abbreviations and units in the chart itself rather than assuming viewers know what the series represent.

Horizontal bars, and when the line may not fit

A horizontal bar chart is helpful when category names are long or when ranking items is the main task. But combining horizontal bars with a line is not the same as combining columns with a line: the line needs a category position and a value scale, and the axes must align correctly. In Excel, the custom combo menu may not offer every combination for every chart type. If Bar is not offered for the bar series, or the result is confusing, use a column-and-line combo chart instead, or choose a different visualization rather than forcing an awkward overlay.

For a simple ranking plus a target, one option is to show horizontal bars and draw a target reference as a separate line only if the chart’s available features support that combination cleanly. Another is to use a clustered bar chart with a clearly labeled target column, or place a small line chart beside the bars and align the categories. Separate charts are sometimes more honest and easier to read than a technically possible but visually ambiguous overlay.

Common problems and how to fix them

The line is missing or nearly flat: Check that the intended series is set to Line. If its values are much smaller or larger than the column values, try Secondary Axis and label that axis.
Months or categories appear in the wrong order: Confirm the source rows are sorted as intended. Excel may treat date-looking labels as dates; check the source data and category-axis settings.
The wrong data appears as a series: Select the chart and use Chart Design > Select Data to review the chart data range, series names, and category labels. A header row or category column may have been omitted or included incorrectly.
The line connects points in an unexpected order: A Line chart follows the category order in the source table. Sort the source rows into the order you want, rather than expecting the line to sort values automatically.
The chart seems to exaggerate the relationship: Inspect the axis bounds, particularly the secondary axis. The two axes may have different ranges, and the visual crossing or slope does not prove that the measures have a causal relationship.
Some categories have no value: Check for genuinely blank cells, formulas returning empty text, or missing source entries. Use Chart Design > Select Data and the chart’s hidden and empty cells settings if you need to control how gaps are displayed.

When another chart is a better choice

A combo chart is useful when the two measures share the same categories and there is a clear reason to compare their patterns. It is less suitable when the measures have no meaningful relationship, the chart has too many categories, or the second axis makes interpretation uncertain. A line chart alone may be better for two time series with compatible units. Separate small charts can work better when the units differ greatly or when each measure needs its own scale and explanation.

If the goal is to show how two numerical variables relate to each other rather than how both change across the same categories, use an XY (Scatter) chart instead. A scatter chart positions points according to paired numeric values; a category-based line chart spaces its categories according to their order. Choosing between them depends on the question, not just the appearance you prefer. For a target threshold, a reference line or target marker may communicate the goal more directly than a second data series.

Frequently Asked Questions

Can I add a line to an existing Excel bar chart?
Select the chart, then choose Chart Design > Change Chart Type > Combo. Assign the relevant series to Line and, if needed, select Secondary Axis. If the combination you want is unavailable, try a column chart or another chart design supported by the dialog.

Why should the line use a secondary axis?
Use one when the line’s units or range make it hard to see on the column series’ scale. The secondary axis provides a separate scale, not a unit conversion, so identify its units clearly and interpret the line with care.

Can I put a percentage line over dollar columns?
Yes. Set the dollar series to columns and the percentage series to Line, then consider putting the percentage on a secondary axis. Format and label the axes as dollars and percentages so readers do not mistake the scales for one another.

Can I make a horizontal bar-and-line combo chart?
Possibly, depending on the chart types Excel offers in the custom combo dialog and the layout you need. Excel’s column-and-line combo is the more straightforward option. If the horizontal combination is not available or reads poorly, use separate aligned charts or another chart type.

How do I change which series appears as the line?
Select the chart and open Chart Design > Change Chart Type > Combo. Use the chart-type menu beside each series to choose Line for the intended measure, then confirm the axis setting before applying the change.

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.