Excel Scatter Plot Not Working? Fix Common Chart Issues

If an Excel scatter plot is blank, misplaced, or showing the wrong points, check that both series ranges contain numeric X and Y values with matching row counts. In Excel for Microsoft 365 on Windows, select the data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart; for an existing chart, use Chart Design > Select Data to correct its series ranges.

How an Excel scatter plot works

A scatter chart plots each observation as a coordinate: one value determines its horizontal position (X), and another determines its vertical position (Y). For example, a table of advertising spend and sales could show whether higher spending tends to accompany higher sales. Unlike a line chart, a scatter chart treats the horizontal axis as a numeric value scale, not simply as a set of equally spaced category labels.

That distinction explains many apparent failures. A line chart can display text labels such as product names along the horizontal axis. A scatter chart needs usable X values for every point. If a column contains labels where numbers are expected, Excel may interpret the series differently than you intend, omit points, or create a chart that looks compressed. The chart is not necessarily broken; it may be using the wrong chart type or reading the source data in an unexpected way.

Scatter charts are useful for examining relationships, clusters, outliers, and trends between two measured quantities. They do not prove that one variable causes another. A visible association between two columns is a pattern in the data, not by itself an explanation of why the pattern exists.

Check the data layout before changing the chart

Start with a simple, clearly labeled table. Put the X values in one column and the corresponding Y values in another, with one observation per row. For example, column A might contain hours studied and column B exam scores. The first data row should represent one student, and the next row should represent the next student. Blank rows inside the data or separate totals can interfere with selection and make it harder to verify what Excel plotted.

Use a header for each column, such as Hours and Score, and keep the actual observations below the headers.
Make sure each X value is paired with the Y value from the same observation on the same row.
Check that both series cover the same number of data rows. If X runs from A2:A21, the matching Y range should have 20 values too.
Look for numbers stored as text, error values, empty cells, and stray spaces or labels mixed into the measurements.
Keep units consistent. Mixing dollars and thousands of dollars, for instance, can distort how a relationship appears.

For a basic two-column table, select the headers and data together, then use Insert > Insert Scatter (X, Y) or Bubble Chart and choose a scatter subtype. The first option, Scatter with only Markers, is a useful starting point when you want to inspect the individual observations without adding connecting lines.

Choose the right chart type and series

Excel offers several scatter-chart subtypes, including markers only, smooth lines with or without markers, and straight lines with or without markers. Choose based on what the data represent. Markers only are usually appropriate for independent observations. Lines can help when points form a meaningful ordered sequence, such as measurements taken over time, but connecting unrelated observations can imply a progression that is not present in the data.

If the chart has the wrong columns on its axes, Excel may have guessed the series orientation incorrectly. Select the chart and open Chart Design > Select Data. In the Select Data Source window, select the series and choose Edit. Check the Series X values and Series Y values boxes, and make sure each refers only to the intended numeric cells, not the header. You can also use Add to create a separate series when you want to plot another set of paired measurements.

For example, if A1 says Distance, B1 says Time, and observations are in rows 2 through 12, the intended X range is A2:A12 and the Y range is B2:B12. If Excel instead plots the row numbers against one column, edit the series so the two ranges point to the corresponding measurements. In the Select Data Source window, the Legend Entries (Series) list identifies the plotted series; the Horizontal (Category) Axis Labels control used for some other chart types is not a replacement for setting X values in an XY scatter series.

Fix a blank chart or missing points

A chart with axes but no visible markers often has a series pointing to blank cells, the wrong worksheet, or a range that contains text rather than numbers. Select the chart, choose Chart Design > Select Data, and inspect every series. Use Edit to verify the X and Y ranges, then compare the range addresses with the actual table. Watch for a reference that stops one row too early or includes a title row instead of the first observation.

Next, inspect the source cells. A value that looks like 12.5 may be text, especially if it was imported from a file or entered with a decimal separator that does not match the computer’s regional settings. In a blank cell, a simple check such as whether the value is aligned or whether Excel displays a green error indicator can offer a clue, but formatting alone is not proof. Select a suspicious cell and use Home > Number Format to apply a numeric format; changing the format does not convert text into a number. If Excel offers a warning icon for numbers stored as text, choose Convert to Number. For a column of imported values, Data > Text to Columns and then Finish can also coerce values when the import is otherwise straightforward. Review the results, particularly if the data use commas or periods as decimal and thousands separators.

Check whether the points are actually present but hard to see. They may be tiny, hidden behind another series, or positioned outside the displayed axis bounds. Select a marker and use Format Data Series to change marker size or color, or temporarily remove other series to isolate the problem. If the chart is filtered, open the chart’s filter button and confirm that the relevant series or categories are not excluded.

Correct axis scales and misleading ranges

A scatter chart can appear empty when one extreme value stretches the axis so far that most observations cluster together. Select the axis, right-click, choose Format Axis, and inspect Axis Options. If Minimum or Maximum bounds have been set manually, restore them to automatic or enter bounds that include the full data range. The same panel controls the displayed scale and major units; changing these affects the view, not the underlying values.

Also inspect the axis crossing settings if points appear on an unexpected side of an axis. A horizontal axis can cross the vertical axis at a specified value, and the reverse can also be configured. This may be intentional when data include negative numbers, but a crossing value outside the usual range can make the plot look oddly shifted. Returning crossing options to their default behavior is a useful diagnostic before adjusting the chart further.

Be careful when setting a minimum above zero to make small differences easier to see. That can be appropriate for a focused analysis, but it can also exaggerate visual differences. If the chart will be shared, label units clearly and consider whether the chosen bounds give readers a fair sense of the size of the changes.

Handle dates, blanks, and imported data

Excel stores valid dates as serial numbers, so date values can serve as X values in a scatter chart. The axis may display numbers rather than dates if the axis number format is unsuitable. Select the horizontal axis, open Format Axis, and choose an appropriate date format under Number when that option is available. If dates are text imported from another system, convert them to real Excel dates first; changing the display format alone does not turn text into date values.

Missing observations need a deliberate choice. Select the chart, choose Chart Design > Select Data, then Hidden and Empty Cells. In the dialog, choose how empty cells should appear, such as gaps or zero values, where the available options apply. For an XY scatter plot, a blank X or Y coordinate cannot define a normal point, so a zero setting can create a misleading point at or near the origin. Avoid replacing missing measurements with zero unless zero is the true measured value.

Imported workbooks can also contain formulas that return an empty string, errors, or values with hidden leading or trailing spaces. Inspect the source cells and, if necessary, clean the imported data before charting. If the chart should expand as new rows are added, convert the source range into an Excel table with Insert > Table, then confirm that the chart’s series include the new rows. Do not assume that every chart reference will expand in every workbook setup; check the series ranges after adding data.

Make the chart easier to read and maintain

Once the points display correctly, add context so the chart can be understood without guessing. Select the chart and use Chart Design > Add Chart Element to add axis titles, a chart title, or gridlines. State the units in axis titles, such as Temperature (°C) or Revenue ($), and use a clear title that describes the variables rather than merely saying Scatter Plot.

When several groups are plotted, assign each group its own series and use distinguishable marker colors or shapes. A legend is useful only if its series names are meaningful. Avoid relying on color alone if the chart may be printed in grayscale or viewed by someone with color-vision differences; marker shapes and clear labels can help. If many points overlap, consider smaller markers or transparency in Format Data Series, where the relevant formatting controls are available.

For a trend line, select the plotted series, right-click it, and choose Add Trendline. A trendline summarizes a chosen model; it does not correct wrong data or establish causation. If the chart is used for reporting, state what the variables mean and whether any points were excluded. Keep a copy of the source data and avoid deleting unusual observations merely because they do not fit the pattern.

Frequently Asked Questions

Why does Excel show a line chart instead of a scatter plot?
Excel may have inserted a line chart because that chart type was selected, or because the data selection and chart defaults led to a different choice. Select the chart, then choose Chart Design > Change Chart Type and select an XY (Scatter) subtype. Verify that the X and Y ranges are assigned correctly afterward.

Why is my scatter plot showing dates as numbers?
Excel dates are stored as serial numbers, and the axis may be using a general number format. Select the horizontal axis, open Format Axis, and apply a date number format. If the source dates are text rather than real date values, convert the source data first; formatting text as a date will not reliably fix it.

Why are my points all on one vertical or horizontal line?
One axis may contain the same value for every observation, or Excel may be using the wrong range for that axis. In Chart Design > Select Data, edit the series and check the X and Y references. Also confirm that the expected source values are numeric and vary as intended.

Can a scatter plot use text labels on the X-axis?
A standard scatter chart uses numeric X coordinates, not category labels in the same way a line chart does. If each point needs a text label, keep numeric X values for positioning and use data labels sourced from cells if that option is available in your Excel build, or consider a chart type designed for categories. Do not substitute labels for numeric X values and expect an ordinary scatter axis to space them as categories.

Why do new rows not appear in my scatter chart?
The series may refer to a fixed range that ends before the new rows. Open Chart Design > Select Data and extend both the X and Y ranges by the same number of rows. Using an Excel table as the source can make expanding data easier, but confirm that the chart series actually include the added observations.

Do the steps differ on Mac or Excel for the web?
The core approach—choose an XY scatter chart and check its paired series ranges—is the same, but ribbon layout and some formatting dialogs can vary by platform and update. Excel for Mac uses the same chart concepts, while Excel for the web may offer fewer detailed formatting controls than the desktop application. If a named dialog or option is not visible, open the chart’s series or axis formatting pane and look for the equivalent control.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.