Dual Axis Line Chart in Excel: Create and Format It

To make a dual axis line chart in Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Combo Chart > Create Custom Combo Chart. Set both series to Line, check Secondary Axis for the series that needs a different scale, and select OK. The chart will show two lines against separate vertical scales.

What a dual axis line chart shows

A dual axis line chart, also called a secondary-axis line chart, plots two data series in one chart while giving each series its own vertical value axis. The primary axis is usually on the left; the secondary axis is usually on the right. Both series share the horizontal axis, which commonly represents dates, months, or another ordered set of categories.

For example, a monthly report might compare website visits with conversion rate. Visits could range from 8,000 to 20,000, while conversion rate ranges from 2% to 5%. If both series use one vertical scale, the small percentage values may look nearly flat beside the visit counts. A second axis lets each series use a suitable range, so both trends can be seen.

The chart does not convert one measure into another or make their units equivalent. It simply draws each series according to a different scale. That distinction matters: a visual crossing or similar-looking rise in the two lines does not, by itself, prove that the measures have a meaningful relationship.

How the two axes work

Excel assigns each series to either the primary or secondary axis. Each axis has its own minimum, maximum, and interval settings. For instance, the left axis might run from 0 to 25,000 visits, while the right axis runs from 0% to 6%. The plotted heights are calculated against those separate ranges, even though the lines share the same plot area.

In a line chart, the horizontal axis generally places observations at categories such as January, February, and March. If your dates are unevenly spaced and the actual time gaps matter, a line chart may treat them as evenly spaced categories; an XY scatter chart is often more suitable for showing numerical spacing between dates or values. Check that Excel has interpreted your dates and category labels as intended before relying on the trend.

A dual axis can improve readability when the measures have different units or very different magnitudes. It can also exaggerate apparent similarities. Because changing either axis bounds changes the visual relationship, use clear axis titles and sensible scales, and explain the units rather than expecting readers to infer them.

Create the chart in Excel for Windows

Put the category labels in the first column and each series in its own column, with a descriptive heading at the top. For example, column A could contain months, column B visits, and column C conversion rate. Keep the observations aligned by row: each month should have the values that belong to that month.

Select the complete range, including the headers and category labels.
Choose Insert > Insert Combo Chart > Create Custom Combo Chart. If you do not see the combo-chart button, use Insert > Recommended Charts, open the All Charts tab, and choose Combo.
In the custom combo chart dialog, set the chart type for each series to Line.
Check Secondary Axis for the series that needs a separate scale. Usually only one series goes on the secondary axis; the other remains on the primary axis.
Select OK. Add a chart title, axis titles, and any other labels that help explain the measures.

If you already made a line chart, you can assign a series to the secondary axis without starting over. Select the line for that series, right-click it, choose Format Data Series, and under Series Options choose Secondary Axis. On a Mac, Control-click the series if a right-click is not available; the formatting pane has a similar axis choice, although ribbon placement and dialog wording can vary by Excel release. Excel for the web may present different chart-editing controls; if the custom combo options are unavailable, open the workbook in the desktop app.

Choose which series gets the secondary axis

Keep the series with the more familiar or central measure on the primary axis, and put the series with a different unit or scale on the secondary axis. That is a practical convention, not a strict rule. For a chart of revenue and units sold, for example, decide which measure readers are most likely to use as their reference, then label both axes so the assignment is unmistakable.

Before adding a second scale, check whether the chart can work with one axis. If the values are comparable and use the same unit, one axis is usually simpler. If the measures differ greatly in magnitude but share a unit, a logarithmic axis might be an option for data that are positive and suitable for logarithmic interpretation; it is not a general fix and can be unfamiliar to readers. Separate panels or indexed values may be clearer alternatives.

Avoid choosing axis bounds solely to make the lines appear to track each other. Two independently scaled series can be made to look more alike—or less alike—by adjusting their minimum and maximum values. Use bounds that are defensible for the data, disclose nonzero baselines where relevant, and do not imply that one series causes the other.

Format axes and make the chart readable

Give each vertical axis a title that includes the measure and, where useful, its unit. For example, label one axis Website visits and the other Conversion rate (%). A legend that names the series is useful, but it does not replace axis titles: the reader still needs to know which scale belongs to which line.

Format the secondary axis to match its data. A percentage series should display percentages rather than decimals, and a currency series should use an appropriate currency number format. Select the axis, open Format Axis, and adjust its number format, bounds, and major units when needed. In Windows Excel, Ctrl+1 opens the format pane for a selected chart element; on Mac, Command+1 is the corresponding shortcut in many current releases. The exact pane options depend on the selected element.

Use contrasting line colors and, if the chart may be printed in grayscale, consider different markers or dash styles as well. Keep gridlines restrained: too many gridlines can make it difficult to tell which scale a line follows. A short chart title should explain the comparison, while a subtitle or note can identify the time period, data source, or any important caveat.

For a quick addition of axis titles, select the chart and use Chart Design > Add Chart Element > Axis Titles, then choose the relevant horizontal or vertical title option. In a dual-axis chart, confirm that the secondary vertical title is present and attached to the right-hand scale. Menu labels and chart tools may vary slightly across desktop versions.

Read the result carefully

Read each line against its own axis. A point halfway up the left scale does not necessarily represent the same quantity or proportion as a point halfway up the right scale. Likewise, where two lines cross is a visual position in the shared plot area, not necessarily a point where their raw values are equal. If the measures have different units, equality may not even be meaningful.

For a practical example, imagine visits rise from 10,000 to 15,000 while conversion rate rises from 3% to 4%. A dual-axis chart can display both increases in one view, but it cannot tell you why either changed. Seasonality, marketing changes, or data-quality problems might also be involved. Use the chart to describe patterns, then examine the underlying data and context before making a causal claim.

If readers need to compare the size of changes rather than the original units, consider indexing both series to a common starting point, such as setting the first period to 100. This changes the question from “How many visits and what percentage?” to “How did each measure change relative to its starting value?” Make that transformation explicit in the labels and notes, since the chart no longer shows the original values directly.

Common problems and fixes

The second line is nearly flat. Confirm that the intended series is assigned to Secondary Axis. If it is, inspect the right axis bounds and the series values. A very large outlier can compress most observations.
The wrong series uses the right axis. Select the affected line, open Format Data Series, and change its axis assignment. Check the axis titles afterward, since moving a series can make the labels misleading.
The chart shows one line or unexpected labels. Confirm that the selected range includes the category column and both series headers, and that each column contains numeric values where expected. Use Chart Design > Select Data to review the series and category ranges.
Dates appear out of order or evenly spaced when they should not. Check that the cells contain real Excel dates and are sorted chronologically. For irregularly spaced numeric dates, consider an XY scatter chart rather than assuming a line chart represents the gaps proportionally.
The axes start or end at confusing values. Select each vertical axis and review its minimum, maximum, and major unit in Format Axis. Automatic bounds are convenient, but manually setting bounds can improve a specific comparison only if the choices remain clear and justified.

When data are updated, confirm that the chart range includes new rows. Excel tables can make chart ranges expand as rows are added, but an ordinary fixed cell range may not include later entries automatically. Review the chart after adding data, especially if new values change the axis scale or category order.

When another chart is a better choice

A dual-axis chart is not always the clearest way to compare two measures. A small-multiple layout—two aligned charts with separate vertical scales—keeps the timelines comparable without placing independent axes on one plot. It is often easier to read in a report or presentation, particularly when the scales might confuse the audience.

If both measures use the same unit and a shared scale is meaningful, a standard line chart is more direct. If the aim is to show composition, such as each category’s share of a total over time, a 100% stacked chart may answer the question better. If the aim is to compare percentage change from a baseline, an indexed line chart can make relative movement easier to compare, provided the baseline and calculation are stated.

A combo chart can also pair a line with columns—for example, monthly sales as columns and a rate as a line on a secondary axis. That is a different visual design, but the same caution applies: identify both scales and avoid implying that the measures are directly comparable. Choose the chart type based on the question and the audience, not merely on the availability of a second axis.

Frequently Asked Questions

Can I put two line series on different axes in Excel?
Yes. Create a custom combo chart, set both series to Line, and select Secondary Axis for one series. The chart will show a left and right vertical scale, with both lines sharing the same horizontal categories.

How do I add a secondary axis to an existing line chart?
Select the series you want to move, right-click it, choose Format Data Series, and select Secondary Axis under Series Options. Then add or check the right-side axis title and verify that its number format matches the data.

Can both lines use the secondary axis?
They can, but if both use the same secondary axis, they share that scale and the primary axis may be unnecessary. A common setup puts one series on the primary axis and one on the secondary axis so each can use a different range.

Why do the lines cross even though their values are different?
Each line is positioned according to its own vertical scale. A crossing means the lines occupy the same height in the plot area, not that their raw values are equal. Compare the axis labels and units, not the crossing point alone.

Is a dual-axis chart misleading?
It can be if the scales are unlabeled, chosen to suggest a relationship, or read as though both lines share one scale. Clear axis titles, sensible bounds, and a note about differing units reduce confusion. For many audiences, two aligned charts are a safer comparison.

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.