Chart & Visualization Issues

Fix Excel Scatter Charts Showing Fewer Data Points

Muhammad Talha Oct 1, 2026 868 views

Question details

The user needs to understand why a scatter chart seems to be missing data points compared to the actual number of entries in the source data series.

Why Do Excel Scatter Charts Show Fewer Points Than the Source Data?

Product: Microsoft Excel / WPS Spreadsheet
Device & OS: not provided
Scenario: Visualizing two-dimensional data with X and Y values using a scatter chart.
Observed behavior: The generated scatter chart displays visibly fewer marker points than the number of rows present in the source dataset.

Before you start

Verify that your chart data range encompasses all the intended rows and that no accidental data filters are hiding parts of your source columns.

Solution 1Recommended

Reveal Overlapping Scatter Chart Points

Adjust chart formatting and settings to confirm that the 'missing' points are actually overlapping due to identical or very similar coordinate values.

When multiple rows in your dataset share the exact same X and Y coordinates (or coordinates that are extremely close), the chart plots them in the same physical space. This overlap creates an optical illusion, making it look like the chart contains fewer points than the actual data series.

You can easily verify that the data is still included by changing the marker formatting or zooming in on the chart axes.

Inspect the Source Values

Review your X and Y columns in the spreadsheet to look for duplicate coordinate pairs that would naturally stack on top of each other.

Apply Data Labels

Right-click a data point on the chart, select 'Add Data Labels', and check if multiple labels cluster over a single visual marker.

Adjust Marker Transparency

Right-click the data series, choose 'Format Data Series', navigate to marker fill options, and increase the transparency. Overlapping dots will appear darker than single dots.

Zoom In on the Axis

Double-click the X or Y axis to open axis formatting, and temporarily reduce the minimum and maximum bounds to zoom tightly into clustered areas.

No Missing Data: Rest assured, the spreadsheet software is plotting all selected data rows; the visual reduction is purely due to identical coordinate mapping, not a data loss error.

Use WPS Spreadsheet for Data Visualization

Easily Manage and Format Scatter Charts with WPS Spreadsheet

WPS Spreadsheet provides intuitive charting tools to visualize your data effortlessly. You can quickly adjust marker transparency, modify axis bounds, and add data labels to spot overlapping data points with just a few clicks.

1. Insert a Scatter Chart: Open your dataset in WPS Spreadsheet, select your X and Y columns, go to the 'Insert' tab on the top ribbon, and click the 'Scatter' icon.
2. Access Data Series Formatting: Right-click on any data point in your generated chart and select 'Format Data Series' from the context menu to open the right-hand properties pane.
3. Adjust Marker Transparency: Navigate to the 'Fill & Line' settings in the pane, and increase the marker fill transparency so overlapping dots become darker and clearly visible.
4. Add Data Labels: Right-click the plotted points again and choose 'Add Data Labels' to easily verify if multiple values are clustered on a single coordinate.

Fully compatible with Microsoft Excel (.xlsx) formats and chartsIntuitive chart formatting pane to quickly adjust marker transparencyEasily add data labels to reveal identical valuesLightweight, fast, and free to use for daily tasks

microsoft office alternative - wps office

Frequently Asked Questions

Can I prevent data points from overlapping in my scatter chart?

While spreadsheets don't have a built-in 'jitter' function, you can manually prevent overlap by adding a very small random value using the RAND() function to your source data. This will slightly offset overlapping points making them individually visible.

Why are blank cells not showing on my scatter chart?

By default, scatter charts ignore empty cells. You can change this by right-clicking the chart, selecting 'Select Data', and clicking 'Hidden and Empty Cells' to choose how blanks are plotted (e.g., as zero or connected with a line).

Do hidden rows affect the number of points on a scatter chart?

Yes, if your source data contains hidden rows or is filtered out, those points will not be displayed on the chart. You must configure the chart via 'Select Data' -> 'Hidden and Empty Cells' to show data in hidden rows and columns if you want them visible.

Excel & Data Problems