We often come across situations when two numerical values are somehow related to each other, without any one-to-one correlation between the two numbers. For example, the height and weight of an individual. With increasing height, it is normal for the weight to increase. There are several everyday situations when we can find the same correlation between two numeric values.
If you are working in a spreadsheet program like Google Sheets, the best way you can plot the values in a graph is by using a scatter plot graph. Just like other types of graphs in Google Sheets, it is also possible to do a scatter plot in Google Sheets. The process is easier than you might think.
So, without any further delay, let’s get started with how to do a scatter plot in Google Sheets.
Steps to do a scatter plot in Google Sheets
Open Google Sheets, and enter the values. You can alternatively open a sheet containing the values.
In the screenshot below, we have a sheet that has data that has the age and weight of some unknown individuals, and we want to use a scatter plot to establish the correlation between height and weight.
![Scatter plot in Google Sheets 10 Scatter plot in Google Sheets 10](https://www.how2shout.com/wp-content/uploads/2023/11/Scatter-plot-in-Google-Sheets-10.png)
Select the data, i.e. the cells containing the values, click on ‘Insert’, and hence click on ‘Chart’.
![Scatter plot in Google Sheets 20 open charts](https://www.how2shout.com/wp-content/uploads/2023/11/Scatter-plot-in-Google-Sheets-20.png)
It is possible that Google Sheets will automatically recognize the data and will present a scatter plot based on the values.
However, if this is not the case, click on the triple-dot menu on the top right corner of the chart, and click on ‘Edit chart’.
![Scatter plot in Google Sheets 30 Scatter chart](https://www.how2shout.com/wp-content/uploads/2023/11/Scatter-plot-in-Google-Sheets-30.png)
In the ‘Setup’ tab, click on the drop-down menu corresponding to ‘Chart type’ and select ‘Scatter chart’.
You can also choose which one you want to plot across X-axis, by clicking on the button below ‘X-axis’.
![Scatter plot in Google Sheets 40 Scatter plot in Google Sheets 40](https://www.how2shout.com/wp-content/uploads/2023/11/Scatter-plot-in-Google-Sheets-40.png)
So, that’s basically how to do a scatter plot in Google Sheets. If you want to customize the graph, simply click on the ‘Customize’ tab.
![Scatter plot in Google Sheets 50 customize Scatter plot](https://www.how2shout.com/wp-content/uploads/2023/11/Scatter-plot-in-Google-Sheets-50.png)
Here you can change the color of the dots in the ‘Series’ drop-down menu. Apart from the color of the dots, there are other aspects too, that you can edit.
In the ‘Chart style’, you can set the background and border color, font, etc.
You can customize the horizontal and vertical axes, gridlines, etc., by clicking on the respective drop-down menus.
![Scatter plot in Google Sheets 60 70 80 90 Scatter plot in Google Sheets 60 70 80 90](https://www.how2shout.com/wp-content/uploads/2023/11/Scatter-plot-in-Google-Sheets-60-70-80-90.png)
The customization options in the case of scatter plots are just like any other chart customization options available in Google Sheets.
So, that’s all about how to do a scatter plot in Google Sheets. Do you have any further questions regarding the topic? Feel free to comment on the same below.
Related Posts
How to create email groups in Gmail? Send one email to multiple recipients in a matter of seconds.
Getting the right dashcam for your needs. All that you need to know
How to Install 7-Zip on Windows 11 or 10 with Single Command
How to Install ASK CLI on Windows 11 or 10
How do you install FlutterFire CLI on Windows 11 or 10?
How to create QR codes on Google Sheets for URLs or any other text elements