How to Make a Scatter Plot in Google Sheets (Complete Guide)

how to make a scatter plot in google sheets 46

In this article, we will learn how to make a scatter plot in google sheets, why scatter plot?

A Scatter plot is a chart built-in google sheets, it is a data chart that visually represents the analysis of the data, its interpretation is easy, and it shows the graphical data, both linear and non-linear we will see how can we make a scatter plot with our data to see how it efficiently reflects our data.

Advantages of using Scatter Plot in Google Sheets

As we all know that we use tabular data in google sheets, most of the time need to have tables, and we want to represent long tabular data with the help of a pie chart, bar chart, line chart, and many common charts available free in google sheets. But here we want to see the linear growth of the sales, we want to track the sales and downscales for each phase so we can plan the marketing strategy accordingly for the liner and non-linear representation of the data we use scatter plot, it is very easily describes the up and down points on each phase and clarify the that what needs to be changed. So, this is the reason we are learning it, and we all should learn it to make our data more presentable and communicative.

See also  What Does $ Mean in Google Sheets [User Guide]

How to Make a Scatter Plot in Google Sheets

Google sheets provide many built-in charts for data presentation and visualization, in a long list of charts we have a scatter chart, also known as a scatter plot, it makes a plot based on given data points and makes an understandable plot of points that we got during a phase of time. We can use it on already written data, so we must have data before we are going to use a scatter plot chart in google sheets, it takes the data as input and renders our given data into a scatter plot, and returns a complete scatter plot with all its feature. We will learn it with the help of dummy data and we will experiment with that data with it and see how it behaves. Follow the below steps with me to make your own scatter plot in google sheets

Step 1: Fetch some data

how to make a scatter plot in google sheets 1

Step 2: Select all the data

how to make a scatter plot in google sheets 2

Step 3: Go to insert > Chart

how to make a scatter plot in google sheets 3

Step 4: Click on the drop-down icon at chart type

how to make a scatter plot in google sheets 4

Step 5: Scroll down and click on the scatter chart

how to make a scatter plot in google sheets 5

Step 6: Back to the sheet, the scatter plot is ready

how to make a scatter plot in google sheets 6

This is how you can easily make a scatter plot in google sheets following 6 easy steps.

See also  How to use NOT Function in Google Sheets [With Examples]

How to Make a Correlation Scatter Plot in Google Sheets

In this section, we will expand the previous section and will add the correlation function to our scatter plot, so will learn how to make a correlation scatter plot in google sheets.

For this, we will make X and Y data and find the correlation with scatter plots in google sheets. We will also talk about negative and positive correlations.

Step 1: Bring some demo data

how to make a scatter plot in google sheets 7

Step 2: Select all and go to insert > Chart

how to make a scatter plot in google sheets 8

Step 3: Select scatter chart

how to make a scatter plot in google sheets 9

Step 4: In an empty cell, start writing the correlation formula.

how to make a scatter plot in google sheets 10

Correlation formula can be written as =CORREL(A2:A11,B2:B11)

how to make a scatter plot in google sheets 11

how to make a scatter plot in google sheets 12

Step 5: Hit Enter, and you have the correlation value of the scatter plot chart

how to make a scatter plot in google sheets 13

This is how easily you can get the correlation value for the scatter plot chart, you can change the data and see the changes in the scatter plot if the correlation value is positive then it’s a positive correlation, and if minus then the correlation is minus.

See also  How to Do Cell Padding in Google Sheets (Best Practice)

How to Make a Scientific Scatter Plot in Google Sheets

So, in this section, we will dive deeper and will learn how to make a scientific scatter plot in google sheets. We represent scientific calculations and notations with the help of a scatter plot, and this scatters plot can be said as a scientific scatter plot in google sheets.

We will learn step-by-step about scientific scatter plots in this section. Let’s move further and see how it works.

Step 1: Add a scientific data (time and velocity in this example)

how to make a scatter plot in google sheets 14

Step 2: Select all and go to insert > Chart

how to make a scatter plot in google sheets 15

Step 3: Select scatter chart

how to make a scatter plot in google sheets 16

Step 4: In the chart editor, click on customize

how to make a scatter plot in google sheets 17

Step 5: Go to series

how to make a scatter plot in google sheets 18

Step 6: Check on trendlines, and data tables

how to make a scatter plot in google sheets 19

Step 7: Check on R2. Back to the sheet and you’re done.

how to make a scatter plot in google sheets 20

how to make a scatter plot in google sheets 21

This is how you can make a scientific scatter plot chart using google sheets built-in charts, and also you can use the customization button to use some great features of scatter plot.

See also  How to Sort by Column in Google Sheets (2 Methods)

How to Make an XY Scatter Plot in Google Sheets

So, in this section, we will see how to make XY scatter plots in google Sheets, scatter plots with XY coordinates are most commonly used for comparison purposes the values of x and y vary and represent the linear relationship between x and y coordinates. For this, we need data for x and y coordinates. Let’s write some data and get started to work with it.

Step 1: Create X and Y data

how to make a scatter plot in google sheets 22

Step 2: Select all and go to insert > Chart

how to make a scatter plot in google sheets 23

Step 3: Select scatter chart

how to make a scatter plot in google sheets 24

Step 4: Optional customization

how to make a scatter plot in google sheets 25

Check mark on Data labels

how to make a scatter plot in google sheets 26

Also, check in Trend Lin

how to make a scatter plot in google sheets 27

how to make a scatter plot in google sheets 28

how to make a scatter plot in google sheets 29

how to make a scatter plot in google sheets 30

Step 5: Back to sheet, you’re done.

how to make a scatter plot in google sheets 31

See also  How to Find Mean in Google Sheets [Easy Guide]

How to Make a Smooth Scatter Plot in Google Sheets

In this section we will talk about the smoothness of the scatter plot, so now we have made the scatter plot for different sorts of data from the scratch, in this section, we will only see how to make our scatter plot looks smoother, prettier, and clean.

Step 1: Remove chart title, and both axis title

how to make a scatter plot in google sheets 32

how to make a scatter plot in google sheets 33

how to make a scatter plot in google sheets 34

Step 2: Remove data labels

how to make a scatter plot in google sheets 35

Step 3: Low down the opacity of the trendline keep it at 60%

how to make a scatter plot in google sheets 36

Step 4: Replace dots with x and low down the size to 4px – 5px

how to make a scatter plot in google sheets 37

how to make a scatter plot in google sheets 38

how to make a scatter plot in google sheets 39

how to make a scatter plot in google sheets 40

Step 5: Remove R2

How to make a scatter plot in google sheets 40a

After doing the above steps, now you have a clean and smooth scatter plot that looks pretty good, and still represents the data to be understandable.

how to make a scatter plot in google sheets 41

See also  How to Freeze a Row and Column in Google Sheets

How to Make a Scatter Plot in Google Sheets with Two Sets of Data

In this section, we will see how to make a scatter plot in google sheets with two sets of data or more than one set of data, in this section, we will have to make two data sets for the demo and then we will see how our scatter plot build with two data sets, so start making your dummy data sets now.

Step 1: Make some dummy data (2 sets)

how to make a scatter plot in google sheets 42

Step 2: Select all and insert > Chart

how to make a scatter plot in google sheets 43

Step 3: Select scatter plot

how to make a scatter plot in google sheets 44

Step 4: Your scatter plot is created, and you can see the four columns’ data points are represented with different colors.

how to make a scatter plot in google sheets 45

Step 5(Optional): Use more customization features in your scatter plot

This is how to make a scatter plot in Google Sheets with two sets of data

See also  How to Change Cell Size in Google Sheets [3 Methods]

How to Add a Line to a Scatter Plot in Google Sheets

In this smaller section, we will see how to add a line to a scatter plot in google sheets, most of you have already got how to add this, but for those who did not get it, I will teach you how can you add a line.

Follow the easy steps below to add a line to a scatter plot in google sheets

Step 1:

Right-click on your scatter plot chart

how to make a scatter plot in google sheets 46

Step 2: Go to Series > and click on “Apply to all series”

how to make a scatter plot in google sheets 47

Step 3: Find the trendline checkbox and check on it, you can see the lines for each column have been added

how to make a scatter plot in google sheets 48

how to make a scatter plot in google sheets 49

This is how you can simply add a line to a scatter plot in google sheets.

See also  How to Insert Columns in Google Sheets

Important Notes on Scatter Plot in Google Sheets

  • A Scatter plot allows you to add as many data sets as you want, the only thing to keep in mind is the clarity and visibility. Make sure you don’t add too many data sets into one scatter plot chart.
  • A Scatter plot can be used for the comparison of data, in the customization, you can enable the comparison mode.
  • For a clean and more concise scatter plot chart, you can remove all the additional information and keep it simple with a light trendline and small data points.
  • You can set a custom name for chart title, horizontal axis title, and vertical axis title.
  • Always remember that scatter plots are used for visualities only you must have a data set ready to put into the scatter plot, you can’t create data directly with a scatter chart.

To recap, we learned many things about scatter plots in google sheets, we started with a basic scatter plot creation, and then we saw how to make a correlation scatter plot in google sheets, then we implement a scientific scatter plot in google sheets, and then we moved to an XY plot in google sheets in which we saw how can we use more customization features to make our scatter plot look more loaded with a lot of information, it’s not recommended, but it can be used if you require to provide extra information. We then moved to the smoothness of the scatter plot and we saw how to achieve maximum smoothness. then we worked on two data sets together and see how a to scatter plot automatically plots the four columned data with separate colors to make it more understandable, and in the last section, we saw how can we add a line to a scatter plot, this line is a trendline that shows the trend of the data.
See also  How to Apply Conditional Formatting IF Box is Checked in Google Sheets

Conclusion

So, if you’re here, I can surely say that you have learned a lot about scatter plots in google sheets from this comprehensive article, we tried to cover the most common methods and questions students have when they work with scatter plots in google sheets. We covered some most common use cases and also saw the customization of the scatter plot. I hope you have enjoyed the article and have learned a lot from this.

If yes, please share it with your buddies and let them learn some important tips and tricks regarding google sheets, for more updates please subscribe to our OfficeDemy blog. Thank you

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general