Yes. In Excel for Microsoft 365 on Windows, create an XY scatter chart, select the data series that needs its own scale, then choose Format Data Series > Series Options > Secondary Axis. Excel can display a second vertical axis so two series with different Y-value ranges or units are easier to read; the X values still need to be assigned correctly for each series.
What a second Y-axis does
A scatter plot places each data point according to a numeric X value and a numeric Y value. Adding a secondary vertical axis lets one series use a different Y scale from the series on the primary axis. This is useful when the values describe different measurements or have very different magnitudes. For example, one series might show air temperature from 0 to 30 degrees while another shows rainfall from 0 to 120 millimeters across the same dates.
Without a second scale, Excel may compress the smaller-range series near the bottom of the chart, making its changes difficult to see. With a secondary axis, each series can use a scale suited to its values. Both series remain in the same chart, but their vertical positions are read against different axes. The axis on the left is usually the primary Y-axis and the one on the right is usually the secondary Y-axis.
A second axis does not convert, combine, or otherwise change the source data. It changes the scale used to draw one series. That distinction matters: the height of a marker from one series cannot be compared directly with the height of a marker from the other unless you read the appropriate axis.
Prepare the data for an XY scatter chart
Set up each series with a column of X values and a column of Y values. For example, a table could have Date, Temperature, and Rainfall columns. Use the dates as the X values for both series, temperature as the first Y range, and rainfall as the second Y range. Keep the values for each pair aligned row by row, and include clear column headings.
Scatter charts treat X values as numbers on a continuous scale, rather than as separate category labels. Excel stores dates as serial numbers, so dates can work as scatter-chart X values. If the data contains text categories such as product names, a line chart may be a better fit. A scatter chart is especially appropriate when the X values are numeric measurements, unevenly spaced dates, elapsed time, or another quantity where the spacing between values matters.
Before charting, check for blank cells, text stored where numbers are expected, and mismatched range lengths. If one series has 20 Y values but only 19 X values, its plotted points cannot be paired as intended. For a clean setup, use separate X and Y columns for each series if their X values differ. If the series share one X range, you can reuse that range when editing each series.
Create the scatter plot
- Select the data range, including the headers. If the X and Y columns are not next to each other, insert a blank chart first and add the series in the next section.
- Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then choose a scatter style, such as Scatter with only Markers.
- Check that Excel assigned the intended X and Y data. If the chart does not show the expected points, select the chart and choose Chart Design > Select Data to inspect the series.
- Give the chart a useful title and, if needed, add axis titles using Chart Design > Add Chart Element > Axis Titles.
For data that is not in one contiguous block, the chart can still be built by adding series manually. Select the chart, open Chart Design > Select Data, and choose Add. In the Edit Series dialog, enter a series name, the X values range, and the Y values range. Repeat for the other series. For a scatter chart, specifying both ranges is important: unlike a basic category chart, each series has its own numeric horizontal coordinates.
Put one series on the secondary Y-axis
Click a marker belonging to the series that needs the alternate scale. A first click selects the series; another click may select an individual point, so make sure the whole series is selected. Right-click and choose Format Data Series. In the Format Data Series pane, open Series Options and select Secondary Axis.
Excel adds a secondary vertical scale, commonly shown on the right. If the axis is not visible, select the chart and choose Chart Design > Add Chart Element > Axes > Secondary Vertical. The exact visible axis options can depend on the chart and current selection. You can also use the chart’s green plus button, when available, to turn on axis elements.
Next, label both vertical axes so readers know which units belong to which series. Select an axis title and type a description such as Temperature (°C) or Rainfall (mm). If the two series have different X ranges and need separate horizontal scales, check whether a secondary horizontal axis is appropriate and visible. Most charts comparing measurements over the same dates need only one shared X-axis.
In Excel for Mac, the chart concepts are the same, although the ribbon and formatting pane can look different. Select the series, open its formatting options, and set it to plot on the secondary axis; use the chart design controls to display and title axes. Excel for the web has a more limited chart-editing interface than the desktop app, so use Excel for Microsoft 365 on Windows or Mac if the secondary-axis setting is not available in your browser.
Set useful axis scales and labels
Excel chooses axis bounds and units automatically, but automatic scales are not always the clearest choice. Right-click an axis and choose Format Axis. In Axis Options, you can set bounds and units where the chart allows it. For example, if rainfall ranges from 0 to 90 mm, a maximum of 100 may make the scale easy to interpret. Avoid setting a minimum that hides meaningful values or exaggerates small changes without making that choice clear.
Choose scales that make the data legible without suggesting a false relationship. A line or pattern that appears to track another series can look more or less closely aligned when either vertical scale changes. The underlying values have not changed, but the visual comparison has. Keep axis titles, units, and tick marks readable, and consider adding a legend that identifies the series as well.
- Use a descriptive title for each axis, including units where relevant.
- Use marker colors or shapes that remain distinct when printed or viewed by people with color-vision differences.
- Set sensible minimum and maximum bounds, and explain nonzero baselines when they could affect interpretation.
- Keep the legend close to the plot and use series names that explain what is measured.
When two Y-axes help—and when they mislead
A second axis is helpful when the chart needs to show two related measurements against a common numeric X range, but the measurements use different units or ranges. For example, a lab chart could plot concentration and temperature against elapsed minutes. The shared X position makes it possible to see when readings occurred, while separate Y scales preserve visibility for each measure.
It is less helpful when the goal is to prove that two variables move together. Because each vertical scale can be adjusted independently, the series can be made to appear visually similar or dissimilar without changing the data. A dual-axis chart does not establish correlation, causation, or a meaningful one-to-one comparison. To assess a relationship between two variables, a scatter plot with one variable on X and the other on Y is often more direct; that design uses one Y-axis and shows the relationship between paired observations.
Consider alternatives when the audience may confuse the scales. Separate charts with aligned X-axes preserve timing while avoiding competing vertical scales. A normalized or indexed chart can compare relative change, but it changes the displayed measure and must be labeled clearly. If the two series have very different X values as well as different Y values, a dual-axis setup may be harder to interpret; separate charts or a carefully explained secondary horizontal axis may be clearer.
Common problems and fixes
- The wrong series gets the second axis: Click a marker for the intended series and confirm the series name in the Format Data Series pane before changing its axis setting.
- The chart shows unexpected X positions: Open Chart Design > Select Data, select the series, and choose Edit. Check the Series X values and Series Y values ranges.
- The secondary axis is missing: Confirm that the series is assigned to Secondary Axis, then add Secondary Vertical from Chart Design > Add Chart Element > Axes.
- Points are connected unexpectedly: Choose a scatter subtype with only markers, or select a subtype with lines if connecting observations is meaningful. A connecting line can imply continuity between measurements.
- One series looks flat: Check which axis it uses and review that axis’s bounds. Do not assume the data is constant merely because the scale makes its variation hard to see.
- Dates appear oddly spaced: Confirm that the cells contain real Excel dates rather than text. Scatter charts space numeric dates according to their actual time intervals.
When editing a chart, select the axis or series itself before opening the formatting pane. Selecting the chart area instead shows chart-wide options and can make the relevant setting difficult to find. If you change bounds to improve readability, revisit them after adding or updating data; fixed limits can clip new values.
Frequently Asked Questions
Can an Excel scatter plot have two Y-axes?
Yes. Assign one data series to the secondary axis through Format Data Series > Series Options > Secondary Axis. The chart can then show a separate vertical scale for that series.
Can both scatter series use the same X-axis?
Yes. In Select Data, set the same X values range for both series and give each series its own Y values range. This is common when comparing two measurements recorded at the same times or at the same numeric positions.
Why is the secondary axis on the right?
Excel commonly places the secondary vertical axis on the right side of the chart, leaving the primary vertical axis on the left. You can format axis labels and bounds, but keep each scale clearly identified so readers do not mistake one for the other.
Can the two Y-axes have different units?
Yes. That is one reason to use a secondary axis. Add clear axis titles, such as Speed (km/h) and Fuel use (L/100 km), so the reader can connect each scale to its series.
Is a dual-axis chart the same as a correlation chart?
No. A dual-axis chart displays two series against a shared X scale using separate Y scales. A conventional relationship scatter plot places one variable on X and the other on Y, with each point representing a paired observation.
Final checklist
Before sharing the workbook, confirm that each series has the correct X and Y ranges, only the intended series uses the secondary axis, and both vertical axes have descriptive titles and sensible scales. Check the chart at its intended viewing size and make sure its colors, markers, and legend remain understandable. A dual-axis scatter plot is most useful when it answers a specific question that one scale cannot show clearly—and when its separate scales are impossible to overlook.
Related
- Excel Power Query: Split a Cell Into Multiple Rows
- Excel Power Query and SQL: How They Work Together
- Excel Power Query Shortcuts: Refresh, Edit, and More
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Load Excel Power Query Into an Existing TableIn Excel for Microsoft 365 on Windows, a Power Query can load to an existing worksheet, but it…
- Excel Row Limit Per Sheet: Maximum Rows ExplainedMicrosoft Excel supports a maximum of 1,048,576 rows per worksheet, from row 1 through row 1,048,576. That limit…
- Daily Household Expense Tracker Spreadsheet: Setup and UseA daily household expense tracker spreadsheet is a simple Excel workbook for recording each purchase, bill, or other…
- Excel Essential Keyboard Shortcuts for Everyday WorkFor Excel for Microsoft 365 on Windows, start with these essentials: Ctrl+C, Ctrl+V, and Ctrl+Z to copy, paste,…
- Excel Data Validation Examples and Setup TipsExcel data validation examples include dropdown lists for status fields, number limits for quantities, date rules for deadlines,…
- How to Highlight a Picture in Excel with a Custom BorderTo highlight a picture in Excel for Microsoft 365 on Windows, select the picture, open the Picture Format…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.