Dual Axis Combo Chart in Excel: Create and Format It

In Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, assign a chart type to each series, and check Secondary Axis for the series that needs a different scale. A dual-axis combo chart combines chart types—often columns and a line—and displays one series against a second vertical scale.

What a dual-axis combo chart shows

A standard chart plots its data series against one value axis. That works well when series use comparable units and ranges, but it can make one series hard to read when its values are much smaller or larger than another series. A combo chart lets you use different chart types for different series; adding a secondary axis gives one or more series a separate value scale.

For example, monthly revenue might range from $80,000 to $150,000, while gross margin is between 18% and 30%. If both series use the same value axis, the margin values may be compressed near the bottom of the chart. Plotting revenue as columns on the primary axis and gross margin as a line on a secondary axis makes both series visible. The shared horizontal axis still shows the months.

The secondary axis is usually drawn on the right side of the chart, while the primary value axis is on the left. Both axes represent values, but they have different scales and units. That distinction is useful, but it also means the visual height of a point on one series cannot be compared directly with the height of a point on the other.

When a second axis is useful

Use a secondary axis when two meaningful data series share the same categories or time periods but differ substantially in units or scale. The axis should solve a genuine readability problem, not simply make a chart look more dramatic.

Different units: revenue in dollars and margin as a percentage, or temperature and rainfall.
Different magnitudes: units sold in the thousands alongside a small rate or index.
A useful visual pairing: columns can show totals while a line shows a rate, target, or trend across the same periods.

A second axis may not be the right choice if readers need to compare exact values between series. In that case, use separate charts, a table, or a normalized view. A second axis is also unnecessary just because two series use different colors: if both are in the same unit and can share a readable scale, one axis is usually clearer.

Prepare the data before inserting the chart

Put the categories in the first column and each data series in its own column, with a clear header for every column. Keep the rows in the order you want them to appear, such as months from January to December. Avoid blank rows or merged cells within the range; those can make Excel guess the chart’s series or categories incorrectly.

For the revenue-and-margin example, the data might look like this. The figures are illustrative, and the margin values should be entered as percentages, such as 22% rather than 22 if the intended value is twenty-two percent.

Month	Revenue	Gross margin
January	$92,000	22%
February	$108,000	24%
March	$101,000	21%
April	$126,000	27%
May	$139,000	25%
June	$148,000	29%

Use consistent units within each series. If revenue is recorded in dollars in some rows and thousands of dollars in others, a chart cannot correct that inconsistency. Also check whether percentage data are stored as percentages or whole numbers before choosing the axis format. Excel’s percentage format displays a stored value of 0.22 as 22%; a stored value of 22 would display as 2,200% if formatted as a percentage.

Create the chart in Excel for Microsoft 365

On Windows, select the complete data range, including the headers and category labels. Then use the combo-chart option on the Insert tab:

Select Insert > Insert Combo Chart > Create Custom Combo Chart.
In the chart dialog, choose a chart type for each series. For the example, choose a clustered column for Revenue and a line for Gross margin.
In the Secondary Axis column, check the box for Gross margin. Leave Revenue on the primary axis.
Select OK. Excel inserts the chart with the months along the horizontal axis and separate vertical scales for the two series.

If you have already made a chart, select it and choose Chart Design > Change Chart Type > Combo. Set the type and secondary-axis option for each series in the dialog, then confirm. The exact arrangement of ribbon controls can shift with window size, but the chart-type and axis choices are in the combo chart settings.

Excel may offer a suggested combo chart, but review its series assignments rather than accepting it automatically. The series with a different unit or a much smaller scale is often the one to place on the secondary axis, but the right choice depends on what the chart is meant to communicate.

Format the axes and make the chart readable

After insertion, give the chart a descriptive title that identifies the subject and period. Add axis titles so readers know which scale represents which measure. With the chart selected, use Chart Design > Add Chart Element > Axis Titles, then select the relevant primary or secondary vertical axis title. Label the left axis Revenue ($) and the right axis Gross margin (%) in the example. A legend helps identify series, but it does not replace axis titles.

To change an axis’s number format or bounds, right-click the axis and choose Format Axis. In the Format Axis pane, review the axis options and number settings. For revenue, a currency format or a clear unit such as dollars in thousands can reduce clutter. For margin, use a percentage format. If you set minimum or maximum bounds manually, choose values that include the data and do not hide important variation.

Use color and line styling to distinguish the series without making the chart hard to read. A line with visible markers can help readers follow monthly margin, while columns can make revenue totals easy to compare. Avoid using similar colors for both series, and keep the legend order and series names clear. If data labels add clutter, label only selected points or rely on the axes and gridlines.

On Excel for Mac, combo charts and axis formatting are also available, although ribbon layout and dialog labels can vary by version. In Excel for the web, chart-editing controls may be more limited or arranged differently; if the combo or secondary-axis options are missing, open the workbook in the desktop app.

Choose sensible scales and avoid misleading comparisons

The most important limitation of a dual-axis chart is that each vertical axis has its own range. Excel may automatically choose minimum and maximum bounds that fit each series. As a result, the line and columns can appear to rise or fall together even when their actual changes are not closely related. Changing either axis range can change the apparent visual relationship without changing any underlying data.

For the example, the left axis might cover the revenue range and the right axis might show gross margin as a percentage. Do not set the margin axis to an arbitrary range just to make its line cross the tops of the columns. A zero baseline is often informative for columns because column length visually encodes magnitude. For a line, a narrower range can make small changes easier to see, but it should be clearly labeled and not imply that a modest movement is enormous.

Before sharing the chart, check the scales with these questions:

Are both axes labeled with their units and placed next to the correct series?
Do the chosen bounds include every relevant data point?
Would a reader mistake the apparent alignment of the line and columns for a direct value comparison?
Would two small charts, or one chart with a common scale, communicate the result more honestly?

A dual axis shows two measures together; it does not establish that one causes the other. If the purpose is to show whether two series move together, consider a scatter chart when both measures are numeric and the relationship itself is the focus. If the purpose is to compare trends over time, small charts with clearly labeled individual scales can be easier to interpret.

Common problems and practical fixes

The secondary-axis checkbox is unavailable or the chart looks wrong. Confirm that the chart is a combo chart and that the data range includes at least two separate series. In the custom combo settings, choose an appropriate chart type for each series and assign the secondary axis to the intended one. Some chart types are not appropriate for every combination; switching a series to a line or column type can make the available options clearer.

The line is flat or nearly invisible. Check whether it is plotted against the primary axis by mistake. If it uses a much smaller range than the column series, assign it to the secondary axis. Also verify the stored values and number format: a margin entered as 22 instead of 22% can distort the scale substantially.

The wrong labels appear along the bottom. Reopen the chart’s data settings and check the category range and series orientation. A header or category column may have been excluded, or Excel may have interpreted rows as series when columns were intended. Correcting the source range is usually preferable to manually relabeling each point.

The chart suggests a stronger relationship than the data supports. Review both axis bounds and explain the units in axis titles. If the visual comparison remains confusing, use separate charts or a shared-scale alternative. Do not rely on color alone to tell the reader which scale belongs to which series.

Dual-axis chart versus other chart choices

A combo chart is a chart-type decision as well as an axis decision: the columns-and-line pairing can distinguish totals from rates, while the second scale accommodates their different units. A regular single-axis chart is simpler and is generally preferable when both series are comparable. A 100% stacked chart answers a different question: it shows parts as shares of a total rather than preserving the original totals.

Two separate charts are often a better alternative when the measures need different scales but readers might confuse them when placed together. A scatter chart is better for examining the relationship between two numeric variables without categories such as months. A table is useful when exact values matter more than an at-a-glance pattern. Choose the form that makes the intended comparison easiest to understand, not the one that fits the most data into one visual.

Frequently Asked Questions

How do I add a secondary axis in Excel?
Select the chart, choose Chart Design > Change Chart Type > Combo, and check Secondary Axis for the series that needs its own scale. You can also select the data first and use Insert > Insert Combo Chart > Create Custom Combo Chart.

Which series should go on the secondary axis?
Put the series with the different unit or scale on the secondary axis, then label that axis clearly. There is no universal rule that the smaller series must use it; choose based on the values, units, and comparison the chart is intended to show.

Can a dual-axis chart have two lines?
Yes. A combo chart can use a line for each series and assign one line to the secondary axis. That is useful when the measures have different units, but make the axis titles and series identities especially clear.

Why does my secondary axis appear on the right?
Excel normally places the secondary vertical value axis on the right side of the chart and the primary vertical value axis on the left. The secondary scale belongs to the series assigned to it, even if its line or columns are drawn across the same plot area.

Are dual-axis charts misleading?
They can be if the separate scales are hidden, chosen carelessly, or treated as directly comparable. Label both axes, use defensible bounds, and consider separate charts if the shared display could lead readers to infer a relationship the data do not establish.

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.