Scatter plots are linear graphs similar to line 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
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
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
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
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.