Check Numeric X Spacing and Coordinate Pairs in a Google Sheets Scatter Chart

Quick answer

A scatter chart uses numeric coordinates, not equal-width slots for category labels. Put X in the first column and its paired Y in the next column. Each data row supplies a point. Google’s scatter chart reference describes that layout; the example below makes an incorrect categorical axis easy to notice.

Prepare four deliberately uneven X positions

Use the desktop browser version of Google Sheets and a disposable native spreadsheet you can edit. These are rolling documented controls checked on 21 October 2026, not a tested browser/build combination. No account action, paid add-on, screenshot or native chart rendering was performed. Expected coordinates and arithmetic were independently checked outside Sheets.

On a tab named Coordinates, enter A1:B5:

Input X	Response Y
1	3
10	21
2	5
11	23

This is invented demonstration data, not experimental evidence. Every pair satisfies Y=2X+1. The input order is intentionally not sorted. Enter =SUM(A2:A5) in D2 and =SUM(B2:B5) in E2; expected totals are 24 and 52. Label D1 X control and E1 Y control so the checks cannot be mistaken for extra chart series.

Do not sort just column A. The pair (10, 21) must stay together, as must(2,5). Sorting one column independently would change the meaning of the observations without necessarily changing either control total.

Select the numeric chart type and source

Select A1:B5, then Insert → Chart. Double-click the chart to open its editor. Under Setup → Chart type, choose Scatter chart. Confirm Data range is A1:B5, with Input X as the horizontal values and Response Y as the single series. If row 1 is being treated as data, use the header setting. Google’s chart creation and editing guide documents the chart-type, data-range and header controls.

Give the chart a title such as Synthetic response versus input. Through Customize → Chart & axis title, label the horizontal axis Input X (arbitrary units) and vertical axis Response Y (arbitrary units). Keep ordinary linear axes for this exercise; do not enable a logarithmic scale. This is a coordinate check, not a styling contest.

Verify geometry rather than row order

Read the horizontal tick values and inspect the four expected pairs:

• (1,3) and (2, 5) form the lower-left pair.
• (10,21) and (11, 23) form the upper-right pair.
• The X gaps in numeric order are 1,8,1.

On a linear numeric axis, the middle gap represents eight times either small gap. Pixel distances depend on your chart size and axis bounds, but the data distances do not. Four equally spaced category positions labeled 1, 10, 2, 11 would fail this check even if all labels were visible.

The four points should lie on one straight line for this exact synthetic dataset. That is a consequence of the numbers chosen, not evidence that one real-world variable causes another. No trendline or prediction is necessary to validate this example; see the general chart guide for that separate control.

Change one coordinate and test the range

Change B3 from 21 to 16, leaving A3 at 10. Only the point with X = 10 should change vertically, from (10, 21) to (10, 16). The X total remains 24; the Y total becomes 47. The affected point is now 5 units below the original rule 2X + 1. If a different point moves, inspect the source pairings and chosen series before trusting the chart.

Restore B3 to 21. Next append A6 = 20 and B6 = 41. An explicitly configured A1:B5 range excludes that new row. Rather than assuming automatic expansion, inspect the displayed Data range and deliberately set it to A1:B6. The resulting intended dataset has five pairs, X total 44 and Y total 93; extend the control formulas to row 6 as well.

If you prefer the original four-point practice file, remove the added row values and restore the chart range and controls to row 5. Keep the version you intend to save internally consistent.

Troubleshooting and reopening

If a point is absent, check for numeric values and whether its whole row is inside the configured range. If the chart has several unexpected series, remove the control columns from the source selection. If values appear correct but their pairing is suspicious, compare each row with the original table; totals alone cannot detect all pairing errors.

Wait for saving, reopen the practice file yourself and recheck the chart type, range and exact pairs. Native persistence, tooltip behavior and export fidelity were not tested here. This guide covers one numeric X/Y series; histogram binning and bubble-size layouts need their own data preparation and are not established by this exercise.