Excel Scatter Plot Not Plotting X Values? Here’s How to Fix

Errors & fixes · Updated November 21, 2026

If an Excel scatter plot is not plotting your x values, first confirm that the chart type is XY (Scatter), then check the series’ X values range in Chart Design > Select Data > Edit. The x range must point to the intended cells, contain numeric values Excel can plot, and have the same number of cells as the series’ y range.

A scatter chart can look as if it is ignoring x values when Excel is actually using a different chart type, reading text as nonnumeric data, or displaying the points outside the visible axis bounds. Work through the checks below in order; most problems are fixed by correcting the series range or cleaning the x column.

How scatter plots use x values

An XY scatter chart treats each row as a coordinate pair: one value supplies the horizontal position and another supplies the vertical position. For example, if column A contains hours studied and column B contains test scores, each row creates a point such as (2, 68). Excel uses the actual numbers in column A to position the point along the x-axis.

This differs from a line chart. A line chart usually treats the horizontal axis as a sequence of categories, such as labels or dates, and spaces those categories according to their order. A scatter chart uses a numeric value axis, so the distance between x = 2 and x = 4 is twice the distance between x = 2 and x = 3. If you need numerical spacing, use a scatter chart.

In a standard two-column data set, the first column is often the x variable and the second is the y variable. Excel may guess that arrangement when you insert a chart, but it is only a guess. Checking the series settings is more reliable than assuming the chart inferred your columns correctly.

Check the chart type first

Select the chart and look at the chart type shown on the ribbon. In Excel for Microsoft 365 on Windows, choose Chart Design > Change Chart Type, then select XY (Scatter). Choose a marker-only scatter option if you want points without connecting lines. A scatter chart with straight lines or smooth lines still uses x values; those options only change how points are connected.

If the chart is a line chart, Excel may show your x entries as labels in their row order instead of using their numeric sizes. For example, values 1, 2, 10 could appear at equal category spacing in a line chart, although 10 should be much farther from 2 than 2 is from 1 in an XY scatter plot. Changing the chart type may correct the appearance without changing the source data.

On Excel for Mac, select the chart and use the chart design controls to change its type; ribbon wording and placement can vary slightly by release. Excel for the web also provides chart controls, though some detailed chart-formatting options can be more limited than in the desktop app. If a setting described here is missing in the web version, open the workbook in desktop Excel.

Verify the series X values range

A chart can contain the right data overall but assign the wrong cells to the series. To inspect the assignment in Excel for Microsoft 365 on Windows:

  1. Select the chart, then choose Chart Design > Select Data.
  2. In the list of legend entries (series), select the series you want to fix and choose Edit.
  3. Check the Series X values box and the Series Y values box. Set each to the cells for that series, excluding the header row.
  4. Choose OK, then check the chart and repeat for any other series.

For example, if A1 is the heading Hours, A2:A5 contains 1, 2, 4, and 8, B1 is the heading Score, and B2:B5 contains 55, 62, 75, and 91, the x range should be A2:A5 and the y range should be B2:B5. The entries must have matching lengths. Including a header in just one range, selecting an extra blank row, or pointing both ranges at column B can produce confusing results.

Use the range selector button in the Edit Series dialog to select cells on the worksheet if typing a reference is awkward. Be sure the reference starts and ends on the intended rows. For a chart on another worksheet, Excel includes the sheet name in the reference; avoid deleting that part when editing it.

Make sure the x data is numeric

Scatter charts need numerical x coordinates. Values that look like numbers can actually be text, especially after copying data from a website, importing a CSV file, or using a different decimal separator. Text-formatted values may be left out, treated unexpectedly, or fail to position points as intended.

Click a suspicious x cell and inspect the formula bar and alignment. A green error indicator or the warning menu may offer Convert to Number. You can also test whether Excel recognizes a cell as numeric: in a blank cell, enter =ISNUMBER(A2) if the first x value is in A2. TRUE means Excel recognizes that cell as a number; FALSE means it does not. Repeat for a few entries, especially those that do not appear on the chart.

Common causes include leading apostrophes, spaces before or after a value, numbers imported with commas or periods that do not match the computer’s regional settings, and values containing units such as 12 kg. Remove unwanted characters or convert the source data to numbers before charting. Do not convert genuine text labels into numbers just to satisfy a chart; use a line chart if the horizontal values are categories rather than measurements.

Dates are stored by Excel as serial numbers and can work as x values in a scatter chart. If dates are text rather than real Excel dates, convert them first. Once plotted, you can format the horizontal axis to display dates in a readable way, while the underlying positions remain numeric.

Check for mismatched ranges and multiple series

Each scatter series has its own x and y ranges. When you add more series, Excel does not necessarily use one shared x column for all of them. Open Chart Design > Select Data and inspect each series separately. A series might be using the right y values but an unrelated x range, or it might have been added as a new series with the x and y columns reversed.

Keep each pair aligned by row. If one series has four y values and its x range has five cells, remove the extra cell or add the intended corresponding value. Do not assume Excel will match entries by labels or search for corresponding values; it pairs positions in the ranges. The first x value goes with the first y value, the second with the second, and so on.

For a clear comparison, a worksheet might have x values in A2:A6, y values for Group A in B2:B6, and y values for Group B in C2:C6. Group A should use A2:A6 and B2:B6. Group B should use A2:A6 and C2:C6. If the chart is set up with A2:A6 as a separate plotted series rather than as the x values for each y series, edit or remove that series and assign the ranges correctly.

Look for axis limits that hide points

The x values may be assigned correctly but fall outside the chart’s displayed range. This can happen after someone sets fixed minimum or maximum bounds, or when one unusually large value causes the rest of the points to cluster near one side. Select the horizontal axis, open Format Axis, and review Bounds. Set minimum and maximum back to Auto to let Excel fit the data, or enter limits that include the values you intend to show.

Also check that the x-axis itself is visible and that the chart has not been resized so narrowly that points overlap. If the axis labels seem missing, select the axis and inspect its label and number-format settings. A point can be present even when its marker is too small to notice; temporarily choose a larger marker in the series formatting options to make the data easier to inspect.

For data with a very wide range, consider whether a logarithmic scale is appropriate for the analysis. A logarithmic axis cannot display zero or negative values, so it is not a general-purpose repair for missing points. Use it only when the data and purpose support that scale, and explain the scale clearly to readers.

Account for blanks, hidden rows, and filtered data

Blank cells in either coordinate can leave a point incomplete. Check the rows where the chart appears to have gaps and make sure both x and y entries are present. A formula that returns an empty string may look blank while still being the result of a formula, so inspect the cell contents if the behavior is unexpected.

Hidden or filtered rows can also affect what appears in a chart. Select the chart and choose Chart Design > Select Data > Hidden and Empty Cells to review the available display options. If you want charted values from hidden rows or columns to remain visible, enable the option to show data in hidden rows and columns. The dialog’s availability and exact presentation can differ in Excel for Mac or the web.

Filtering a table can intentionally hide records, and charts based on filtered data often reflect that. Decide whether the chart should follow the filter or show all source values. Avoid filling missing measurements with zero unless zero is the real measured value: zero is a valid x coordinate and can pull the axis scale or create a misleading point.

Use a short diagnostic test

If the original chart is complicated, make a temporary chart from a few known-good rows. Put numeric x values in one column and numeric y values in the next, select those two columns, and insert an XY scatter chart using Insert > Insert Scatter (X, Y) or Bubble Chart. If this small chart works, the issue is likely in the original series ranges, data types, filters, or axis limits rather than in the chart feature itself.

Then compare the temporary chart’s settings with the original. Confirm the original chart type, each series’ X and Y references, and any custom bounds. This is often quicker than rebuilding a chart that already has carefully formatted titles, colors, and labels.

When a chart still behaves strangely, select a point and inspect the formula bar for its series formula. Excel’s series formula records the worksheet ranges used for the series. It can reveal a wrong column or an off-by-one row, but edit the ranges through Select Data unless you are comfortable with chart references; a small syntax mistake can break the series.

Frequently Asked Questions

Why is Excel using my x values as labels?
If the horizontal values appear as equally spaced labels, the chart may be a line chart rather than an XY scatter chart. Change it to XY (Scatter) to position points using the numeric x values.

Why does my scatter plot show all points at the same x position?
Check whether the X values range points to one repeated value or to the wrong column. Also confirm that the cells contain distinct numbers, not text that Excel cannot interpret as numeric coordinates.

Can a scatter plot use dates for x values?
Yes. Excel dates are numeric serial values, so they can be plotted on a scatter chart. If dates do not plot properly, make sure they are real Excel dates rather than text, then format the horizontal axis to display them as dates.

Do scatter chart x and y ranges need the same number of cells?
Yes. Each x value pairs with the y value in the same position, so the ranges should contain the same number of entries and represent matching rows.

Why are some points missing after I filter the data?
The chart may be following the worksheet’s filter or excluding hidden rows. Review the chart’s hidden and empty cell settings, and decide whether filtered or hidden records should appear in the plot.

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.