Combo Chart in Excel: How to Create and Format One

A combo chart in Excel combines two or more chart types in one chart, most often columns and a line. In Microsoft 365 for Windows, select your data, then choose Insert > Recommended Charts > All Charts > Combo, assign a chart type to each series, and turn on Secondary Axis for a series whose values use a different scale.

What a Combo Chart Means

A combo chart, also called a combination chart, overlays different visual forms so related data series can be read together. For example, columns can show monthly sales while a line shows the profit margin for those same months. The categories share a horizontal axis, but the series do not have to use the same chart type or vertical scale.

In Excel, a combo chart is not simply two charts placed next to each other. It is one chart area with series that can be configured individually. A column series can use the primary vertical axis while a line series uses a secondary vertical axis on the right. The secondary axis has its own scale; it does not convert one series into another unit or change the underlying cell values.

The familiar column-and-line design is only one option. Depending on the data and chart settings, Excel can combine types such as clustered columns, lines, and areas. The available choices depend on the chart and Excel version. The key idea is to use different visual encodings when they make the relationship between the measures easier to understand.

When a Combo Chart Is Useful

Use a combo chart when you want to compare measures that belong to the same categories but differ in scale, unit, or role. It is particularly useful when the relationship matters more than showing each measure in a separate chart. A common example is monthly revenue and gross margin: revenue is an amount of money, while margin is a percentage.

Actuals and targets: columns can show actual monthly results and a line can mark the target for each month.
Volume and rate: columns can show orders or visitors while a line shows a conversion rate.
Sales and margin: columns can represent sales revenue while a line shows gross margin percentage.
Production and capacity: columns can show output and a line can show a capacity threshold, provided the units and scales are explained.

It is not automatically the best choice whenever a table has several columns. If all series use the same unit and scale, a clustered column chart may be easier to compare. If the measures have unrelated categories or no meaningful relationship, separate charts can be clearer than forcing them into one view.

Prepare the Data Before Charting

Good chart structure makes Excel’s series assignment more predictable. Put the category labels in the first column and give every series a descriptive heading in the first row. Use one row per category, such as one row per month, and keep each series in its own column. Avoid merged cells, blank rows inside the data, and explanatory notes mixed into the table.

For example, a monthly report might have columns headed Month, Revenue, and Gross Margin, with twelve month rows below them. Revenue values should be numeric currency amounts, and margin values should be numeric percentages formatted as percentages. A value stored as text may not chart as expected, so check the cell values if a series appears missing or is treated as categories.

Use consistent categories across the series. If one series has January through December while another is missing months, Excel may leave gaps or align values in ways that do not match the intended comparison. Decide how missing data should appear before charting; a blank, zero, and a formula returning an empty string can be displayed differently depending on chart settings.

For dates, use real Excel date values rather than text that merely looks like a date. This helps Excel recognize the horizontal axis as dates and space them in chronological order. If the labels are category names rather than dates, text labels are appropriate.

Create a Combo Chart in Excel

These steps apply to Excel for Microsoft 365 on Windows. The wording and arrangement may vary slightly in other builds, but the chart configuration is similar in the desktop app.

Select the complete data range, including the column headings and category labels.
Choose Insert > Recommended Charts, then open the All Charts tab in the dialog.
Select Combo. Excel displays available combinations and a list of the data series.
For each series, choose the chart type that communicates its role. For a typical report, set the amount series to Clustered Column and the rate series to Line.
For the series that needs its own scale, select its Secondary Axis checkbox. This is often appropriate for a percentage series paired with a large currency amount.
Check the preview and confirm the category labels and series are assigned correctly, then select OK.

If you already have a chart, select it and use Chart Design > Change Chart Type, then choose Combo. This is also the route to revise a combination after noticing, for example, that the percentage line is difficult to see. On Mac, the chart tools and dialog layout can differ, but use the chart design or chart type controls and look for the Combo category. In Excel for the web, chart options can vary by build; if the needed combo controls are not available, open the workbook in the desktop app.

Choose Series Types and Axes Carefully

Choose a chart type based on what each series represents, not merely on visual variety. Columns work well for comparing values across discrete categories. A line is a natural choice for a continuous sequence such as months, especially when readers need to notice direction or turning points. A line connecting unrelated categories can imply a continuity that the data does not have.

A secondary axis is useful when two series have very different numeric ranges or units, such as revenue in thousands and margin in percentages. Without separate scales, a small percentage series may look almost flat beside a large currency series. With a secondary axis, both series can be visible, but the reader must be able to tell which scale belongs to which line or columns.

Label both vertical axes with units, such as Revenue ($) and Gross margin (%), and keep the axis titles close to their respective scales. Do not assume that readers will infer the units from the legend. A secondary axis can also make a relationship appear stronger or weaker depending on the selected minimum and maximum values. Use sensible bounds, explain the scales, and avoid adjusting them just to exaggerate a trend.

For a target line, consider whether the target changes by category. A constant target may be better shown as a reference line or a series containing the same target value for every category. If the target varies, include its values in the data table and use a line series so the plotted target is explicit.

Format the Chart for Readability

Once the chart exists, select it to reveal the chart tools. Use Chart Design > Add Chart Element to add items such as axis titles, data labels, or a legend. The exact choices available depend on the selected chart type. Give the chart a specific title, such as “Monthly Revenue and Gross Margin,” rather than a generic label like “Chart Title.”

Make the series easy to distinguish in grayscale as well as in color. A solid line with markers can remain recognizable when printed, while columns can use a contrasting fill. Avoid using many bright colors for a chart with only two series, and do not let the line disappear behind wide columns. If necessary, use Format Data Series to adjust line width, markers, or column gap width.

Data labels can help when there are only a few categories, but labels on every point in a crowded monthly chart may obscure the information. A useful compromise is to label the line or the final data point only, if that serves the story. Keep number formats readable: currency values should use an appropriate currency or abbreviated format, while percentages should display a sensible number of decimal places.

Also check the legend order and category labels. A concise legend name such as “Gross margin” is more helpful than an internal column heading like “GM_pct.” If the chart has many months, angled labels may become hard to read; a wider chart, fewer displayed labels, or a shorter time range can improve clarity.

Common Problems and How to Fix Them

The line looks flat: its values may be small compared with the column values. In Chart Design > Change Chart Type > Combo, enable the secondary axis for that series if the difference in scale justifies it.
The wrong series is plotted as a line: reopen the Combo settings and check the chart type shown beside each series name. Excel may make an unsuitable automatic choice.
Months appear in the wrong order: sort the source data chronologically and confirm that month entries are real dates or consistently ordered category labels.
A series is missing or shows unexpected gaps: inspect the source range for text-formatted numbers, blank cells, or a selection that excluded a column. Also check how the chart handles empty cells.
The chart has confusing scales: add clear axis titles and review the bounds on both vertical axes. A secondary axis is not a substitute for explaining measurement units.
The chart is visually crowded: remove unnecessary gridlines or labels, shorten the time range, or split the measures into separate charts.

A frequent misconception is that placing one series on a secondary axis makes it directly comparable in magnitude to the primary-axis series. It does not. The axes may have different units and numeric ranges. The chart lets readers compare patterns across categories, but the two series should not be treated as though equal visual heights mean equal quantities.

Combo Charts Compared With Alternatives

A clustered column chart is usually clearer when every series measures the same thing in the same unit, such as sales for three product lines. It makes side-by-side comparisons straightforward and avoids the interpretive burden of a second scale. A line chart is often better when the focus is change over time and several series share a common unit.

Separate charts are a strong alternative when one combined view feels crowded, when the categories differ, or when readers need to inspect precise values. A dashboard can place two aligned charts together and give each a properly scaled axis. This preserves context without suggesting that unrelated measurements are directly equivalent.

A combo chart earns its place when the shared categories help tell a useful story and the chart remains understandable with clear labels. Before sharing it, ask whether a reader can identify what each series measures, which scale applies, and what comparison the chart is meant to support. If any answer is unclear, revise the labels or choose a simpler design.

Frequently Asked Questions

What is a combo chart in Excel?
A combo chart displays two or more data series with different chart types in one chart. A common example uses columns for sales and a line for a percentage or target.

How do I add a secondary axis to a combo chart?
Select the chart, choose Chart Design > Change Chart Type, select Combo, and check Secondary Axis beside the series that needs its own scale. Add axis titles so readers know what each scale represents.

Can I combine a line and a column chart?
Yes. Choose the Combo chart option and assign a column type to one series and a line type to another. You can decide separately whether either series uses the secondary axis.

Why is my line invisible in an Excel combo chart?
The line may be compressed by a much larger series on the same axis, or it may have a low-contrast style. Check the Combo settings, consider a secondary axis when appropriate, and format the line so it stands out.

Should I always use a secondary axis for percentages?
No. Use one when the percentage series cannot be read clearly on the primary scale, and label both axes. If the chart becomes misleading or difficult to interpret, use separate charts instead.

Can Excel create a combo chart automatically?
Excel can suggest charts based on selected data, but its recommendation may not match your intended message. Choose Combo and review the chart type and axis assignment for every series before relying on the result.

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.