How to Label Points on a Graph in Google Sheets

Adding labels to your data points in Google Sheets transforms a simple chart into a clear, compelling story. Instead of making viewers guess what your data means, labels provide instant context, highlighting key information exactly where it’s needed. This guide will walk you through several easy-to-follow methods for adding and customizing data labels on different types of graphs, from basic bar charts to more complex scatter plots and pie charts.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Before You Begin: Key Concepts

Before we start adding labels, it’s helpful to understand a couple of core concepts in Google Sheets charts. This will make the instructions that follow much clearer and more intuitive.

• Data Series: This refers to a set of related data points plotted on your chart. For instance, in a bar chart showing monthly sales, each bar represents a single data point, and all the bars together form a "sales" data series. You can have multiple series on one chart, like sales and expenses plotted side by side.
• Chart Editor: This is the control panel for everything related to your chart's appearance and data. You can access it by double-clicking on your chart. It has two main tabs: Setup (for defining what data to display) and Customize (for changing how it looks). We'll be spending most of our time in the Customize tab.
• Label vs. Legend: A label is text attached directly to a specific data point (like a bar, a slice of a pie, or a point on a line) to provide its exact value or a descriptive name. A legend is a key that explains what the different colors or shapes in your chart represent, usually displayed on the side or bottom of the chart. This tutorial focuses on labels.

Labeling All Data Points in a Series

The simplest way to add context to a chart is to label every data point with its value. This is perfect for when you want your audience to see the exact numbers behind each part of the graph. Let's use a standard column chart as an example.

Step 1: Get Your Data Ready

Imagine you have a simple dataset tracking website traffic by source for a given month. Your sheet would look something like this:

This is a straightforward table with one column for categories (the traffic source) and another for values (the number of sessions).

Step 2: Create Your Column Chart

Creating the chart is simple:

1. Select the entire data range, including the headers (in this case, cells A1 through B6).
2. Go to the menu and click Insert > Chart.
3. Google Sheets will automatically suggest a chart type. If it doesn't default to a column chart, you can change it in the Chart editor panel on the right under Chart type.

You should now have a basic chart that visually represents your traffic data.

Step 3: Add and Position the Data Labels

With your chart created, it's time to add the labels.

1. Double-click on your chart to open the Chart editor.
2. Navigate to the Customize tab.
3. Click on the Series dropdown menu.
4. Check the box for Data labels. As soon as you do, you'll see the session numbers appear on or near each column in your chart.

Once enabled, you have several options to customize how these labels look:

• Position: By default, Google Sheets tries to pick the best spot, but you can force labels to appear inside the top of the bar (Inside end), at the base (Inside base), in the middle (Center), or just outside the bar (Outside end). Choose the option that provides the most clarity. For columns, Outside end is often the cleanest look.
• Label font, format, and color: You can also adjust the font, size, format (bold, italic), and color of your labels to match your report's branding or to improve readability.

This method applies to most common chart types, including bar charts, line charts, and area charts. It’s a quick and effective way to make your data more transparent.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Labeling Specific, Individual Data Points

Sometimes, labeling every single point adds too much clutter. Instead, you might want to highlight just one or two key data points — like the highest sales month, a specific campaign launch, or an outlier that needs explanation. Google Sheets doesn't have a simple one-click option for this, but with a clever workaround, you can add labels to any individual point you choose.

We'll use a scatter plot for this example, a chart type that often benefits from labeling specific points of interest.

Step 1: Set Up Your Data with a Dedicated Label Column

Let's say we're tracking ad spend versus conversions for different campaigns. We have campaign names, the ad spend (X-axis), and the number of conversions (Y-axis).

The key to labeling individual points is to add a third column to your data. This new column will serve as the source for our custom labels. In this column, you only enter text in the rows corresponding to the data points you want to label. Leave the rest of the cells in this column blank.

For example, if we want to call out only the "Winter Sale" and "Holiday Promo" campaigns, our data would look like this:

Step 2: Create the Scatter Plot

1. Select the first two columns of data (Ad Spend and Conversions). For now, ignore the labels column.
2. Go to Insert > Chart.
3. In the Chart editor, change the Chart type to Scatter chart.

You'll see a chart with unlabeled data points representing each campaign.

Step 3: Use the Third Column to Add Labels

Now, we'll tell Google Sheets to use our new "Campaign Label" column for the labels.

1. In the Chart editor, under the Setup tab, find the data range listed for your series. In this case, it will likely be something like "B1:B7" for the "Conversions" series.
2. Find the option for Add label and click on the square grid icon.
3. A "Select a data range" box will pop up. Click it and select your dedicated label column (in this example, C1:C7). Click "OK."

Instantly, Google Sheets will apply the labels to the corresponding data points on your chart, leaving the others unlabeled. You have now successfully highlighted only the data points you wanted to call out.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Customizing Pie Chart Labels

Pie charts have some unique labeling needs. By default, Google Sheets can label slices with their percentage or value, but what if you want more control, like combining text and value, or only labeling one slice?

This requires a slightly different approach.

Step 1: Get your data in shape:

For custom pie chart labels, start with your dataset as usual, but then add a column where you'll create the exact label text you want.

For instance, to combine the category name with its percentage, you could use a formula:

=(A2 & " - " & TEXT(B2/SUM(B$2:B$6), "0%"))

This formula grabs the traffic source from cell A2, joins it with the percentage value (calculated from its portion of the total), and formats it nicely.

You could also simply type your custom labels manually into this column.

Step 2: Create a pie chart

1. Go to Insert > Chart and select Pie chart. The Sheet will autogenerate a default Pie Chart Visualization.

Step 3: Enable 'Use row 1 as headers' to create custom labels

1. Now open the Chart Editor and from the Setup Menu, you see options below for "Use Labels". But since you are using two columns ("Source" and "Sessions"), a legend with default labels is shown instead of your own text labels.
2. The solution is to enable Use row 1 as headers. When on, you'll notice in the Labels list below that now you can select which text will go as your label. In this example, it is our 'Source Column'.

Step 4: Let the magic happen

Once you’ve selected the Label column as Source, your chart will instantly update each pie slice to show your custom text labels directly on the chart slices.

From here, you can go to the Customize > Pie chart menu on the same Chart editor tab to adjust the font size, color, font label color, and style, ensuring your new custom pie chart labels on the slices are easy to read.

That's it! Following these steps and adding data value to some key selected cells can really help the key part of the information you want to communicate be more impactful. Try adding the value, the category, or even using both. Just be careful not to label them all, which can render them useless because when every part stands out, none of them excel.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Rotate Data labels (To Vertical)

Sometimes you’re working with long text in your header column that just doesn't fit in your graph visualizations. Most times these labels will be displayed horizontally with ellipsis signs indicating the missing full-text string ( ... ) like these examples here:

/your-category/long tailed-page-2-content ... Social Media via Facebook campaign.. My Awesome Prod..

This is quite often not readable information, so changing your category Axis text from horizontal to 90 degrees vertical can save your day and make it easier to read for your customers or team.

Google Sheets offers an easy settings change from inside your "Chart editor" for rotating your axis orientation. Rotating your labels is something it applies to all your chart-generated Axis from Sheet’s Cells and this can be easily changed inside your ‘Chart editor settings.

Step: Find your Axis and Degrees in customization Menu options of the editor.

1. Once your visual Chart is generated, double click on it. The Sheets "Chart editor" will pop up.
2. Now, since we want to rotate to 90 º Vertical degrees, the bottom labels (known as Horizontal axis labels) are in the Customize > Horizontal menu where our option will reside. So from Customize > Horizontal then the "Slant level" option is what needs changing. Slant levels allow ascending angles from Auto, 30°, 60°, and up to a perfect 90° degrees. Example images for demonstration show a before and after look.

BEFORE look. Then ... the AFTER one after the setting changes is completed:

Final Thoughts

Learning how to properly label data points transforms your Google Sheets charts from simple visuals into powerful communication tools. By strategically adding labels — either to an entire series, to individual points, or in a custom format — you guide your audience directly to the most important parts of your data story, making your reports clearer, more efficient, and far more impactful.

As you build more reports, you'll find that connecting your key data sources and keeping everything up-to-date can be time-consuming. We built Graphed to solve this. Instead of manually updating Sheets, you can connect your advertising platforms, CRM, and analytics tools like Google Analytics directly. With Graphed , you can simply ask for the chart you need in plain English - like "show me ad spend vs. conversions by campaign" - and get a real-time dashboard that updates automatically, saving you from any manual data prep.