1
Select your data
Highlight the cells to chart, including the header row - here, hours studied and test scores.
How to make a scatter plot in Google spreadsheet
Plot two number columns against each other to see whether they are related.
Accounting & Finance
2
Click Insert
Open the Insert menu.
3
Click Chart
Choose Chart. A chart appears and the Chart editor opens.
4
Click the Chart type box
In the Chart editor, open the Chart type list under Setup.
5
Click Scatter chart
Pick Scatter chart from the list.
6
Scatter plot created
Each dot is one row: its position shows both values. Add a trendline from Customize > Series.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.