How To Make A Scatter Plot In Google Sheets
Scatter plots are useful to display the correlation between two data sets, especially when the data comes from noisy measurements so the points do not line on a smooth curve.
Google Sheets makes it quick and easy to generate scatter plots from spreadsheet data.
When your data updates, the scatter plot will automatically update to reflect the change.
Scatter plots need:
- A set of data for the X-Axis of the scatter plot
- A set of data for the Y-Axis of the scatter plot
Insert a Scatter Plot in Google Sheets
To insert a Scatter Plot in Google Sheets, follow these steps:
Select the data range you want to plot. Be sure to include the headers as these will be used to label the axes in the plot
Open the Insert menu, and select the Chart option
A new chart will be inserted as a floating element above the cells, and the Chart Editor sidebar will appear with options to edit the chart.
To turn this chart into a scatter plot, click on the Chart Type dropdown menu and select the Scatter Chart option:
Your chart will update to a scatter plot
Editing Your Scatter Plot
To edit a chart you’ve already created, first open the Chart Editor for that graph by selecting the chart and clicking on the 3 dot menu icon in the corner of the chart.
From the menu that appears, select Edit Chart. The Chart Editor for that graph will open:
You can then make edits to the chart type, data range, or any of the other chart settings available in the Chart Editor and your chart will update to reflect the changes
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make a scatter plot in Google Sheets. Want more? Check out all the Google Sheets Tutorials.