How to Make a Scatter-Plot in Google Sheets

Scatter plots are linear graphs that show you varying data over time. I will show you how to make one in Google Sheets in Just a few steps.

Step #1: Set the Axes

How to Make a Scatter-Plot in Google Sheets Step 1

You will need a data table with at least two columns: one to set the x-axis, and one to set the y axis. 

The X-Axis will typically be some sort of variable counter, whether it is a trial number or some time frame. in this case, the x-axis will be the 12 months of the year. 

The Y-axis will be some numerical value associated with the parallel Y-Axis Cell. In this case, it is some random number between 1 and 6. 

Step #2: Insert Chart

How to Make a Scatter-Plot in Google Sheets Step 2

Next, highlight your entire data table and click Insert on the toolkit located in the header. Then, in the drop-down menu, select the Chart option. That will insert a line graph with the data from your table ported into chart form.

Step #3: Select Scatter-Plot 

How to Make a Scatter-Plot in Google Sheets Step 3

In the chart editor menu, you will see an option to select the Chart Type.  This will open a massive catalogue of different charts that you can create.

As you scroll down, you will see the Scatter option. Select that, and it will transform your line graph into a scatter-plot. 

Step #4: Customize

How to Make a Scatter-Plot in Google Sheets Final

In the chart editor, you will also see the Customize menu. This will let you edit and correct your scatterplot until you get what you want out of it.


And there you have it, that is how you create a Scatter-Plot in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!