Excel Scatter Plot Not Showing All Data? Try These Fixes

How-to basics · Updated November 21, 2026

If an Excel scatter plot is missing points, check the chart’s X and Y ranges first, then look for hidden or filtered rows, nonnumeric values, axis limits, and overlapping markers. In Excel for Microsoft 365 on Windows, select the chart and use Chart Design > Select Data to inspect its series; most missing-point problems come from the source data or display settings rather than a broken chart.

Check the chart’s source range

A scatter chart plots pairs of values: one X value and one Y value for each point. If the chart’s series references only part of your worksheet, later rows will not appear, even when the data is visible beside the chart. A range can also include extra blank rows, which may look like missing observations when you expect a point for every row.

To inspect the source in Windows, click the chart, choose Chart Design > Select Data, and review the entries under Legend Entries (Series). Select a series and choose Edit. Check both the Series X values and Series Y values boxes. They should point to the intended numeric cells and cover matching numbers of rows. For example, if X values cover B2:B21, Y values should usually cover C2:C21—not C2:C18 or C2:C22.

If the chart has no series, or the selected range was interpreted incorrectly, add or edit a series in the Select Data Source dialog. The scatter chart needs a separate X range and Y range for each series; it does not use category labels in the same way a line chart does. When you select a rectangular block to insert a chart, Excel commonly treats the first column as X values and the next column or columns as Y series. Verify that interpretation rather than assuming Excel guessed correctly.

Make sure every intended row is included

When creating a chart, selecting only the currently filled cells is easy to do by accident. If new measurements were added below the original range, the chart may still point to the older rows. The quickest check is to select the chart and inspect its series ranges in Chart Design > Select Data. You can also click a plotted series and look at the highlighted source cells on the worksheet, though the series dialog gives a clearer view of the exact references.

For nonadjacent columns—for instance, an X column separated from the Y column—add the series through Select Data rather than selecting unrelated blocks and hoping Excel pairs them correctly. Use the X range for the horizontal measurements and the Y range for the vertical measurements. If each group has its own X measurements, create a separate series for that group instead of reusing the first group’s range.

In Excel for Mac, select the chart and use the Chart Design tab to open Select Data; the dialog and labels can differ slightly by build. Excel for the web has a more limited chart-editing interface than the desktop apps. If a series range is difficult to inspect or change in the browser, open the workbook in desktop Excel.

Check hidden rows, filters, and chart settings

Excel charts may omit data in hidden rows or columns. A worksheet filter can hide rows too, so first clear the filter or check whether the supposedly missing observations are currently filtered out. To tell the chart to include hidden worksheet data, select it and open Chart Design > Select Data, then choose Hidden and Empty Cells. Turn on Show data in hidden rows and columns if that option is available in your Excel build and you want hidden values plotted.

This setting does not make filtered-out records visible on the sheet; it changes what the chart can display from hidden source cells. If you need a chart to reflect only the rows that remain visible after filtering, leave hidden data excluded. If you need the chart to show every record regardless of whether its row is hidden, enable the option and verify the result. On Mac, look for the same hidden-and-empty-cells controls in the chart’s Select Data options; exact placement can vary slightly.

Also check whether the data is in a table with filters, or whether rows were hidden manually. A row number that jumps in the worksheet gutter is a clue that rows are hidden. Clearing a filter is a useful diagnostic, but do not remove a filter permanently if it is part of the workbook’s intended analysis.

Check for blanks, text, and errors

Scatter charts require numerical coordinates. A cell that looks like 12.5 might actually contain text, perhaps because it was imported with a leading apostrophe, an unexpected decimal separator, or extra spaces. Excel may fail to plot such a value as intended. Select a suspicious cell and check its formula bar and number format; changing the format alone does not convert text into a number. Use Excel’s conversion tools or correct the imported values, then confirm that the X and Y cells are numeric.

Blank X or Y cells cannot define an ordinary complete point. In Chart Design > Select Data > Hidden and Empty Cells, Excel offers choices for empty cells such as gaps, zero, or connecting data points with a line. The available behavior depends on chart type, and an empty-cell choice does not create a meaningful coordinate where one is missing. For a scatter plot with markers, a gap is often the clearest way to avoid implying a measurement that was never recorded.

Formula cells that display an empty string can be confusing: they look blank but are not truly empty. Error values can also prevent a point from appearing as expected. Inspect the source cells themselves, not just their displayed appearance. If the chart uses a formula-generated series, check whether the formulas return numbers for all intended rows and whether any rows return text, an empty string, or an error.

Expand the axis limits

A point can be present in the series but outside the visible chart area. Click the horizontal or vertical axis, open Format Axis, and inspect the Bounds settings under Axis Options. If Minimum or Maximum has been entered manually, a value beyond that limit will be clipped from view. Set the bounds back to Auto, or enter limits that include the full data range. Repeat for both axes because an overly narrow limit on either axis can hide a point.

Axis bounds are especially worth checking after copying a chart or changing the data range. For example, a chart with a vertical maximum fixed at 100 will not show a new observation with a Y value of 135, even though that observation is in the source range. The point may appear after returning the maximum to Auto. Also inspect the axis scale and number formatting if the range is extremely large or values are close together; a point can be visible but compressed near an edge.

Look for points hidden underneath other points

Two or more rows can have identical X and Y coordinates. Excel plots each record, but the markers occupy the same position, so the top marker conceals the ones beneath it. Near-duplicate values can also overlap when markers are large or the chart is small. This often happens with rounded measurements, repeated test results, or many observations recorded at the same timestamp.

To investigate, sort or filter the worksheet by the X and Y columns and look for repeated pairs. Temporarily change marker formatting to use a smaller size or a different shape, and enlarge the chart area. Select a series, open Format Data Series, and adjust the marker options. You can also use different colors for separate groups, or add data labels when the number of points is small enough for labels to remain readable. Avoid jittering the plotted values unless you clearly explain it: changing coordinates for display can misrepresent the actual measurements.

If points are close but not identical, try widening the chart or adjusting the axis bounds to give them more visual space. A dense scatter plot may need transparency, smaller markers, or a different presentation rather than a data repair. Confirm the underlying values before concluding that observations are missing.

Confirm that the chart type and series are right

Use an XY (Scatter) chart when horizontal positions represent numeric values and the distance between X values matters. A line chart treats its horizontal axis as categories, so it can space observations evenly even when the X values are irregular. That difference can make a chart appear to omit or misplace data when the real issue is the chart type. To change it, select the chart and choose Chart Design > Change Chart Type, then select an XY (Scatter) option suited to the data.

Check whether a series was accidentally removed or assigned the wrong columns. In Select Data, each series should have a useful name, an X range, and a corresponding Y range. A chart with several Y columns may show several series, but each series must have compatible X values. If one series appears while another does not, inspect the individual series instead of changing the whole chart.

Markers are also a chart-type choice. A scatter chart with smooth lines or straight lines may connect points, while a markers-only option emphasizes individual observations. If you can see a connecting line but not every marker, inspect the series’ marker formatting and confirm that markers have not been set to None. Changing marker style does not restore missing source data, but it can reveal points that were difficult to see.

Make charts easier to maintain as data grows

If new rows are added regularly, a chart tied to a fixed range may not include them automatically. One practical option is to format the source as an Excel table: select the data and choose Home > Format as Table, then create or update the chart from that table. Excel charts based on table data commonly expand when new table rows are added, but check the series ranges after changing the workbook or adding data in unusual ways. A table also makes it easier to keep column headings and records organized.

For occasional updates, editing the series ranges directly may be simpler than building a more complex setup. Keep X and Y columns together with clear headers, avoid blank rows inside the data, and add new records immediately below the existing list. If the chart is part of a report, verify its ranges after inserting, deleting, or moving columns; a chart can continue to work while pointing at the wrong data.

A quick diagnostic order

Use this sequence to narrow down the cause without rebuilding the chart:

  1. In Select Data, confirm that every series exists and that its X and Y ranges include the expected rows.
  2. Check whether the missing rows are hidden or filtered, and review the chart’s hidden-data setting.
  3. Inspect the source cells for blanks, text-formatted numbers, and errors.
  4. Set both axis bounds to Auto temporarily and see whether the points appear.
  5. Reduce marker size or check for duplicate coordinate pairs that may overlap.
  6. Confirm that the chart is XY (Scatter) and that the series has visible markers if individual points should show.

Change one thing at a time and undo a change if it does not help. This makes it easier to identify the actual cause, particularly in a workbook with multiple series, filters, and formulas.

Frequently Asked Questions

Why does my Excel scatter plot show only some rows?
Usually, the chart series references a smaller range than the full dataset, some rows are hidden or filtered, or certain X or Y cells are blank, text, or errors. Inspect the series ranges and source cells first.

How do I make an Excel chart show hidden data?
Select the chart and choose Chart Design > Select Data > Hidden and Empty Cells. Enable Show data in hidden rows and columns if you want hidden worksheet values included. This does not remove filters or unhide the rows.

Why are points missing even though the data range is correct?
Check axis bounds, cell contents, and overlapping coordinates. A point outside a manually fixed axis limit will not be visible, while duplicate X-Y pairs can plot directly on top of one another.

Does a scatter plot need two columns?
Each series needs X values and matching Y values, which are often stored in two columns. A chart can have multiple series, and each can use its own X and Y ranges.

Why does my scatter plot space values evenly?
You may have inserted a line chart instead of an XY (Scatter) chart. A line chart uses category positions on its horizontal axis; a scatter chart uses numeric X coordinates and reflects the numeric spacing between them.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.