How To Make A Scatter Plot In Google Sheets

In this tutorial, you will learn how to make a scatter plot in Google Sheets.

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:

  1. A set of data for the X-Axis of the scatter plot
  2. 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:

Step 1

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

Step 2

Open the Insert menu, and select the Chart option

Step 3

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:

Step 4

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

Summary

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.