How To Add Data Labels In Google Sheets

In this tutorial, you will learn how to add data labels in google sheets.

Charts and graphs are a good way to easily visualize numerical data and Google Sheets makes it simple to insert them in just a few clicks, so it’s no wonder they’re used all the time in Google Sheets. However, sometimes you might need to know the exact value of a particular datapoint on the chart. Reading charts with a lot of precision is difficult but, fortunately, you can have the benefits of graphs and the precision of numerical data by adding labels to data points in Google Sheets. Read on to learn more

Adding the Graph

First before we can add data labels, we need a graph. For this example, we’ll use a scatter plot since data labels are easy to read on them, but you can also add data labels to bar, column, area, line, waterfall, or histogram charts using this same method. Here’s how to a chart:

Step 1

Select the data you want to chart. For a scatter plot you’ll need two columns of data: One for the X-axis and one Y-axis

Step 2

Open the Insert menu and choose Chart

Step 3

In the Chart Editor sidebar, under Chart Type, choose Scatter chart

Step 4

The chart will be inserted as a free-floating element above the cells. Drag and drop to position it as needed

Adding Data Labels

Once you’ve inserted a chart, here’s how to add data labels to it:

Step 1

Double-click the chart to open the chart editor again if it’s closed

Step 2

Switch to the Customize tab, then click on the Series section to expand it

Step 3

Scroll down in the Series section till you find the checkbox for Data Labels and click it

Step 4

The data labels will appear on the chart

Step 5

You can adjust the appearance of the data labels by editing the data label formatting options

Step 6

Or edit the value of individual data labels by double clicking on the label in the chart and typing the new value

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add data labels in google sheets. Want more? Check out all the Google Sheets Tutorials.