How to Make a Pie Chart on Google Spreadsheet

Showing your data as parts of a whole is a powerful way to tell a story, and the pie chart is a classic tool for the job. Whether you're breaking down website traffic by source or showing sales by product category, Google Sheets can help you build a clean, effective pie chart in minutes. This tutorial guides you through creating, customizing, and mastering pie charts directly within your Google Spreadsheet.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Pie Chart and When Should You Use One?

A pie chart is a circular statistical graph that is divided into slices to illustrate numerical proportion. Each slice's size is proportional to the quantity it represents, making it an excellent way to show a "part-to-whole" relationship. The entire pie represents 100%, and each slice represents a percentage of that total.

So, when is it the right choice? Pie charts are most effective when you are comparing a few distinct categories that combine to make up a single total.

Ideal scenarios for a pie chart include:

• Budget Allocation: Showing how a department's budget is divided among different expenses (e.g., software, salaries, advertising).
• Website Traffic Sources: Visualizing the percentage of visitors who arrive from Organic Search, Social Media, Direct Traffic, and Referrals.
• Survey Results: Displaying the distribution of answers to a multiple-choice question (e.g., what percentage of users prefer Feature A vs. Feature B).
• Market Share: Illustrating the market percentage held by your company and your top competitors.

When to Avoid a Pie Chart

Despite their popularity, pie charts are often misused. Avoid them in these situations:

• Comparing Data Over Time: If you want to show how traffic sources have changed month-over-month, a line chart or a stacked bar chart is a much better choice. Human eyes are not good at comparing the angles of different pie charts side-by-side.
• When You Have Too Many Categories: A pie chart with more than five or six slices becomes cluttered and difficult to read. The slices get too thin, and the legend becomes a wall of text.
• Multiple "Parts" Don't Equal a "Whole": If the numbers you're charting don't add up to a meaningful total (e.g., they aren't mutually exclusive), a pie chart is the wrong visual and will be misleading.

Step 1: Get Your Data Ready

Before you create any chart, your data needs to be structured properly. For a pie chart in Google Sheets, you need two columns:

• Column 1 (Labels): This column contains the names of your categories (e.g., "Organic Search," "Paid Social," "Direct").
• Column 2 (Values): This column contains the numerical data corresponding to each category (e.g., the number of sessions, sales figures, or survey respondents).

It's best practice to include headers at the top of your columns, like "Traffic Source" and "Sessions." Google Sheets will automatically use these headers as titles for your legend and chart.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: How to Make a Pie Chart in Google Sheets

With your data neatly organized, creating the actual chart takes just a few clicks. It's surprisingly simple.

Step-by-Step Instructions

1. Select your data: Click and drag your cursor to highlight the cells containing your data, including the headers. In our example, you would select cells A1 through B6.
2. Insert the chart: Navigate to the top menu and click on Insert → Chart.
3. Choose your chart type: Google Sheets is smart. Based on your two-column selection, it will often default to a pie chart. If it doesn’t, a Chart editor pane will appear on the right side of your screen. Under the "Setup" tab, find the "Chart type" dropdown and scroll down to the "Pie" section. Select the standard Pie chart.

Just like that, you have a pie chart! It will appear directly on your spreadsheet, ready to be moved, resized, or customized.

Step 3: Customize Your Pie Chart for Clarity

The default chart is functional, but a little customization can transform it from a basic visual into a clear, professional-looking element for your report or dashboard.

If the Chart editor isn’t already open, double-click on your chart. In the editor pane, switch from the "Setup" tab to the "Customize" tab. Here are the most useful options to tweak.

Chart Style

This is where you can change the broad aesthetics. You can set a Background color for the entire chart area and change the default Font. You can also make the borders of the chart area rounded or "maximized" to fill its container, though the default setting usually works best.

Pie Chart Settings

This is the most important section for fine-tuning your chart.

• Doughnut hole: Adding a percentage here turns your pie chart into a doughnut chart. A hole of 25% or 50% can make the chart feel more modern and less cluttered. It also shifts the focus from comparing angles to comparing arc lengths, which can be slightly easier for readers to interpret.
• Border color: Adding a simple white or light gray border between slices can improve readability, especially when colors are similar.
• Slice label: This is a powerful feature. Instead of forcing viewers to look back and forth between the pie and the legend, you can put the labels directly on the chart. You can choose to display the Label (the category name), the Value, the Percentage, or a combination. Displaying the percentage is often the clearest option.
• Label font size & color: Once you add slice labels, you can adjust their look to ensure they are easily readable against the slice backgrounds.

Pie Slice

Here you can override the default colors. Select a category from the dropdown (e.g., "Organic Search") and pick a new color for its slice. You can also add a Distance from center percentage, which makes that slice "explode" out from the pie. This is a great way to highlight your most important category.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Chart & Axis Titles

Google Sheets usually pulls a title from your headers, but it’s a good idea to write a more descriptive one. Click on the Title text field and write something clear, like "Website Traffic by Source - Q3." You can then change its font, size, color, and alignment (centered is typically best).

Legend

Customizing the legend helps manage screen real estate. Under Position, you can move it to the top, bottom, left, right, or remove it entirely if you've used slice labels. Adjusting the legend's text font and color can also improve consistency with your report's styling.

Pro-Tips for Better Pie Charts

Creating the chart is easy. Creating an effective chart requires a little more thought.

1. Order Your Slices Logically

By default, Google Sheets orders slices based on their order in your data table. It’s better to have them sorted from largest to smallest value. Before creating the chart, simply select your data table, go to Data → Sort range → Advanced range sorting options. Tick "Data has header row," and then sort by your value column (e.g., "Sessions") in Z → A (descending) order. This makes the chart much easier to read at a glance.

2. Group Small Slices into an "Other" Category

If your pie chart has a handful of tiny, sliver-like slices, it looks messy and doesn’t add much value. A common best practice is to group all slices below a certain threshold (say, 5%) into a single category called "Other." You can do this with a helper table using a SUMIF formula. For example, you can calculate the "Other" total like this:

=SUMIF(B2:B,"<25000")

This formula would sum up any session counts under 25,000, which you could then plot as one slice, making your overall chart much cleaner.

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Use Color with Purpose

Avoid the default rainbow color scheme if you can. It can be visually distracting. Instead, use shades of a single color (a monochromatic palette) or a palette of 3-4 complementary brand colors. To emphasize one slice, make all other slices shades of gray and use a bold color for the one you want to highlight.

Common Mistakes to Avoid

Here are a few quick reminders of what not to do when building pie charts in your marketing or sales reports.

• Using 3D Pie Charts: It's an option in the "Chart Style" customize tab, but you should almost never use it. The 3D effect skews perspective, making slices closer to the front appear larger than they actually are. It adds clutter without adding clarity.
• Representing Non-Exclusive Data: For example, visualizing survey responses where users could "select all that apply." In this case, the percentages will add up to more than 100%, breaking the part-to-whole concept. A bar chart is the appropriate choice here.
• Making Multiple Pie Charts to Compare Groups: If you want to compare traffic sources for Q3 vs. Q4, resist the urge to place two pie charts side-by-side. Our brains aren't equipped to accurately compare the angles between two separate circles. A stacked bar chart would communicate this comparison much more effectively.

Final Thoughts

Creating a pie chart in Google Sheets is a simple process, from arranging your data in two columns to inserting the chart and fine-tuning its appearance in the editor. By following these steps and keeping best practices in mind, you can turn a basic spreadsheet into a clear and compelling visual breakdown for any report or dashboard.

While mastering charts in spreadsheets is a fantastic skill, we know it's often just one small piece of the data puzzle. When you're tired of manually exporting CSVs and wrestling to connect data from platforms like Google Analytics, Shopify, and Facebook Ads, you might be ready for a faster way. We built Graphed to be your AI data analyst - it connects to all your sources, lets you build dashboards in seconds using plain English, and keeps all your data updated in real-time. No more spreadsheet wrangling, just instant answers when you need them.