Excel Combo Chart: How to Combine Bars and a Line in Excel

To make a bar-and-line combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts > All Charts > Combo, then assign one series to columns and another to a line. If the series use different scales, select Secondary Axis for the line series before clicking OK.

What an Excel combo chart does

A combo chart displays two or more data series using different chart types in the same plot area. A common arrangement uses columns, often casually called bars, for one measure and a line for another. The columns make it easy to compare values across categories; the line makes a trend or rate easier to follow across those same categories.

For example, a sales report might show monthly revenue as columns and conversion rate as a line. The horizontal axis can show January through December, while the vertical axes show dollars and percentages. A combo chart does not combine the underlying values or calculate a relationship between them. It simply presents series together, with the option of giving one series its own vertical axis.

Use this chart when comparing related measures over the same categories or time periods. It is not automatically the best choice whenever a table contains two kinds of numbers: both series need a meaningful shared context, and the chart should make their scales understandable.

Prepare the data before inserting the chart

Set up the worksheet as a simple rectangular table with one header row. Put the categories in the first column and each measure in its own adjacent column. For instance, a monthly table could have Month, Revenue, and Conversion rate as headers, followed by one row per month. Keep the data contiguous, with no entirely blank rows or columns splitting the table.

Use clear labels that can become useful legend entries, such as Revenue and Conversion rate, rather than generic headings such as Series 1. Enter dates as real Excel dates if you want Excel to recognize a date axis. Enter percentages as numeric values formatted as percentages, rather than typing a percent sign into text. Check that the data rows line up: each revenue value and rate should refer to the same month.

If the table includes extra measures, decide which ones belong in this chart before selecting the range. Adding many series can make the visual crowded and the legend hard to read. A combo chart is usually clearest with one prominent column series and one line series, though Excel can combine more series when the comparison remains readable.

Create a column-and-line combo chart

In Excel for Microsoft 365 on Windows, select the full table, including its headers, then use these steps:

Choose Insert > Recommended Charts.
In the Insert Chart window, open the All Charts tab and select Combo.
Choose a column-and-line combination, such as Clustered Column – Line.
In the series list, confirm the chart type assigned to each measure. Set the main measure to Clustered Column and the other measure to Line.
If the values need different scales, select Secondary Axis for the line series.
Click OK, then add or revise the chart title, axis titles, and other labels as needed.

You can also change an existing chart: select it, choose Chart Design > Change Chart Type, and select Combo. The dialog lets you change the type for each series and choose whether a series uses a secondary axis. If you do not see Combo or the chart is not behaving as expected, check that the selection includes at least two data series and that the chart is an editable chart rather than a picture.

On Excel for Mac, the chart controls are arranged somewhat differently across releases. Select the chart and look under Chart Design for Change Chart Type or use the Insert chart controls to find a combo chart. The Windows menu sequence may not match exactly. Excel for the web can display many charts, but the desktop app generally offers the fuller set of chart-type and formatting controls.

Choose whether the line needs a secondary axis

The main decision is whether both measures can be read sensibly against one vertical scale. If revenue is between 10,000 and 50,000 dollars while conversion rate is between 2% and 8%, plotting both on the same scale can flatten the percentage series near the bottom. A secondary vertical axis lets the line use a separate scale, so its changes can be seen.

In the Combo chart dialog, enable Secondary Axis on the line series when the units or value ranges differ substantially. Excel then displays a second vertical axis, usually on the right side of the chart. Format that axis as a percentage if it represents a rate, and give it a descriptive axis title. Readers should be able to tell which scale belongs to the line without guessing from the legend.

A secondary axis is not compulsory just because the chart has both columns and a line. If both series use the same units and a useful common range, a shared axis may be clearer. For example, columns for monthly units sold and a line for a target measured in the same units can often share one scale. In that case, the line can show whether actual values meet the target without introducing a second scale.

Be cautious when using two axes: their independent ranges can make a line look steep or flat depending on how the axes are scaled. That is not necessarily an error, but it can affect how readers perceive the relationship. Label both axes and avoid implying that a visual crossing, matching height, or similar slope proves that the measures are directly comparable.

Format the chart so the comparison is clear

After inserting the chart, make the important information legible before adding decorative effects. Select the chart title and replace it with a description that names the measures and period, such as Monthly Revenue and Conversion Rate. Use axis titles when units are not obvious. The legend should identify each series, and its labels should agree with the worksheet headers.

Use distinct, readable colors for the columns and line. A line with visible markers can help readers follow individual monthly values, especially if the chart has only a small number of categories. To adjust a series, select it and use the Format Data Series pane. Depending on the selection, the pane provides controls for fill, line, markers, and axis options. Keep gridlines subtle enough that they aid reading without competing with the data.

For a rate series on a secondary axis, format the axis as Percentage and choose a sensible number of decimal places. Check the scale endpoints as well as the number format: a percentage axis that starts at 0% tells a different visual story from one that starts at 5%. A tighter range can make small changes visible but may exaggerate them. Choose a scale that suits the purpose and make it easy to see where it begins and ends.

Finally, check the chart at the size where it will be used. Long month names, a large legend, or several line markers can crowd a compact chart. Widen the chart, simplify labels, or move the legend if needed. If readers need exact values, add data labels selectively or keep the source table nearby; labeling every column and every line point can make a chart difficult to scan.

Common problems and practical fixes

The line series is nearly flat: Its values may be much smaller than the column values. Edit the chart type and put the line on a secondary axis, then label and format that axis.
The wrong series is shown as columns: Open Chart Design > Change Chart Type > Combo and assign each series explicitly. Do not rely on Excel to guess which measure should be the line.
The horizontal axis shows numbers instead of category names: Recheck the selected range and use Chart Design > Select Data to inspect the horizontal axis labels and series. Include the category column and header row.
Months appear in an unexpected order: Sort the source table by the date field. If Excel treats dates as text, convert them to actual dates; text values may sort alphabetically rather than chronologically.
The chart includes blank or irrelevant categories: Check whether the selected range extends beyond the populated table. Adjust the chart data range or use a well-formed Excel table so the chart range can expand with added rows.
The percentage looks like a decimal: Format the secondary axis or the source values as Percentage. Confirm that the source data is stored on the intended scale; for instance, a stored value of 0.05 formats as 5%.

When changing the source data, distinguish formatting from the actual stored value. Applying Percentage formatting changes how a number is displayed, not the underlying number. Also, avoid accidentally plotting a total row as another category; including a total beside the individual months can distort the scale and confuse the comparison.

Combo chart versus separate charts

A combo chart is compact and makes it easy to compare two measures across matching categories. It works well on a dashboard or in a report where the relationship is meaningful and space is limited. Its main trade-off is added complexity: different marks and, sometimes, two axes require readers to understand more of the chart before interpreting it.

Separate charts can be better when the measures have no useful relationship, when each needs a different time range, or when a secondary axis would be confusing. Small multiples—separate charts with matching category order and similar design—can preserve the comparison while giving each measure a straightforward scale. A scatter chart is more suitable if the question is how one numeric variable relates to another, rather than how two measures change across a shared sequence of categories.

Also consider whether the line communicates a continuous trend. A line connecting monthly rates suggests movement between observations, which is often reasonable for time data. For categories with no natural order, connecting points can imply continuity that is not present. In that situation, a column chart, dots, or separate views may be more honest and easier to read.

Frequently Asked Questions

How do I add a line to a bar chart in Excel?
Select the chart, choose Chart Design > Change Chart Type, and select Combo. Set the desired series to Line, leave the other series as columns, and choose Secondary Axis for the line if its scale differs.

Can I make a combo chart without a secondary axis?
Yes. A secondary axis is optional. Leave it off when the series can be interpreted on one shared scale, or when the line is a target expressed in the same units as the columns.

Why is my line not visible in an Excel combo chart?
The line may be plotted on a scale dominated by much larger column values, its series may contain blanks or text, or its chart type may not be set to Line. Check the series settings and data, and consider a secondary axis when the units differ.

Can a combo chart have more than one line?
Yes. In the Combo dialog, assign a chart type to each series. More lines or columns can make the chart harder to interpret, so use clear labels and include only series that help answer the same question.

Can I use a percentage as the line in a combo chart?
Yes. Store the rate as a number and format it as a percentage. If it is plotted on a secondary axis, format that axis as Percentage too, and make the axis title or legend clear about what the rate measures.

Does a secondary axis change the data?
No. It changes the scale used to display one series; it does not alter the source values. The separate scale can make a series easier to see, but readers should be told which axis applies to it.

Final checks before sharing

Before sending the workbook or copying the chart into a report, verify that the categories and series are correct, the line uses the intended axis, and both axes have appropriate units and ranges. Read the chart title and legend as if you had not built the chart. If someone could mistake the line scale or the meaning of a percentage, add a clearer title or axis label. A well-made combo chart does more than fit two measures in one space: it makes the comparison understandable without hiding the assumptions behind it.

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.