How to Label a Graph in Google Sheets

A graph without clear labels is just a collection of colorful shapes and lines. It might look interesting, but it doesn't tell a story or help anyone make a decision. This guide will walk you through exactly how to label every part of a graph in Google Sheets, turning your raw data into a clear, professional, and insightful visualization.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Clear Graph Labels Are Non-Negotiable

Before jumping into the "how," let's quickly cover the "why." Proper labeling is the foundation of effective data communication. Think of labels as the signposts that guide your audience through the data, ensuring they understand exactly what they're looking at. Without them, you leave things open to misinterpretation.

Well-labeled graphs ensure that:

• The story is clear: Your audience immediately knows the topic (from the title), the units of measurement (from the axis titles), and what different colors or shapes represent (from the legend).
• Insights are easily understood: Data point labels can highlight specific numbers, making it easy to see exact values without having to guess.
• Your work looks professional: Clean, well-formatted labels show attention to detail and build credibility with your team, clients, or manager.

First, Let's Create a Simple Chart

To label a chart, we first need a chart to work with. If you're already comfortable creating charts in Google Sheets, you can skip to the next section. If you're new to it, here’s a quick primer.

Let's use a simple dataset for a small business tracking its monthly website traffic. Your sheet might look like this:

To turn this into a chart:

1. Click and drag to highlight all the cells containing your data, including the headers (A1 to B5 in our example).
2. Go to the main menu and click Insert > Chart.

Google Sheets will automatically generate a chart for you - likely a line chart or a column chart, which works perfectly for this data. Now, the chart is on your sheet, but it's probably missing some crucial labels.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Chart Editor: Your Labeling Command Center

Your main tool for adding and customizing labels is the Chart editor. This sidebar pane gives you control over every aspect of your graph's appearance.

To open it, simply double-click anywhere on your chart. The Chart editor will appear on the right side of your screen. It has two main tabs:

• Setup: This tab is for changing the chart type, the data range, and the basic structure (like what goes on the X and Y axes).
• Customize: This is where you’ll spend most of your time. It contains all the options for formatting, styling, and - most importantly - labeling.

Step-by-Step: Adding and Customizing Key Graph Labels

With the Chart editor open to the Customize tab, let's go through the most important types of labels you'll need to add.

1. Adding a Clear Chart Title

The chart title is the first thing people see. It needs to tell them exactly what the chart is about in a brief, descriptive way.

1. In the Customize tab, click on the Chart & axis titles section to expand it.
2. Under Title text, delete the default text and type in your new title. For our example, something like "Monthly Website Sessions (2024)" is perfect.
3. You can further customize the title's font, size, color, and alignment using the options provided. A bold, centered title usually works best.

Pro Tip: Be specific. Instead of "Traffic," use "Organic Traffic vs. Paid Traffic." Instead of "Sales," use "Q1 Sales Revenue by Product." This small change adds a ton of clarity.

2. Formatting Axis Titles (Horizontal & Vertical)

Axis titles explain the units and categories being measured. Without them, the numbers on your chart are meaningless. Does "1,200" mean dollars, website sessions, or units sold?

1. Stay in the Chart & axis titles section of the Customize tab.
2. From the dropdown menu (which probably defaults to "Chart title"), select Horizontal axis title.
3. Type your label into the Title text box. For our example, a good label is "Month."
4. Now, select Vertical axis title from the same dropdown menu.
5. Type the label for your vertical axis. In our case, "Number of Sessions" is clear and concise. It’s also good practice to include the unit, like "(USD)" or "(in thousands)," if it’s not obvious.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Adding Data Labels

Data labels are the specific values attached to each data point on your chart (e.g., each bar, line point, or pie slice). They are incredibly useful for B2B dashboards when your audience needs to see exact figures at a glance without hovering over the chart elements.

1. In the Customize tab, click on the Series section. This lets you format the actual data representation on your chart (the bars, lines, etc.).
2. Check the box next to Data labels. The values from your spreadsheet will immediately appear on the chart.
3. After checking the box, you’ll see several formatting options:

Be careful with clutter! If you have a ton of data points, adding labels to all of them can make your chart unreadable. In that case, consider only highlighting a few key points or forgoing data labels entirely in favor of a clean trendline.

4. Customizing the Legend

The legend is the key that explains what each color or symbol on your chart represents. It's essential when you're comparing multiple data series, such as tracking both "Facebook Ads Spend" and "Google Ads Spend" on the same graph.

Google Sheets will add a legend automatically when you have more than one data series. You can customize its appearance:

1. In the Customize tab, expand the Legend section.
2. Position: You have several options here - Top, Bottom, Left, Right, or even inside the chart area. "Top" or "Bottom" positioning is often the cleanest choice as it doesn't shrink the horizontal space for your chart.
3. Customize the font, size, and color as you see fit to match the rest of your chart's styling.

Advanced Labeling Techniques & Tips

Once you've mastered the basics, here are a few extra tips to take your chart labeling to the next level.

Labeling Pie Charts Effectively

Pie charts have some unique labeling needs. Because they represent parts of a whole, it's often more useful to show percentages than absolute numbers.

1. Create your pie chart and open the Customize tab.
2. Click on the Pie chart section.
3. Under Slice label, you can choose what information you'd like to show. Common options are:

You can even select both Label and Percentage to have both appear on the slice.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Workaround for Adding Annotations

Sometimes you want to call out a specific event on your chart - like a marketing campaign launch or a product update - that influenced the data. While Google Sheets doesn't have a built-in "annotation" feature, you can create one with a clever workaround by adding a new data series.

Imagine your website traffic spiked in April because you launched a new ad campaign. Here is what you'd do to label this on your graph:

1. In your sheet, add a new column called "Annotation."
2. Leave all cells in this column blank except for the one corresponding to the event you want to highlight. In that cell, enter the same value as your primary data point. For April, you'd put "1800" in this new column.
3. Double-click your chart to open the editor. Under the Setup tab, click on your data range. Add your new annotation column to the range.
4. Go to the Customize > Series tab. You now have two series. Change your new "Annotation" series to use a different symbol or color.
5. Finally, apply a single Data label only to this annotation series. You’ve now created a clear visual callout right on your graph.

Final Thoughts

You now have a complete toolkit for labeling charts in Google Sheets, from the essential titles and axis labels to more advanced formatting tricks. Clear labels transform a simple graph into a powerful communication tool, enabling anyone to grasp the story behind your data quickly and providing a level of polish that helps build trust with stakeholders.

Mastering these settings is a great skill, but setting up every chart manually can feel like a chore, especially when you need answers quickly or want to analyze data across multiple platforms. At Graphed, we built our platform to automate this busywork. Instead of clicking through menus, you can just ask in plain language, "Show me a dashboard of monthly website sessions from Google Analytics compared to ad spend from Facebook Ads," and get a fully labeled, real-time visualization in seconds - no setup required.