How to Add Labels to Pie Chart in Google Sheets

Adding clear labels to a pie chart transforms it from a set of colorful slices into a powerful and easy-to-read data story. Without them, your audience is left guessing what each section represents. This tutorial will walk you through exactly how to add and customize labels in your Google Sheets pie charts, step-by-step.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Labels Are Essential for Pie Charts

A pie chart’s main job is to show parts of a whole, like how different marketing channels contribute to a total number of website visitors. Labels are the key that unlocks this information instantly. They provide context and precision, directly answering the viewer's questions.

• Context: Labels tell the viewer what each slice of the pie represents (e.g., "Organic Search," "Paid Social," "Direct Traffic").
• Value: They can show the exact number associated with each slice (e.g., 10,521 visitors).
• Proportion: They can display the percentage of the whole, which is often the most important insight (e.g., 45.2%).

By putting this information directly on the chart, you eliminate the need for viewers to constantly glance back and forth between the chart and its legend, creating a smoother and more effective communication experience.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Prepare Your Data for a Perfect Pie Chart

Before you can create a clear pie chart, your data needs to be organized properly. Google Sheets works best with a simple, two-column format for pie charts. Anything more complex can lead to confusion or errors when the chart is generated.

Your data should be set up as follows:

• Column A: Categories. This column lists the names of your pie slices. These are your qualitative data points. For example, if you're analyzing web traffic sources, your categories might be "Organic Search," "Email," "Social Media," and "Referral."
• Column B: Values. This column contains the numerical data that determines the size of each slice. These must be numbers, like session counts, revenue figures, or survey responses.

Here is a relatable example worksheet showing Q3 website traffic by source. We'll use this data throughout the tutorial.

Example Data:

Tips for Setting Up Your Data:

• Keep it Simple: Don’t include "Total" rows in your data selection. A pie chart automatically calculates the total to determine the proportion of each slice. Including a total will create a slice that takes up 50% of the pie, skewing your visualization.
• Be Clear with Categories: Use descriptive but concise names for your categories. Long, wordy labels can clutter your chart later on.

Step 2: Create a Basic Pie Chart in Google Sheets

Once your data is neatly arranged in two columns, creating the initial pie chart takes just a few clicks.

1. Select Your Data: Click and drag your cursor to highlight all the cells containing your data, including the headers (e.g., A1:B6 in our example).
2. Insert the Chart: Navigate to the menu at the top of the screen and click Insert > Chart.

Google Sheets is pretty smart and will usually default to a pie chart for this type of data layout. However, if it creates a different type of chart (like a bar graph), you can easily change it.

In the Chart editor pane that appears on the right, find the Setup tab. Click the dropdown menu under Chart type and select Pie chart from the options.

At this stage, you'll have a basic pie chart. The legend on the side tells you which color corresponds to which channel, but the slices themselves are blank. Now, let's add the labels that make it truly useful.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Add and Customize Your Pie Chart Labels

This is where you bring your data to life. All of the customization options for labels are located in the Chart editor. If you closed it, simply double-click anywhere on your chart to re-open it.

1. Navigate to Customization Options: In the Chart editor, click on the Customize tab.
2. Open the "Pie chart" Section: Click on the Pie chart section to expand its menu. This is where you’ll find all the labeling controls.

Inside this section, the most important setting is the Slice label dropdown menu. This lets you choose what information you want to display on each piece of the pie.

Choosing Your Label Type:

• None: This shows no labels on the slices, relying entirely on the legend. This is the default setting.
• Label: This displays category names from your first column ("Organic Search," "Direct," etc.) directly on each corresponding slice.
• Value: This displays a number associated with the piece: the numerical data from your second column (12,450, 7,800, etc.).
• Percentage: This is often the most effective option for pie charts. It calculates and shows the percentage that each slice contributes to the whole (e.g., 40.3%, 25.3%). Viewers can instantly grasp the proportions without doing any mental math.
• Value and percentage: This shows both numerical and proportional data. It can make the display too crowded. It might work on a chart with very large pies, but generally, percentage labeling is a preferred choice.

For our example, let's select Percentage. Your chart will instantly update, showing the proportion of sessions each channel drove.

Formatting Your Labels for Readability

Once you've added your labels, you can adjust their appearance to make them easier to see. Still in the Customize > Pie chart section, you'll find options for styling.

• Label font lets you change the typeface.
• Label font size is useful for making labels larger or making crowded charts more readable by decreasing the size.
• Label format lets you apply bold or* italics*.
• Text color allows you to change the color of the label text. A white font often works well on darker-colored slices for better contrast.

Advanced Tips for Perfecting Your Pie Chart Labels

Sometimes the default settings don't quite cut it, especially when dealing with complex data. Here are a few extra tips to handle common labeling challenges.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Dealing with Crowded or Overlapping Labels

If you have many small slices, the labels can quickly become a jumbled, unreadable mess. Here's how to fix it:

1. Group Small Slices: The best practice for a readable pie chart is to limit it to 5-7 categories. If you have ten sources, with several of them contributing less than 2%, they will create tiny, hard-to-label slices. The solution is to group these smaller categories into a single "Other" category. Do this directly in your source data, summing their values, before you create the chart.
2. Use a Donut Chart: A donut chart (a pie chart with a hole in the middle) can sometimes provide a little more breathing room for labels. You can enable this by going to Customize > Pie chart and setting the Donut hole to a value like 25% or 50%.
3. Consider Another Chart Type: If you must show more than 7-8 categories, a pie chart is probably not the best tool for the job. A Bar chart or Column chart will display the same data in a way that’s much cleaner and easier to label and compare.

Using Titles and Legend Effectively

Your slice labels don't exist in a vacuum. Coordinate them with your chart's title and legend for maximum clarity.

• Descriptive Title: Give your chart a clear, descriptive title like "Website Traffic Sessions by Channel - Q3 2023." You can edit this under Customize > Chart & G-axis titles.
• Legend Positioning: The legend can be moved to different positions (Top, Bottom, Left, Right) or removed entirely (None). If your slice labels already include the category names, you might choose to remove the legend to give your chart more space. You can access these options at Customize > Legend.

Final Thoughts

Mastering pie chart labels in Google Sheets is a simple but powerful skill that elevates your data reporting. By moving beyond the default settings and thoughtfully choosing your label type, formatting, and colors, you can create visuals that are not just informative but also instantly understood by your audience.

Of course, building the right reports and keeping them updated is often about more than just formatting. Manually pulling data from different platforms and wrestling with spreadsheet charts every week can be a huge time sink. We created Graphed to automate that entire process. Just connect your marketing and sales sources, and then describe the charts and dashboards you need in plain English. Graphed builds real-time, interactive visualizations for you, so you can spend less time copy-pasting and more time acting on your insights.