Yes. In Excel for Microsoft 365 on Windows, select the data series you want to scale separately, right-click it, choose Format Data Series, and under Series Options select Secondary Axis. Excel adds a right-side vertical axis; with a scatter chart, check whether a secondary horizontal axis is also needed to represent that series’ X values correctly.
When a second Y-axis helps
A secondary Y-axis lets two data series with different numerical ranges or units share one chart area. For example, you might plot distance traveled in kilometers and temperature in degrees on the same chart, even though their values occupy very different ranges. The primary Y-axis is usually on the left, and the secondary Y-axis is on the right.
Scatter charts are useful here because each point is positioned using an X value and a Y value. They are often used to show relationships between measurements, such as engine speed and fuel use, or time and sensor output. Assigning one series to the right-hand axis changes the scale used for its vertical positions; it does not convert the values or make the series mathematically comparable.
A second axis is most helpful when both measures matter and you want to see how their patterns line up across the chart. It is not automatically the best choice just because one series looks flat. First check whether the series uses the intended units, whether the data ranges are reasonable, and whether a different chart or separate panels would communicate the comparison more clearly.
Add a second vertical axis in Excel
These steps apply to Excel for Microsoft 365 on Windows. Start with an existing XY (Scatter) chart containing at least two data series. If the chart contains only one series, add another series before assigning it to a secondary axis.
- Click the chart, then click a point in the series that should use the second scale. Click again if necessary to select the whole series rather than just one point. The selected series is usually highlighted.
- Right-click the selected series and choose Format Data Series. The Format Data Series pane opens on the right.
- In the pane, choose Series Options, represented by the column-chart icon if the pane displays icons.
- Under Plot Series On, select Secondary Axis. Excel moves that series to a scale shown on the right side of the chart.
- Check the chart for a secondary horizontal axis at the top. If it is absent and the scatter series needs its own X scale, add it through Chart Design > Add Chart Element > Axes > Secondary Horizontal.
- Add clear axis titles and verify that the plotted points still make sense. Use Chart Design > Add Chart Element > Axis Titles to insert titles, then click each placeholder to edit it.
You can also select the series and use the contextual Format tab, then choose Format Selection to open its formatting pane. The right-click route is generally the quickest. To return the series to the left-side scale, reopen Format Data Series and choose Primary Axis.
Make sure the chart contains the right series
Before changing axes, confirm that Excel has interpreted the source data as the series you intended. A common layout has one X column and one or more Y columns: the first column contains X values, while each following column contains a separate Y series. For series with different X values, each series needs its own X and Y ranges.
To inspect or correct the ranges, click the chart and choose Chart Design > Select Data. In the Select Data Source dialog, select a series and choose Edit. Check the Series X values and Series Y values ranges, then repeat for the other series. Scatter charts use numerical X values; if dates or numbers were imported as text, Excel may not plot them as expected.
If a series is missing, choose Add in the Select Data Source dialog and specify its name and X and Y ranges. You can also create a scatter chart from selected data using Insert > Insert Scatter (X, Y) or Bubble Chart. For a reliable result, check each series range rather than assuming Excel has paired every column correctly.
How the two scales work
The primary and secondary axes are separate scales. Excel independently assigns minimum and maximum bounds and tick spacing to each vertical axis, often using automatic settings. A value’s height on the chart therefore depends on the scale assigned to its series. The same apparent height does not mean two values are equal, and matching-looking lines do not prove a meaningful relationship.
For example, imagine a chart of monthly production and defect rate. Production might range from 0 to 10,000 units, while defect rate ranges from 0% to 5%. Putting both on one vertical scale can make the percentage series nearly invisible. A secondary axis allows each series to use a legible range, but readers must be able to tell which scale belongs to which series.
Excel may choose axis bounds that emphasize visual movement. If a line appears to rise sharply, inspect the axis minimum and maximum before interpreting the size of the change. For a more transparent comparison, keep a zero baseline where it is appropriate, state units in the axis titles, and avoid selecting bounds solely to make two series appear to track one another.
Check the horizontal axis on a scatter chart
Unlike a line chart with category positions, an XY scatter chart places points according to numerical X values. A series assigned to a secondary vertical axis may also use a secondary horizontal axis. This matters when its X values have a different range or meaning from the primary series. Excel can display that secondary X axis along the top of the plot area.
If all series share the same X values and units, a shared horizontal scale is usually easier to read. If they have different X ranges, verify whether Excel has created a secondary horizontal axis and whether its bounds suit the data. To show or hide chart axes, use Chart Design > Add Chart Element > Axes and choose the relevant primary or secondary axis option. Available axis choices depend on the chart type and which axes are already present.
When a second horizontal scale is visible, label it clearly. Otherwise, a reader may assume the top and bottom scales represent the same values. If the series have fundamentally different X variables, putting them in separate charts may be less confusing than showing two horizontal scales in one plot.
Format and label the axes clearly
A dual-axis chart needs more visual guidance than a chart with one scale. Use distinct series colors, and make the corresponding axis labels, tick labels, and axis title visually consistent where possible. For instance, a blue production line should be easy to associate with the blue left axis, while an orange percentage line should correspond to the orange right axis.
- Give each axis a title that names the measure and its units, such as Production (units) and Defect rate (%).
- Use a legend with descriptive series names rather than generic labels such as Series 1 and Series 2.
- Keep the chart title focused on the comparison, and explain any non-obvious measurement or time period in a note.
- Reduce decorative effects and avoid too many gridlines, markers, or series that compete for attention.
To format an axis, click its tick labels or axis line, right-click, and choose Format Axis. The pane lets you adjust bounds, units, number format, tick marks, and label placement where those settings apply. Percentage data should use a percentage number format; otherwise values may appear as decimals such as 0.04 rather than 4%.
Common problems and how to fix them
The wrong series is selected. Clicking near a point can select an individual data point, a gridline, or the plot area. Click a point in the desired series, check that the whole series is selected, and then open Format Data Series. If selection is difficult, use the chart’s Format tab and the Current Selection list to choose the series by name.
The second axis option is unavailable. Confirm that a data series, rather than the chart area or an axis, is selected. Some chart types and chart elements offer different options. For a scatter chart, use the XY scatter type and select an actual series before opening its formatting pane.
The series seems to disappear or become a flat line. The automatic bounds may not be useful, or the series may have been assigned the wrong data range. Check its X and Y ranges in Select Data, then use Format Axis to inspect the secondary scale’s bounds. Do not adjust bounds without considering whether the resulting visual comparison could mislead.
The points move after adding the axis. A secondary horizontal scale can change the X positions as well as the vertical scale. Compare the primary and secondary X-axis ranges and confirm the series uses the intended X values. If the points should align by a shared X measure, make sure the series ranges and axis settings support that comparison.
Labels or units are confusing. Add axis titles, format percentages and dates appropriately, and use the legend to identify each series. A right axis without a title is not self-explanatory, especially when both series have similar colors or the chart is printed in grayscale.
When to use a secondary axis—and when not to
Use a second Y-axis when two related measures need to be shown together, have different units or ranges, and readers need to compare their patterns over a shared context. A familiar example is a physical measurement paired with a rate. State the units and make the axis-to-series relationship unmistakable.
A secondary axis can also create a false impression of correlation. Because each scale can be adjusted independently, two unrelated series can be made to look as though they rise and fall together. It is especially risky when the scales have no meaningful shared reference point or when the chart’s purpose is to compare magnitudes directly.
Consider alternatives when the dual scale would be difficult to explain:
- Use two vertically aligned charts with the same X-axis range, so patterns can be compared without merging scales.
- Use separate charts when the measures have different X variables or represent unrelated questions.
- Use a normalized index only when comparing relative change is the genuine goal, and explain the baseline used.
- Use a table alongside a chart if precise values matter more than visual pattern.
Excel on Mac and the web
The core method is similar in Excel for Microsoft 365 on Mac: select the series, open Format Data Series, and choose Secondary Axis under Series Options. Ribbon placement and pane appearance can differ from Windows, so the right-click command or chart formatting pane may be the most direct route. The chart’s Chart Design controls provide axis and title options, though exact layout can vary by update.
Excel for the web supports many chart-editing tasks, but some detailed chart-formatting controls may be more limited or arranged differently than in the Windows desktop app. If you cannot find a secondary-axis setting or need precise bounds and formatting, open the workbook in desktop Excel. Avoid relying on a Windows keyboard shortcut for these steps; the chart and pane controls are accessible from the ribbon and context menu, and shortcuts can differ by operating system.
Frequently Asked Questions
Can an Excel scatter plot have two Y-axes?
Yes. Select one data series, open Format Data Series, and choose Secondary Axis. The chart can then show a primary vertical scale on the left and a secondary vertical scale on the right.
How do I add a second series to a scatter chart?
Select the chart and choose Chart Design > Select Data > Add. Enter the series name and its X and Y value ranges. After it appears, select that series and assign it to the secondary axis if needed.
Why does my scatter chart show an axis at the top?
That is likely the secondary horizontal axis. Scatter charts use numerical X values, and a series on a secondary axis may have its own horizontal scale. Check its title and bounds so readers know what the top scale represents.
Can I use a secondary axis if the data has different units?
Yes, that is a common reason to use one. Label both axes with the measure and units, and remember that independently scaled axes do not make the underlying quantities directly comparable.
How do I remove the second Y-axis?
Select the series using the secondary scale, open Format Data Series, and choose Primary Axis. You can also select the secondary axis itself and delete it, but moving the series back to the primary axis is usually the clearer way to restore the chart setup.
Related
- Excel Protect Sheet but Allow Grouping: What Works
- Excel: Protect a Sheet but Keep Slicers Usable for Users
- Excel Protect Sheet but Allow Data Refresh?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Payment Chart: Build a Loan Schedule and GraphAn Excel payment chart is usually a loan amortization schedule paired with a graph showing how payments are…
- Excel Pivot Chart Axis Labels: How to Rotate Them EasilyTo rotate category-axis labels in an Excel PivotChart, select the labels, right-click and choose Format Axis, then open…
- How to Make a Pie Graph in Google Sheets: A Clear GuideTo make a pie graph in Google Sheets, put each category in one column and its numeric value…
- Excel Pivot Table Unique Values: Count or List ThemTo list unique values in Excel, put the field in a PivotTable’s Rows area; repeated labels appear once.…
- Excel Pivot Tables: How They Work and When to Use ThemAn Excel PivotTable is a tool for summarizing and exploring a larger list of data without changing the…
- Excel Pivot Table Filter Not Working? Fixes That HelpIf an Excel PivotTable filter is not working, first refresh the PivotTable and check that its source data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.