Yes. In Excel for Microsoft 365 on Windows, select the scatter-plot data series you want to move, right-click it, choose Format Data Series, then under Series Options choose Secondary Axis. Excel adds a second vertical scale so series with different units or ranges can share one chart.
Why use a secondary axis in a scatter plot?
A scatter plot (also called an XY chart) positions points using numeric X and Y values. A secondary Y-axis is useful when two sets of Y values are on very different scales, or when they measure different things. For example, a chart might show a machine’s temperature in degrees and its vibration level in millimetres per second as both change over time. Putting both on one left-hand scale could make the smaller-valued series appear almost flat.
The secondary axis gives the selected series its own vertical scale, usually displayed on the chart’s right side. This can make the shape and timing of the two series easier to inspect. It does not convert one unit into another, change the underlying data, or establish that the variables are related. The chart is still plotting the values you supplied; it is simply using two vertical scales.
A secondary axis is most helpful when you need to compare patterns across a shared X range. If you need readers to compare exact magnitudes, a secondary axis may make that harder: a value’s visual height depends on the scale assigned to its series.
How to add a secondary Y-axis
First, make sure the chart is an XY scatter chart and that each series has the intended X and Y values. Then move the series that needs its own scale:
- Click the chart, then click a point in the series you want to move. One click on a point should select the whole series; clicking again may select only that individual point.
- Right-click the selected series and choose Format Data Series. The formatting pane opens.
- In the pane, select Series Options, then choose Secondary Axis under Plot Series On.
- Check that the new vertical axis appears on the right. If the axis is absent, select the series again and check the Plot Series On setting.
You can also select a series through Chart Format > Current Selection, using the chart-element list when points are difficult to click. In some Excel layouts, the contextual chart tabs appear as Chart Design and Format after you select the chart. The formatting-pane method is generally the clearest because it lets you choose the series explicitly.
On Excel for Mac, select the series, Control-click it, choose Format Data Series, and set the series to Secondary Axis in Series Options. Excel for the web may not expose all the same chart-formatting controls; if the option is missing, open the workbook in the desktop app.
Format and label the two vertical scales
Once the axis is present, click its labels or axis line and choose Format Axis. In the pane, you can set bounds, units, number format, tick marks, and label position. Excel often chooses bounds automatically, but automatic scaling can make two series look more similar or more different than expected. For a deliberate comparison, choose sensible minimum and maximum bounds and keep the decision visible to readers.
For example, suppose the left axis shows temperature from 0 to 100 °C and the right axis shows vibration from 0 to 5 mm/s. The scales are not interchangeable, even if a point on each series appears at the same height. A reader should be able to identify which scale belongs to which series. Add axis titles using Chart Design > Add Chart Element > Axis Titles, then label the primary vertical axis and secondary vertical axis with their units.
Formatting helps distinguish series too. Use clearly different marker shapes, colors, or line styles, and keep the legend. Avoid relying on color alone if the chart may be printed in grayscale or viewed by someone with color-vision differences. A descriptive chart title and axis titles make the setup easier to understand without requiring readers to infer the units.
What happens to the horizontal axis?
Scatter charts differ from line charts because every series can have its own numeric X values. When you put a scatter series on a secondary axis, Excel may also show a secondary horizontal axis, often along the top. This is not a second Y-axis: it is the X scale associated with the secondary-axis series.
If both series use the same X values and the top scale adds no useful information, you can hide the secondary horizontal axis. Select the chart and use Chart Design > Add Chart Element > Axes to show or remove the secondary horizontal axis, or select the axis itself and delete it. Removing its display does not change the series’ data. If the series use different X ranges, keep the relevant scale visible or make clear which X values each series uses; otherwise, the plotted positions can be misread.
When the two series share X values, confirm that both are aligned as intended. The chart may still use separate axis settings, so check the horizontal bounds and units if the points appear shifted. Avoid assuming that matching labels at a glance guarantee identical axis limits.
When a secondary axis is a good choice
Use a second scale when the same chart needs to show related series over a common X dimension, but their Y units or magnitudes make a single scale impractical. Examples include time versus temperature and humidity, distance versus elevation and heart rate, or concentration versus instrument response. These examples are not proof of causation; they simply illustrate measurements that may share an X variable.
Before adding the axis, ask what comparison the chart should support:
- If the goal is to compare when values rise, fall, or change direction, a dual-axis scatter plot can be effective.
- If the goal is to compare absolute values, separate charts or a common unit may be clearer.
- If a conversion between units is valid and meaningful, converting one series may allow a single scale, but only do this when the conversion is appropriate for the data.
- If the series use unrelated X variables, placing them together may confuse more than it explains.
A common misconception is that matching the apparent heights of points means the values are equal. It does not. With separate scales, Excel can make many pairs of values line up visually by changing the axis bounds. State the units and scale ranges, and avoid drawing conclusions from visual overlap alone.
Common problems and fixes
- The whole chart is selected instead of the series: Click a data point once, then check whether the series is highlighted. If selection is difficult, use the Current Selection list on the chart-formatting ribbon to choose the series by name.
- The secondary axis option is missing: Confirm that a data series, not the chart area, legend, or an individual point, is selected. Also verify that the chart type is XY scatter. Reopen the desktop Excel app if you are editing in a limited web interface.
- The right axis appears, but the series still looks flat: Select the right-hand axis and adjust its bounds. Make sure the minimum and maximum include the data but are not so wide that the variation becomes hard to see.
- Points seem out of alignment: Check the X values for each series and inspect the horizontal axis bounds and units. Scatter charts use numeric X positions, not just category labels.
- The chart looks misleading: Review whether the chosen bounds exaggerate or minimize changes. Include units, use a clear legend, and consider separate charts if the dual scales invite incorrect comparisons.
If the data include blanks, text, or values stored as text, inspect the source ranges as well. A chart can omit or misinterpret entries depending on the data and chart settings. Correcting the source data is preferable to trying to fix an axis that is not displaying the intended values.
Alternatives to a second Y-axis
A secondary axis is not the only way to handle different ranges. Two small charts stacked vertically can share the same X-axis while giving each measure its own clearly labeled scale. This makes trends comparable without implying that the vertical positions have the same meaning.
Other options include converting one series to a valid common unit, showing a normalized index when relative change is the question, or using separate charts with matching X limits. Normalizing changes what the chart communicates: an indexed series shows relative movement from a chosen starting point, not the original measurements. Make that transformation explicit in the labels and notes.
A line chart may be suitable for sequential categories such as months, but it treats horizontal positions as categories rather than as fully numeric X coordinates. If spacing between X values matters—for example, measurements taken after 1, 2, and 10 hours—an XY scatter chart is usually the more appropriate choice.
Frequently Asked Questions
Can an Excel scatter plot have a secondary Y-axis?
Yes. Select the series, open Format Data Series, and choose Secondary Axis under Series Options. Excel displays a separate vertical scale for that series.
How do I put only one scatter series on the secondary axis?
Select that series rather than the chart as a whole, then change its Plot Series On setting to Secondary Axis. Other series remain on the primary axis unless you move them too.
Why did Excel add an axis at the top of my chart?
That is usually the secondary horizontal axis associated with the secondary-axis scatter series. It represents X values, not another vertical scale. Keep it if it explains a distinct X scale; otherwise, hide its display when the series share the same X values.
Can the two Y-axes use different units?
Yes. That is a common reason to use them. Label each axis with its measure and unit, and remember that vertical alignment does not mean equal values when the scales differ.
Can I add a secondary axis in Excel for the web?
Chart-editing options in Excel for the web can differ from the desktop app. If you cannot find the series’ Secondary Axis setting, open the workbook in Excel for Windows or Mac and make the change there.
Related
- Excel Print Area Locked? Causes, Fixes, and Workarounds Explained
- Excel Print Area Lines: What They Mean and How to Hide Them
- Excel Print Area Button: Where to Find It and How to Use It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: Generate Multiple Sheets?Yes, you can generate multiple sheets from a single Excel pivot table, but not with a built-in one-click…
- Power Pivot Add-In: What It Does and How to Enable ItThe Power Pivot add-in is an Excel tool for building data models: it can connect tables, define relationships,…
- How to Hide Zeros in an Excel Pivot Chart ProperlyIn Excel for Microsoft 365 on Windows, the right way to hide zeros in a PivotChart depends on…
- Excel Quadratic Trendline: Add, Interpret, and Check FitTo add a quadratic trendline in Excel for Microsoft 365 on Windows, create an XY scatter chart, select…
- Excel Pivot Table Percent of Total: How to Show ItTo show a percent of total in an Excel pivot table, add the value field a second time,…
- How to Create a Chart Audit Form in Excel: Step by StepCreate a chart audit form in Excel by listing each audit as one row, adding consistent Yes/No/N/A fields…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.