How To Create A Scatter Plot Using Google Sheets

In this guide, we will show you the steps to create a scatter plot using Google Sheets. This online spreadsheet tool from Google allows you to carry out a...

Syed Sadique Hassan

Last updated on April 6, 2023

Syed Sadique Hassan

Author

Did his MBA from Delhi but then something about the Android ecosystem intrigued him so much that he made Tech Blogging his permanent job. And now there's no looking back.

How to Create a Scatter Plot using Google Sheets

There could be quite a few instances where you might need to make use of this plot. For example, in establishing a correlation between employees’ salary and their work experience, the demand for ice-creams with the rise and fall in temperature among others.

While you could also use graphs to showcase the trends between the variables, however, they aren’t able to paint the complete picture and rather tends to over complicate the matter. So with that said, let’s now check out the steps to create a scatter plot using Google Sheets.

Creating Scatter Plots

two values y axis

First and foremost, you will need data formatted for this plot. So start off by creating two or more columns of data in Google Sheets. The first column will act as data for the X-axis whereas all the other columns will represent the data on the Y-axis.
For the sake of simplicity, let’s take two columns of data which will act as the X and single Y-axis. Likewise, label both these columns as they would be acting as the titles for the axis.
Now select all the data (including the header) and go to Insert > Chart.
This will open the Chart Editor.
Go to the Setup section and select Scatter Chart from the Chart Type drop-down menu.
This will create a scatter chart for the selected data, as shown in the above image.

Creating Multiple Data Scatter Plots in Google Sheets

two values y axis

As of now, we were dealing with a single Y-axis variable. But as mentioned before, you could also add multiple Y-axis variables by creating more column data. In the below example, we have created Month as the first column, so it will act as the X-axis. After this, the other two columns of Expense and Revenue will act as the Y-axis. The scatter chart of this data in Google Sheets will look similar to the one that we have shared above.

Creating a Bubble Scatter Chart

Along the same lines, if you have multiple Y-axis variables, you could use a Bubble Scatter Plot. As above, the first 2 dimensions are the horizontal (X) and vertical (Y) axes. The third dimension will act as the size of the bubble. The steps to create a Bubble Scatter chart is quite similar to the normal scatter chart in Google Sheets. You just need to have the data properly formatted, as mentioned below:

bubble scatter plot

First Column: Type in a label that will show up inside the bubble.
Second Column: In this column, enter the values for X-axis.
Third Column: Here, enter the Y-axis values. Each column of Y-values will show as a series of points on the chart.
Fourth Column: Enter the name of the data series, where each data series is a different color.
Fifth Column: Finally, enter a number for the size of the bubble.
Rows: Do keep in mind that here each row represents a bubble on the chart.

bubble chart

Select all the data (including the header) and go to Insert > Chart. Now under the Chart Type section, scroll to the Scatter section and select Bubble Chart. The corresponding chart of the selected data will now be created, as shown in the above image.

Customizing Scatter Plots

You could also customize the scatter plots that you have just created via Google Sheets. To do so, bring up the Chart Editor via Insert > Charts. Then go to the Customize section and you may now make changes to the Chart Styles, edit its axis titles, change point colors and axis location, or even could even change the legend position. Likewise, you could also edit or format X and Y-axis texts or add and edit gridlines. You could also customize the look of the Bubbles (in the case of Bubble Scatter Plot).

customize scatter plot sheets

So with this, we conclude the guide on how to create a scatter plot using Google Sheets. We have also shared the instructions to create multiple data plots and the Bubble Scatter plots and the steps to customize them. If you have any queries concerning the aforementioned steps, do let us know in the comments section below. Rounding off, here are some iPhone Tips and Tricks, PC tips and tricks, and Android Tips and Tricks that you should check out as well.

How To Create A Scatter Plot Using Google Sheets