In this tutorial, you will learn how to add labels to scatterplot points in Google Sheets.
How to Add Labels to Scatterplot Points in Google Sheets
Dots are used to represent values for two different numeric variables in a scatter plot. The values for each data point are indicated by the position of each dot on the horizontal and vertical axes. Scatter plots are used to see how variables relate to one another.
The fundamental purpose of a scatter plot is to observe and display relationships between two numeric variables. In a scatter plot, the dots show the values of individual data points and patterns when the data is viewed as a whole.
Adding labels on each scatterplot point will allow better visualization of the overall chart. Once you are ready, we can get started by using real-life scenarios to help you understand how to add labels to scatterplot points in Google Sheets.
Add Labels to Scatterplot Points
Assuming we already have a scatterplot on our Google Sheet, we will now learn how to add the labels on each point.
Double click on the scatterplot chart to access the Chart Editor. The Chart Editor will appear on the right side of your screen.
Next, click Customize, click Series, and tick Labels.
Now we can customize the labels to our preferences. In this example, we will place the label Position to be Below, increase the Font Size to 20, Bold the label, and make sure the Text Color is set to Auto to match the point color.
Once you are done editing and customizing the labels, it will look something like this.
That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make categories in google sheets. Want more? Check out all the Google Sheets Tutorials.