Excel Scatter Plot: Select Data, Edit Series, and Fix Axes

Errors & fixes · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select the columns containing your X and Y values, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and pick a scatter style. To change the data in an existing chart, select the chart and go to Chart Design > Select Data; there you can add, remove, or edit each plotted series.

What Excel needs for a scatter plot

A scatter plot, also called an XY chart, places each observation according to two numeric values: one value determines its horizontal position (X), and the other determines its vertical position (Y). A row might represent one measurement, such as a product’s advertising spend and sales, or a person’s height and weight. Excel plots the paired values as points rather than treating the first column as a set of category names.

The basic layout is one X column beside one Y column, with a row for each paired observation. For example, put temperature in A2:A6 and electricity use in B2:B6, with descriptive headings in A1 and B1. Select A1:B6 and insert the scatter chart. Excel will generally use the first column for X and the second for Y, and may use the heading as the series name. Check the plotted axes afterward: selecting the correct cells is only useful if the columns have the intended meaning.

Unlike a line chart, a scatter chart uses numeric values on both axes. The horizontal distance between points therefore reflects the difference between X values. This makes a scatter plot suitable for showing relationships, distributions, clusters, and outliers in paired measurements.

Select data while creating a scatter chart

For a straightforward two-column table, use this sequence in Excel for Microsoft 365 on Windows:

  1. Arrange the X values and corresponding Y values in adjacent columns. Put the X values on the left and the Y values on the right, and use one heading row if you want a meaningful series name.
  2. Select the full range, including the headings when present. Avoid selecting unrelated totals or notes beneath the data.
  3. Choose Insert > Insert Scatter (X, Y) or Bubble Chart in the Charts group.
  4. Select a scatter option, such as Scatter with Only Markers. Choose a version with lines only if connecting points makes sense for the data.
  5. Inspect the chart and confirm that the horizontal axis shows the intended X variable and the vertical axis shows the intended Y variable.

If Excel does not interpret the columns as intended, select the chart and use Chart Design > Select Data. In the Select Data Source dialog, choose the series and click Edit. Set Series X values to the cells containing the horizontal measurements and Series Y values to the corresponding vertical measurements. Exclude the heading cells from these value ranges; enter the heading separately as the Series name if needed.

Choose the right cells when columns are not adjacent

Real worksheets often place X and Y values in separate parts of a table, with labels, dates, or other measurements between them. A scatter chart does not require the two value columns to be adjacent, but selecting separated ranges can be less intuitive. One dependable approach is to insert a blank scatter chart, then add the series through Chart Design > Select Data > Add. In the Edit Series dialog, specify the name, X range, and Y range independently.

For example, imagine dates in column A, distance in column C, and time in column F. If the question is whether distance relates to time, use the numeric distance values as X and the matching time values as Y. The dates are not automatically the X values just because they appear first in the worksheet. If dates are meant to be the horizontal scale, select the date cells as X values and confirm Excel recognizes them as usable date numbers.

When selecting multiple ranges directly, hold Ctrl while selecting additional cells or ranges on Windows, but remember that the chart wizard may not map a complex, noncontiguous selection the way you expect. Adding series in the Select Data Source dialog is more explicit and easier to verify. On Mac, use Command rather than Ctrl for multi-selection in many interface operations; the dialog and chart commands may be arranged slightly differently by Excel version.

Add or edit a series in an existing chart

A series is one set of paired X and Y values displayed together. A chart can contain several series, for example, one for each store or experimental group. To revise a chart, click it, choose Chart Design > Select Data, select a listed series, and click Edit. To create another series, click Add; to remove a selected one, click Remove. Removing a series from the chart does not delete its source cells.

The Edit Series dialog separates the three important pieces:

  • Series name: A heading cell or typed label used in the legend. The name does not determine the X or Y values.
  • Series X values: The numeric cells that control horizontal positions.
  • Series Y values: The matching numeric cells that control vertical positions.

Both value ranges should contain the same number of data points and correspond row by row. If X contains six observations but Y contains five, Excel may reject the range or plot an incomplete result. If the two ranges are the same length but shifted by a row, the chart can look plausible while pairing the wrong measurements. Compare the first and last source rows in the dialog before accepting the change.

Prepare and check the source data

Scatter charts work best when each observation has a numeric X value and a numeric Y value. Keep the paired values on the same row, and use consistent units within each series. A text entry such as “unknown,” an empty cell, a number stored as text, or a merged cell can lead to missing or unexpected points. Check the source cells if a point disappears or an axis behaves strangely.

Headings are useful, but do not include them in the X or Y value ranges when editing a series. Do not include a totals row unless that total is itself a real observation. Also look for hidden rows or filtered data if the plotted point count seems too small. Excel chart settings can determine whether hidden data is shown; select the chart and look for Chart Design > Select Data > Hidden and Empty Cells to review the available display choices.

Before changing a chart, decide what one point represents. If each row represents a separate observation, keep the rows aligned. If measurements are summarized by group, make sure each X value and Y value refer to the same group. A carefully labeled source table makes it much easier to spot a mismatched range than a chart alone.

Fix common selection problems

If the chart has only one point, no points, or an implausible shape, first reopen the series settings and inspect the X and Y ranges. A common mistake is selecting only the Y column. Excel may then create an X sequence based on point order, rather than using the intended measurements. Another frequent error is reversing the two ranges: Excel will still draw points, but the variables will appear on the wrong axes.

  • Points appear in the wrong direction: Check which range is assigned to X and which to Y. Edit the series rather than rearranging the worksheet just to change chart roles.
  • Values appear as one point or are missing: Look for blank cells, text-formatted numbers, or unequal range lengths.
  • Unexpected extra points appear: Check whether a heading, subtotal, or unrelated row was included in the selected range.
  • The horizontal axis shows 1, 2, 3 instead of measurements: Excel may be using point order for X. Assign the intended numeric X range in Edit Series.
  • A newly added group does not line up: Verify that its X and Y values use corresponding rows and the correct number of observations.

Axis scale can also make a correct chart look misleading. A very large outlier may compress most points into a small area, while a manually set minimum or maximum may clip points. Right-click an axis and choose Format Axis to inspect its bounds and number format. Change scale settings only when the result remains truthful and readable; do not assume that a visual problem means the selected cells are wrong.

Scatter plot or line chart?

Choose a scatter plot when both variables are numeric and the actual spacing between X values matters. It is generally the better fit for comparing two measurements, such as engine size against fuel use, because a gap of 10 units is represented differently from a gap of 1 unit. It also allows each series to have its own X values.

A line chart is often more suitable when the horizontal values are categories or when the main purpose is to show a sequence, such as monthly totals. A line chart usually positions category labels at evenly spaced intervals; a scatter chart positions points according to numeric X values. For dates with irregular gaps, an XY chart can show the elapsed spacing more directly, provided the dates are assigned as X values. The chart type should follow the meaning of the data, not simply the fact that the worksheet has two columns.

Make the selected data easier to read

After confirming the series, add axis titles that state the variable and units. Select the chart, then use Chart Design > Add Chart Element > Axis Titles. A title such as “Distance (km)” is more informative than “X-axis.” A legend is useful when the chart contains multiple groups; for one series, it may add little value.

To adjust the appearance of markers or axes, select the chart element and use the formatting options, or right-click the element and choose its formatting command. On Windows, Ctrl+1 opens the Format pane for a selected chart element in current desktop Excel; on Mac, Command+1 is the corresponding shortcut in many Excel versions. If the shortcut does not open the expected pane, use the context menu or ribbon because shortcut behavior can vary with focus and version. Keep marker colors and lines distinct enough to compare groups without implying a connection that the data does not support.

Excel for Mac and Excel for the web

The core workflow is similar in current desktop Excel for Mac: select the chart, use the chart design controls to edit its data, and define each series’ X and Y ranges. Ribbon wording and dialog placement can differ slightly between releases. For nonadjacent ranges or a chart that Excel has interpreted incorrectly, editing the series explicitly is still the clearest approach. Mac keyboard shortcuts often use Command where Windows uses Ctrl.

Excel for the web supports creating and editing many chart types, but some chart-design and formatting controls may be more limited or displayed differently than in the Windows desktop application. If you cannot find a specific series or hidden-cell setting in the browser, open the workbook in desktop Excel and use Chart Design > Select Data. Avoid assuming a click sequence or shortcut is identical across desktop, web, and Mac editions.

Frequently Asked Questions

How do I select X and Y data for an Excel scatter plot?
Select the paired numeric columns and insert a scatter chart, or use Chart Design > Select Data > Edit to assign the Series X values and Series Y values explicitly. Keep the ranges aligned row by row and leave headings out of the value ranges.

Can I use non-adjacent columns in a scatter plot?
Yes. Create or select the chart, open Select Data, and add or edit a series with separate X and Y ranges. This is usually more reliable than trying to select complicated separated ranges directly on the worksheet.

Why is Excel using 1, 2, 3 for the horizontal axis?
Excel is likely using the order of the points because it has not been given the intended X range. Open the series editor and select the cells that contain the actual horizontal measurements.

How do I add another data set to the same scatter plot?
Choose Chart Design > Select Data > Add, then enter the new series name and its X and Y ranges. Use matching ranges for the same observations, and check the chart legend to confirm the group is identifiable.

Does a scatter plot require equal numbers of X and Y values?
Yes, each plotted point needs one X value paired with one Y value. Use ranges with the same number of cells and ensure the values on each row belong together; otherwise Excel may omit data or pair observations incorrectly.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.