How to Add Value to a Pie Chart in Google Sheets

Adding values directly onto a pie chart in Google Sheets turns a vague visual into a precise, easy-to-read report. Instead of forcing your audience to guess proportions or consult a legend, you can put the most important numbers front and center. This article will guide you through the exact steps to add values to your pie chart and share a few extra customization tips to make your data truly stand out.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Let's Create a Basic Pie Chart

Before you can add values, you need a pie chart. If you already have one, feel free to skip to the next section. If not, here’s a quick walkthrough to get a chart up and running in under a minute.

Pie charts are designed to show parts of a whole, so make sure your data is structured that way. For our example, we'll use a simple breakdown of marketing channel traffic.

Step 1: Organize Your Data

In a blank Google Sheet, create two columns. The first column should contain your categories (the labels for your slices), and the second should contain the corresponding numerical values. It should look something like this:

Column A: Channel

• Organic Search
• Direct
• Social Media
• Referral
• Paid Search

Column B: Sessions

• 8,210
• 4,550
• 2,130
• 1,880
• 1,550

Step 2: Highlight and Insert the Chart

Click and drag your mouse to select all the cells containing your data, including the headers (e.g., A1 through B6).

With the data highlighted, navigate to the main menu and click Insert > Chart.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Select the Pie Chart Type

Google Sheets will automatically suggest a chart type, which is often a pie chart for this kind of data. If it suggests something else, it's an easy fix. In the Chart editor sidebar that appears on the right, go to the Setup tab and find the Chart type dropdown. Scroll down and select Pie chart.

You'll now have a basic, colorful pie chart representing your data, but without any numbers on it. Now for the important part.

How to Add Values to a Pie Chart in Google Sheets

This is where you bring your chart to life with data labels. Follow these steps to display the exact values or percentages on each slice of your pie.

Step 1: Open the Chart Customization Menu

Double-click anywhere on your pie chart. This will re-open the Chart editor sidebar if it was closed. This time, click on the Customize tab at the top of the sidebar.

Step 2: Navigate to Pie Chart Settings

In the list of customization options, you’ll see several accordions (like Chart style, Chart & axis titles, etc.). Click on the one labeled Pie chart to expand its settings.

Step 3: Choose What to Display with 'Slice Label'

The key setting you're looking for is Slice label. Click on the dropdown menu here to see your options for what information to display directly on the chart.

Here’s what each option does:

• None: This is the default. No labels will appear on the chart itself.
• Label: This displays the text from your category column (e.g., 'Organic Search', 'Direct').
• Value: This is the one you want! It shows the actual numbers from your value column (e.g., 8,210, 4,550).
• Percentage: This automatically calculates the percentage that each slice represents of the total and displays it (e.g., 45%, 25%). This is incredibly useful for showing proportional contributions.
• Label and Value: Displays both the category name and its numerical value. This can get crowded on smaller charts.
• Label and Percentage: Displays both the category and its percentage. Great for presentation slides where clarity is key.

Select Value or Percentage from the dropdown menu. Instantly, you'll see the numbers appear on their corresponding slices of the pie chart. It's that simple!

Graphed

Still Building Reports Manually?

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

Watch the Demo

Customizing Labels for Better Readability

You've added the values, but they might be too small, the wrong color, or hard to read against a particular slice. A few minor adjustments can make a huge difference in visual appeal and readability.

All these settings are found in the same Customize > Pie chart section of the Chart editor. Below the 'Slice label' dropdown, you’ll find several formatting options:

Label Font Type and Size

You can change the font to match your branding or just improve readability. But the more practical option is Label font size. The 'Auto' setting usually does a good job, but you can manually select a font size to make the text larger or smaller. If your chart feels crowded, reducing the font size slightly can help.

Label Font Style and Color

Use the B button to make your labels bold. This works particularly well for values or percentages, making them pop. You can also change the Text color. A best practice is to ensure high contrast. For example, if you have a dark blue pie slice, change the label for that slice to white text for easy reading. Google Sheets often does this automatically, but you can override it for a custom look.

Advanced Customization Tips for Professional-Looking Charts

Want to go beyond the basics? Google Sheets has a few more powerful features tucked away in its chart editor that can help you emphasize data and match your organization's style guide.

Create a Donut Chart

Many data visualization experts prefer donut charts over traditional pie charts because they encourage the viewer to compare the arc lengths of the slices rather than their areas, which can sometimes be misleading. Turning your pie chart into a donut chart is easy.

1. In the Customize > Pie chart menu, look for the Donut hole slider.
2. Set it to a value between 25% and 50%. A larger percentage creates a thinner donut ring.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Emphasize a Slice by Pulling it Out

If you want to draw special attention to a particular category - like your most profitable product or your biggest traffic source - you can "explode" that slice by moving it away from the center.

1. In the Customize tab, go to the Pie slice section.
2. Use the dropdown menu to select the specific slice you want to highlight (e.g., 'Organic Search').
3. Adjust the Distance from center slider. A value of 10% or 25% is usually sufficient to make the slice stand out without detaching it completely.

Customize Slice Colors

Don't like the default colors? You can change them to match your brand style guide or use color to tell a story (e.g., making all main channels blue and experimental channels gray).

1. Just like with exploding a slice, go to Customize > Pie slice.
2. Select the slice you want to change from the dropdown menu.
3. Use the Color swatch to pick a new color for that specific slice. Repeat this for any others you want to change.

Common Pie Chart Mistakes to Avoid

Pie charts are useful, but they're also one of the most misused charts in data reporting. Keep these quick tips in mind to use them effectively.

• Slicing the Pie Too Thin: A pie chart with more than 5-7 slices becomes a cluttered mess. If you have many small categories, group the smallest ones together into a single "Other" slice in your source data. For comparing many categories, a bar chart is a much better choice.
• Using a Pie for Data That Isn't a Whole: Pie charts only work when their slices add up to a meaningful 100%. Don't use a pie chart to compare monthly website visitors or sales from different regions unless you're trying to show their contribution to an annual total. Use bar or line charts for comparisons on an open scale.
• Avoid 3D Effects: Google Sheets offers an option to create a 3D pie chart. Don't use it. The perspective skew of a 3D chart distorts the data, making slices at the front appear larger than equally sized slices at the back, which misleads the viewer.

Final Thoughts

Adding values to your pie charts in Google Sheets is a quick customization that dramatically improves clarity. By following just a few steps in the Chart editor, you can display exact numbers or percentages directly on your chart, making your data story easier to understand at a glance.

While mastering Google Sheets is a great skill, the process of manually pulling data, cleaning it, and building reports steals valuable time you could be using for strategy. At Graphed, we automate that entire workflow. Just connect your data sources, like Google Analytics, Shopify, and your ad platforms, and then use natural language to ask for what you need - for example, "create a dashboard showing my marketing funnel performance by channel this quarter." We build the visualizations for you in seconds, so you get live, real-time insights without any of the manual busywork.