Combo Chart in Excel: How to Create, Format, and Read One

A combo chart in Excel combines two or more chart types, commonly columns for one measure and a line for another. In Excel for Microsoft 365 on Windows, select the data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign a chart type to each series, and select Secondary Axis for a series whose scale or units differ.

What a combo chart shows

A combo chart, also called a combination chart, displays multiple data series in one chart area using different visual forms. A column series can show totals while a line series shows a rate or trend. The chart shares a horizontal category axis, such as months, while each series can have its own vertical axis if needed.

The key idea is to show related measures together without pretending they have the same units. For example, a monthly sales report might use columns for revenue in dollars and a line for conversion rate in percent. The reader can see how the two measures move over time, but the values remain distinct. The line does not mean that a percentage is a dollar amount; its vertical scale communicates its own measure.

Combo charts are not limited to two series, but adding series can make the display hard to interpret. They work best when each measure has a clear purpose and the chart remains easy to read at a glance.

When a combo chart is useful

Use a combo chart when related measures benefit from a shared time or category axis but differ in unit, scale, or role. Common examples include:

Monthly revenue as columns and profit margin as a line.
Units sold as columns and inventory level as a line.
Website visits as columns and conversion rate as a line.
Actual results as columns and a target or forecast as a line.

The chart can help reveal whether two measures rise and fall together, whether one changes before the other, or when results depart from a target. It does not prove that one measure causes another. A line and columns moving in the same direction show an association in the displayed data, not an explanation for why it happened.

A combo chart is usually a poor choice when the series have no meaningful relationship, when there are many categories, or when the graph depends on several confusing scales. Separate charts or a table may be clearer in those cases.

Prepare spreadsheet data first

Put the categories in the first column and each measure in a separate adjacent column. Use one header row with clear names, and keep the values in each series consistent: do not mix percentages and whole numbers in one column, for example. A simple layout might have Month, Revenue, and Conversion rate as the three headers, followed by one row per month.

Use real numeric values for the measures. Format a rate as a percentage using Home > Number, rather than typing values such as “2.4%” as text. Similarly, store dates as dates, not as labels that only look like dates. Excel can then interpret categories and values properly and update the chart more reliably.

Check the range before charting. Blank rows can split the data selection, while totals mixed into the monthly records can create an extra, misleading category. If you have several years of monthly data, consider whether the chart should show every month or a summarized view; too many plotted points can obscure the pattern. Give the columns descriptive headers because Excel uses those headers for the legend series names.

For a report that will grow, you can turn the range into an Excel table using Insert > Table. Charts based on a table can include new rows as the table expands, though it is still sensible to check the chart range after adding fields or changing the layout.

Create a combo chart in Excel for Windows

In Excel for Microsoft 365 on Windows, make the chart from a contiguous data range that includes the headers. Then use this workflow:

Select the categories, headers, and values you want to plot.
Choose Insert > Insert Combo Chart in the Charts area of the ribbon.
Select Create Custom Combo Chart to open the chart setup dialog.
For each series, choose a chart type from the available options. A typical setup uses Clustered Column for revenue and Line for a rate.
Turn on Secondary Axis for the series that should use a separate vertical scale, if necessary.
Choose OK. Add or edit the chart title, axis titles, and legend so the meaning of each series is explicit.

If the first chart is not quite right, select it and use Chart Design > Change Chart Type to revisit the chart types and axis assignment. The Chart Design tab appears when the chart is selected. Ribbon labels can vary slightly with window width or an Office update, but the custom combo chart dialog is the relevant control for assigning types and a secondary axis.

On Excel for Mac, select the data and use the Insert tab to create a combo chart where that chart option is available; you can also select an existing chart and use Chart Design > Change Chart Type to adjust it. Ribbon placement and wording can differ between Mac releases. Excel for the web has a different, more limited chart-editing interface, so use the desktop application if you cannot find a control for custom series types or secondary-axis settings.

Choose chart types and decide on a second axis

Choose a chart form that matches the job of each series. Columns are useful for comparing discrete categories, such as monthly totals. A line is useful for showing a continuous trend across ordered categories, especially time. Avoid using different chart types just for decoration: the visual distinction should make the series easier to understand.

A secondary axis is appropriate when one series has a very different scale or unit and would be difficult to see against the primary axis. In the revenue-and-conversion example, revenue might range from tens of thousands of dollars while the rate stays between 0% and 5%. Plotting both against one scale would flatten the percentage series near zero. Put the percentage on the secondary axis and label that axis as a percentage.

A second axis is not automatically better. Its scale can change the apparent visual relationship between the line and columns: a line may look steep or may seem to track the columns closely depending on the chosen bounds. This can make a chart misleading even when every value is accurate. Label both axes, use appropriate minimum and maximum bounds when needed, and avoid suggesting that the heights or slopes of unlike measures are directly comparable.

If two series use the same unit and have similar ranges, a single axis may be clearer. If the series use different units but the second scale would distract from the message, separate charts may be more honest and readable.

Format the chart so readers can interpret it

Start with a title that says what is measured and over what period, such as “Monthly Revenue and Conversion Rate.” Add axis titles if the units are not obvious from the series names. A secondary vertical axis needs especially clear labeling, such as “Conversion rate (%)”; the fact that it sits on the right side is not enough explanation.

Keep the legend names short but meaningful. Use contrasting colors for the column and line series, and make the line thick enough to see without overwhelming the columns. Markers can help readers locate individual monthly values, but too many large markers can clutter the display. Avoid relying on color alone where the chart may be printed in grayscale or viewed by someone with color-vision differences; distinct line and column forms provide another cue.

Use data labels selectively. Labels on every column and every line point can crowd a chart, especially over a long period. Labels are more useful for a few important points, or when readers need exact values and there are only a few categories. Keep gridlines light and remove decorative effects that compete with the data. A clear chart should make the main comparison visible without requiring the reader to decode unnecessary styling.

Common combo-chart problems

If a series is missing, first check whether its cells were included in the selected range. Select the chart and use Chart Design > Select Data to inspect the plotted series and category labels. A header accidentally omitted from the selection can also leave the legend with a generic name such as Series 1.

If the line looks almost flat, its values may be small relative to the primary-axis series. In the custom combo settings, assign it to the secondary axis, then confirm that the new axis is labeled and its scale is sensible. If the line appears to use the wrong categories, verify that the first column contains the intended labels and that the chart is reading rows and columns in the correct direction. Chart Design > Switch Row/Column can help when Excel has interpreted the arrangement differently than intended.

If percentages appear as 2.4 rather than 2.4%, check the source cells’ number format and the axis number format. If the data are stored as text, changing the format alone will not convert them into numeric values. Also investigate blank cells and error values; they can create gaps or unexpected chart behavior. Do not solve a confusing chart simply by changing axis bounds until the result looks dramatic: inspect the data and explain any nonzero baseline or restricted range.

Combo chart compared with other chart choices

A regular column chart is often best for comparing one measure across categories. A line chart is generally better for showing a trend over time. A combo chart adds value when the same categories matter for two related measures and the different chart forms help distinguish them.

A secondary axis is not the same as a second chart. It places a second scale inside the same plot area, which saves space and aligns categories, but it can invite misleading visual comparisons. Two separate charts use more room but make each scale easier to understand independently. A table is preferable when exact values matter more than spotting a pattern, and small multiples—several similar charts with separate panels—can be useful when comparing many groups without piling them into one crowded figure.

In Google Sheets, a similar result can be made by choosing a combo chart in the chart editor, but the controls and workflow differ from Excel. If a workbook is shared across spreadsheet programs, check the chart after opening it elsewhere: chart formatting and editing options may not transfer identically.

Frequently Asked Questions

What is a combo chart in a spreadsheet?
A combo chart combines different chart types, such as columns and a line, in one chart. It lets related data series share categories while remaining visually distinct, and it can use a secondary axis when the series have different scales.

How do I add a secondary axis in Excel?
Select the data and open Insert > Insert Combo Chart > Create Custom Combo Chart. Choose a chart type for each series and check Secondary Axis for the series that needs its own scale. Label that axis with its unit so readers can tell what it represents.

Can I change an existing Excel chart into a combo chart?
Yes. Select the chart, choose Chart Design > Change Chart Type, and select the combo chart options. Assign a chart type to each series and decide whether any series needs a secondary axis. Review the title, legend, and axes after applying the change.

Why is one series not visible in my combo chart?
It may be missing from the selected data range, plotted against a scale that makes it appear flat, or stored as text rather than numbers. Check the chart’s data source and series settings, then consider a secondary axis if the values have a very different scale.

Should every combo chart use a secondary axis?
No. Use one only when a series is hard to read on the primary scale and the separate scale can be labeled clearly. A second axis can change the perceived relationship between series, so a single-axis chart or two separate charts may communicate the data more fairly.

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.