New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Create a scatter plot

Google Sheets · Verified tutorial

Create a scatter plot in Google Sheets

Create a scatter chart from B1:C5 using Revenue for the horizontal axis and Orders for the series.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Create a scatter chart from B1:C5 using Revenue for the horizontal axis and Orders for the series.

Step-by-step

1

Select the targetCreate a scatter chart from B1:C5.

2

Apply the changeRevenue for the horizontal axis and Orders for the series.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A scatter chart uses the complete B1:C5 data range.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select B1:C5 and repeat the final action. A scatter chart uses the complete B1:C5 data range.

Example spreadsheet data

This is the clean fixture used for the verified run.

Month	Revenue	Orders
January	120	8
February	180	12
March	240	16
April	210	14

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a scatter chart from B1:C5.
Apply the change. Revenue for the horizontal axis and Orders for the series.
A scatter chart uses the complete B1:C5 data range.