How to Edit Pie Chart in Google Sheets

Creating a pie chart in Google Sheets is the easy part, making it tell a clear, compelling story with your data is where the real work begins. If you’re staring at a default chart wondering how to change colors, add labels, or highlight a key piece of information, you’ve come to the right place. This guide will walk you through exactly how to edit and customize your pie charts in Google Sheets to make your data stand out.

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

First, A Quick Refresher: Creating Your Pie Chart

Before we dive into editing, let's start with a basic pie chart. All you need is data in two columns: one for your categories (Labels) and one for their corresponding numeric values (Values).

For example, let's say you're tracking website traffic sources for the month:

Source          | Sessions
----------------|----------
Organic Search  | 1,200
Direct          | 850
Social Media    | 650
Referral        | 400
Paid Search     | 300
Email           | 150

To create the chart:

1. Select your data range (in this case, A1:B7).
2. Go to the top menu and click Insert > Chart.

Google Sheets is usually smart enough to recognize this data structure and will often default to a pie chart. If it doesn’t, don't worry. The first thing we’ll do in the editor is fix that.

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

Meet Your Command Center: The Chart Editor

Once you create a chart, the Chart editor sidebar will automatically appear on the right side of your screen. This sidebar is your command center for every possible customization. If you’ve closed it, you can reopen it anytime by simply double-clicking on your chart.

The editor is divided into two primary tabs:

• Setup: This is where you control the foundational elements, like the chart type and the data range it pulls from.
• Customize: This is where the magic happens. You’ll find options here for colors, titles, labels, fonts, and nearly every visual aspect of your chart.

Controlling Your Data with the 'Setup' Tab

Think of the 'Setup' tab as the blueprint for your chart. It determines what data is shown and how it's structured.

Changing Your Chart Type

If Google Sheets gave you a bar graph instead of a pie chart, this is the first place you'll stop. Click the dropdown under Chart type and find the Pie section. Here, you can select a standard Pie chart, a Doughnut chart, or a 3D pie chart.

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

Defining Your Data Range and Labels

Further down the Setup tab, you’ll find a few important fields:

• Data range: This confirms the cells your chart is based on. If you add a new traffic source to your sheet, you’ll need to adjust this range (e.g., from A1:B7 to A1:B8) to include the new data.
• Label: This should be your column of categories (A1:A7 in our example).
• Value: This should be your column of numbers (B1:B7).
• Aggregate: Check this box if you have duplicate labels in your data and want Google Sheets to automatically sum their values. For example, if you had two separate rows for "Social Media," this would combine them into a single, larger slice.

Bringing Your Chart to Life with the 'Customize' Tab

This is where you'll spend most of your time. The 'Customize' tab lets you control everything from the chart's background color to exploding a single slice out from the center. Let's go through each section.

Chart style

This is for global adjustments that affect the whole chart.

• Background color: Change the color of the area behind your pie chart. You can set it to "None" for a transparent background.
• Font: Set a universal font for all text on your chart (titles, labels, legend).
• Chart border color: Add a border around the entire chart object.
• Maximize: This option expands the pie to fill as much of the chart area as possible, which is great if your chart title isn't very long.
• 3D: If you chose a standard pie chart, you can check this box to give it a 3D effect.

Pie chart

This section is full of powerful pie-specific customizations.

• Doughnut hole: If you're using a standard pie chart, you can give it a percentage value here (like 25% or 50%) to instantly turn it into a doughnut chart.
• Border color: This adds a border around each slice, which can help differentiate them visually.
• Slice label: This is one of the most useful features. Instead of relying on a separate legend, you can add labels directly to the slices. Your options include:
• Slice label font, size, &amp, color: After selecting a slice label type, you can customize its appearance here.

Pie slice

Want to draw attention to your most important traffic source? This section lets you format individual slices.

• First, use the dropdown menu to select the slice you want to edit (e.g., "Organic Search").
• Color: Change the color of just that slice. You could, for instance, make your most important slice a bold, bright color and all other slices varying shades of gray.
• Distance from center: This is how you "explode" a slice. Setting this to a percentage (like 25%) will pull that slice away from the center of the pie, making it stand out immediately. This is an excellent technique for presentations.

Chart &amp, axis titles

A chart without a title is just a picture. Make sure yours is clear and descriptive.

• Title text: Under the Type dropdown, select Chart title and write in your title (e.g., "Website Traffic by Source - May").
• Title font, size, and color: Use the options to format your title. Making it bold is typically a good idea to help it stand out. You can also add a Chart subtitle here for extra context.

Legend

The legend connects the colors on your chart to their corresponding labels. The default position works, but you have several options.

• Position: You can place the legend on the top, bottom, left, or right of the chart. The labeled option removes the legend entirely and instead places the category labels next to each slice, connected by a line. This can be very effective for decluttering your chart.
• After choosing a position, you can format the legend’s font, size, and color just like any other text element.

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

Practical Tips for Effective Pie Charts

Editing your chart is more than just making it look pretty. It's about making it communicate information effectively.

• Rule of 5-7 Slices: Pie charts become cluttered and hard to read when they have too many slices. If you have more than seven categories, consider grouping the smallest ones into a single slice labeled "Other."
• Order Your Data: Before making your chart, sort your data table from largest to smallest. This will translate to a pie chart where slices are arranged in a logical order, making it much easier to compare them.
• Don't Rely Solely on Color: Use slice labels with percentages or values. This helps viewers understand the proportions instantly, without having to consult the legend. It also makes your chart more accessible to people with color vision deficiencies.
• Use Highlighting with Purpose: Don't just make every slice a different bright color. Use a muted palette (like shades of gray or blue) for most slices, and reserve one distinct, bright color for the slice you want your audience to focus on. Combine this with the "Distance from center" feature to really make your key insight pop.

Final Thoughts

Editing a pie chart in Google Sheets is as simple as navigating the 'Setup' and 'Customize' tabs in the Chart editor. By moving beyond the defaults, you can transform a basic chart into a clear, insightful, and professional visual that effectively communicates your data's story.

Of course, building reports in a spreadsheet is often just one piece of the puzzle. When you need to connect your Google Sheets data with live information from other platforms like Google Analytics, Shopify, or your CRM to get a complete picture, a spreadsheet alone can become incredibly time-consuming. We built Graphed to solve exactly this problem. You can connect all your data sources in seconds and then simply ask in plain English to create real-time dashboards and reports, letting you skip the manual data wrangling and get straight to the insights that matter.