Excel Line Chart With Two Y-Axes: How to Create One

Yes. In Excel for Microsoft 365 on Windows, create a line chart, select the series that needs its own scale, right-click it, choose Format Data Series, and under Series Options select Secondary Axis. Excel places that series on a vertical axis at the right of the chart, while the other series uses the primary vertical axis on the left.

What a Two-Y-Axis Line Chart Shows

A two-y-axis chart, also called a secondary-axis chart, plots two or more data series against separate vertical scales. The horizontal axis usually represents the same dates, categories, or other shared sequence for every series. The left vertical axis is the primary axis; the right vertical axis is the secondary axis. Each scale can have its own units and range.

For example, you might chart monthly product sales in dollars alongside website visits. Sales could range from $20,000 to $80,000, while visits could range from 2,000 to 12,000. Putting both on a single scale would make at least one series appear almost flat or make the scale difficult to interpret. A secondary axis lets both lines use a readable range without converting the underlying data.

The separate scales do not make the series directly comparable in magnitude. A line’s height and steepness depend on its own axis, so two lines that overlap or cross do not necessarily have similar values or move by the same amount. Axis labels and units are essential to interpreting the chart correctly.

Prepare the Data Before Charting

Arrange the information in columns with one shared category column and a separate column for each series. Include clear headers so Excel can identify the series names. For instance, a monthly table could have Month in column A, Revenue in dollars in column B, and Visits in column C, with one row per month. Make sure the dates or categories line up: each row should describe the same period for both measures.

Check the data before inserting a chart. Numbers stored as text may not plot as expected, blank cells can create gaps, and inconsistent date entries can produce an unhelpful horizontal axis. Avoid combining subtotals with ordinary monthly values unless you intend to chart both. If a measure has a very different scale, that alone is not a reason to use a second axis; first decide whether the relationship between the measures is meaningful and whether a different chart would communicate it more clearly.

Create the Chart and Assign the Secondary Axis

These steps apply to Excel for Microsoft 365 on Windows. The simplest approach is to insert a regular line chart and then move one series to the secondary axis:

Select the full data range, including the headers and category column.
Choose Insert > Insert Line or Area Chart, then select a 2-D Line option. A line chart with markers is useful when there are only a few data points; without markers, lines can look cleaner for longer time series.
Click the line representing the series that needs a separate scale. If selecting it on the chart is difficult, click the chart, open the Format tab, and use the Current Selection list to choose the series by name.
Right-click the selected series and choose Format Data Series. In the pane, open Series Options and select Secondary Axis.
Confirm that the right-hand axis appears, then add or revise the chart title, axis titles, legend, and number formats so a reader can identify both measures.

You can also use a combo chart. Select the chart, choose Chart Design > Change Chart Type, select Combo, and set each series to Line. For the series that needs a separate scale, select its Secondary Axis checkbox, then confirm with OK. The combo dialog is especially helpful when you want different chart types for the two series, but both series can remain lines. In some Excel layouts, you can begin with Insert > Recommended Charts and choose the Combo tab; available choices depend on the data and Excel build.

On Excel for Mac, the chart and series-formatting concepts are similar, but ribbon labels and dialog placement can vary by release. Select the series and use the Format Data Series pane or dialog to choose the secondary axis. Excel for the web supports chart creation and many formatting tasks, but some advanced chart controls may be more limited; if a particular option is missing, open the workbook in the desktop app.

Format Both Axes So the Chart Is Readable

After assigning a series to the secondary axis, check both vertical scales. Excel chooses bounds and intervals automatically, and those defaults may not suit the data. Right-click an axis and choose Format Axis to set bounds, units, number formatting, and other axis options. Use a sensible minimum and maximum that include the values, and avoid implying a zero baseline when the chart’s purpose or data makes that inappropriate. For many comparisons, however, starting both axes at zero can make relative changes easier to judge. The right choice depends on what the chart is meant to show.

Label each axis with the measure and its units, such as Revenue ($) and Visits (people). If the measures are rates, include the relevant scale, such as percent. Use distinct line colors and make sure the legend names correspond to the axes. A chart title such as Monthly Revenue and Visits is more informative than a generic title like Results. If the color alone is not enough to distinguish the series, markers or different line styles can help.

Be aware that one series can be formatted as a percentage while the other is formatted as currency or a count. Axis number formatting changes how values are displayed; it does not change the source values. Similarly, changing the axis bounds changes the visual scale, not the data. If a secondary horizontal axis appears and duplicates the categories, you can select that axis and remove it or adjust its display through Chart Design > Add Chart Element > Axes. Keep the shared category labels clear and avoid displaying duplicate labels that make the chart look cluttered.

When a Secondary Axis Is a Good Choice

A second axis is useful when the chart’s purpose is to show how two measures change over the same categories or periods, and the measures have different units or substantially different ranges. A business might compare monthly revenue and customer count; a lab might compare temperature and another measured quantity over time. In both cases, the shared horizontal sequence matters, but the vertical units do not match.

Consider monthly revenue between $30,000 and $70,000 and website visits between 4,000 and 11,000. Assigning visits to the right axis can reveal whether busy months tend to coincide with higher revenue. It cannot, by itself, show that visits caused the revenue change. Other factors, such as promotions or seasonality, may affect either series. The chart is a visual comparison, not evidence of causation.

A secondary axis is usually less appropriate when the goal is to compare actual amounts, when the two series use the same units and similar ranges, or when readers may mistake the separate scales for one common scale. For example, two products’ monthly sales in dollars usually belong on the same axis if the values fit comfortably. A second axis could make a smaller series look as prominent as a much larger one simply by changing its scale.

Common Problems and How to Fix Them

The wrong line moves. Excel can select an individual point rather than the whole series. Click the line once, not an individual marker twice, or choose the series name from the Format tab’s Current Selection list before opening Format Data Series.
The right axis does not appear. Confirm that Secondary Axis is selected for the series, not for a chart element or the other series. Reopen the series-formatting pane and check Series Options.
The lines look misleadingly similar. Independent scales can make the lines occupy similar chart heights even when their values differ greatly. Label both axes prominently and explain the units; do not describe visual overlap as equality.
The chart uses the wrong categories. Check Select Data under Chart Design and verify the horizontal category labels and series ranges. Dates may be treated as text or categories if their cells are inconsistent.
The chart is crowded. Reduce unnecessary gridlines, use a concise legend, and consider whether every series is needed. Too many lines or labels make a dual-axis chart difficult to follow.
A line has gaps or unexpected zeros. Inspect blanks and formulas in the source range. Use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are plotted; available choices include gaps, zero values, or connecting data points, depending on the chart and version.

Alternatives to Consider

A two-panel chart, sometimes called small multiples, gives each measure its own chart while keeping the same time range. This avoids the problem of dual scales and can be easier to read in a report. An indexed chart is another option when the main question is how values change relative to a starting point: express each series as an index where the first period equals 100, then plot the indexed values on one axis. This compares relative movement, not original units, so label the transformation clearly.

If the measures share units and a meaningful common scale, use a single-axis line chart instead. If the objective is to examine the relationship between two numeric variables rather than how they change over time, a scatter chart may be more suitable. Choose the chart based on the question, not just because the data ranges differ.

Frequently Asked Questions

Can Excel have two y-axes on a line chart?
Yes. Assign one or more data series to the secondary vertical axis through Format Data Series > Series Options > Secondary Axis. The primary axis remains on the left and the secondary axis appears on the right.

How do I add a right-side axis in Excel?
Select the line series you want to move, open Format Data Series, and select Secondary Axis under Series Options. Excel adds the right-side vertical scale for that series.

Can both series stay as lines?
Yes. You can keep the chart as a line chart and assign one line to the secondary axis, or use Change Chart Type > Combo and set both series to Line.

Why do the lines cross when their values are different?
Each line is positioned according to its own vertical scale. A crossing means the series occupy the same relative height at that point, not that their numeric values are equal.

Can I use two axes with the same units?
Excel permits it, but it is often clearer to use one axis if the ranges allow. Two scales with the same units can confuse readers unless there is a specific, clearly explained reason for them.

Final Check Before Sharing

Before sending or publishing the chart, verify that the series are assigned to the intended axes, both axes have descriptive titles and units, and the legend matches the line colors. Look at the axis bounds and number formats, then ask whether a reader could mistake the two scales for one. If the chart’s message depends on the visual relationship between the lines, state that the axes use different scales. That small clarification helps the chart inform without overstating what the data proves.

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.