Build scatter and bubble charts for numeric relationships in Apple Numbers

Quick answer: Add a 2D scatter chart and select x and y columns in that order. For a bubble chart select x, y, and size columns; inspect Edit Data References after adding observations so every intended row is included.

A scatter chart answers “where is each observation on two numeric scales?” A bubble chart adds a third measure. Build both from the same four fictional outreach sessions so you can check that size has not accidentally become another y-series.

Prepare the numeric fixture

In Numbers on Mac choose File → New and the Blank template. Use its first sheet, Sheet 1, and first table, Table 1, throughout. Select the table; in Format → Table set five rows and three columns, one header row, zero header columns, and zero footer rows. Enter A1:C5 below. Labels belong only in row 1; enter body values as numbers, without units typed into the cells.

Hours	Replies	Attendees
1	10	4
2	18	9
4	26	16
7	30	25

The four coordinate pairs are (1,10), (2,18), (4,26), (7,30). X-spacing is 1, 2, then 3 hours, rather than equal category spacing. Attendees total 54; this is a data cross-check, not a quantity displayed by the chart. Save this starting spreadsheet as relationships-before.numbers in a local Numbers Practice folder you control. Use File → Save As to create relationships-work.numbers there before adding charts.

Draw and inspect the scatter chart

1. Click blank canvas on Sheet 1, then Chart → 2D Charts and choose the scatter thumbnail. Select the new chart and click Add Chart Data.
2. In Table 1, select column A and then B using their lettered bars. In the bottom selection menu choose Plot Columns as Series. Click Done.
3. Inspect the chart against all four coordinate pairs above. There should be one series with four observations, not two y-series or four unrelated series. Place the chart below the table by dragging its outer area.

Apple documents that the first selected column supplies x and the second supplies y. Do not include C in this scatter selection: it would introduce another y-series, not bubble sizes. The toolbar’s 3D choices are not the place to find scatter or bubble charts.

Add the bubble comparison

1. Keep Sheet 1 active. Click its blank canvas, then Chart → 2D Charts and choose the bubble thumbnail. Select this new chart, then Add Chart Data.
2. Select Table 1 columns A, B, and C, in that order. Choose Plot Columns as Series and click Done. Move this chart beside the scatter chart, leaving the table visible.
3. Check four bubble centers against the original coordinate pairs. The observation at (7,30) should have the largest size value, 25; (1,10) the smallest, 4. Do not read a value from bubble diameter or assume the radius is proportional to attendance. Use C for exact values.

Change one measure and grow the source

In Table 1, change B3 from 18 to 22. Both charts should move the x=2 observation upward by four replies, without changing x or attendance. Next change C3 from 9 to 36: only the bubble size encoding changes, and that observation now has the largest size value. These are separate diagnostic edits.

Add row 6 using the table’s Rows control and enter 9, 34, 12 in A6:C6. Inspect each chart’s Edit Data References separately. If the new row is outside a selection, select that series’ dot and extend its selection box through row 6; retain A:B for scatter and A:C for bubble, then Done. Do not assume expansion occurred just because a row exists.

Expected final data: five observations; the scatter includes (2,22) and (9,34); the largest bubble belongs to x=2 with size 36. Final totals are 122 replies and 93 attendees. These totals verify the fixture only; they are not chart totals or evidence of causation.

Save, recover, and troubleshoot

Save the completed work as relationships-final.numbers in Numbers Practice using File → Save As. Close and reopen that exact file; check both charts, five rows of observations, and the changed cells. This is a reader verification step, not an author-tested outcome.

For an optional reset, first choose File → Save As and save a separate relationships-reset.numbers in Numbers Practice. Confirm that relationships-reset.numbers is the active filename at the top of the window before making any reset edits. In that copy restore B3 to 18, C3 to 9, remove row 6, and inspect both reference ranges again through row 5. Never rely on Undo after reopening. The final file remains your five-observation example.

• Missing data: check reference ranges and that there are no filters or hidden rows.
• Equal x-spacing: check that you chose scatter rather than a category line chart and that A contains numbers.
• Unexpected extra series: select the affected chart and inspect its references; C belongs only in the bubble example.
• No edit controls: select the chart object first; a locked chart must be unlocked before changing it.

The independent fixture arithmetic checks the stated coordinates and totals. It does not establish native chart rendering, bubble scaling, or selection behavior.

For a row-removal step in a reset copy, point to that row’s number, click its menu arrow, and choose the delete-row command. Check the row’s label or values before deleting it. Header/footer counts are set with the Headers & Footer pop-up menus on Format → Table.

Scope and verification

Numbers 15.4 for Mac; documentation-qualified desktop workflow. Numbers on iPad, iPhone, and iCloud are not covered by these controls or checks. Apple’s cited guide identifies version 15.4; check Numbers → About Numbers on your Mac. This article was checked against first-party documentation on 2026-10-19. No native Mac application was available for execution, so the steps, save/reopen outcomes, and accessibility behavior remain untested in the application. No native screenshots are supplied; generated diagrams or website screenshots would not prove product behavior.

Official sources

• Welcome
• Scatter
• Chart Data
• Save
• Rows and headers

Related tutorial

See Create a chart in Numbers for the related workflow.