How to Insert Pie Chart in Google Sheets

Pie charts are an excellent way to show how individual parts make up a whole. Whether you're breaking down a marketing budget, analyzing website traffic sources, or showing survey results, a pie chart brings your data to life. This guide will walk you through exactly how to create, customize, and perfect pie charts in Google Sheets.

First Things First: How to Structure Your Data

Before you can create a pie chart, your data needs to be organized properly. Google Sheets is smart, but it needs a clear structure to understand what you want to visualize. For a pie chart, you only need two columns:

• Column 1: Categories. These are the labels for each slice of your pie (e.g., Traffic Source, Product Category, Campaign Name).
• Column 2: Values. These are the numbers corresponding to each category (e.g., Number of Sessions, Revenue, Budget Amount).

Your data is the foundation of your chart. Make sure it's clean, simple, and ready to go. Headers for each column are also a good idea, as Google Sheets will often use them as titles automatically.

Here’s a simple example of data formatted perfectly for a pie chart, showing a breakdown of a quarterly marketing budget:

Example Data:

Creating a Pie Chart in Google Sheets: The Step-by-Step Guide

Once your data is set up, creating the actual chart takes just a few clicks. It's a straightforward process, but knowing the small details will help you get it right every time.

1. Select Your Data

Click and drag your mouse to highlight the cells containing your data, including the headers. In our budget example, you would select cells A1 through B6.

2. Insert the Chart

With your data highlighted, navigate to the menu at the top of the screen and click Insert > Chart.

Google Sheets will automatically analyze your data and create what it thinks is the best chart. If your data is structured as shown above, it will likely default to a pie chart. If it doesn't, don't worry - the next step is to change it.

3. Choose "Pie chart" as Your Chart Type

When you insert a chart, the Chart editor pane will appear on the right side of your screen. This is where you control every aspect of your chart's appearance and data.

• The editor has two main tabs: Setup and Customize.
• Under the Setup tab, the first option is "Chart type." If Google Sheets didn't already select a pie chart, click the dropdown menu and choose "Pie chart" from the list of options. You'll see several variations, including the standard pie chart, a donut chart, and a 3D version.

That's it! You now have a basic pie chart embedded in your spreadsheet. Now, let’s make it look great and communicate your message clearly.

How to Customize Your Google Sheets Pie Chart

A default chart gets the job done, but customization is what makes your data shine. The Customize tab in the Chart editor is your control center for making your pie chart look professional and easy to read.

Chart Style

This section controls the overall look and feel of your chart.

• Background color: Change the background of the chart's container. You can set it to "None" for a transparent background.
• Font: Choose a font that matches your report or presentation style.
• Border color: Add a border around the chart area.
• Maximize: This toggle removes some of the white space around the pie itself, making it larger and more prominent within the chart's frame. It's great for making your visualization the star of the show.
• 3D: Toggling this on will give your pie chart a three-dimensional effect. While it can be visually interesting, use it with caution, as 3D charts can sometimes make it difficult to accurately compare slice sizes.

Pie Chart

This is where you make adjustments to the pie itself.

• Donut hole: The secret to making a donut chart! By setting a percentage here (e.g., 25% or 50%), you'll create a hole in the center of your pie chart. This can make the chart feel less visually dense and allows space for adding a key metric or icon in the center manually later.
• Border color: Changes the color of the thin lines separating each slice of the pie. Setting this to white can create a clean, modern look.
• Slice label: This is one of the most important customization options. Instead of just relying on a legend, you can add labels directly to the slices. You can choose to display:
• Label font, size, and format: After choosing a slice label, you can control its font, make it bold or italic, and change its color to improve readability.

Pie Slice

Need to highlight a specific piece of the pie? This section allows you to customize individual slices.

• Use the dropdown menu to select the slice you want to edit (e.g., "Facebook Ads").
• Color: Change the color of that specific slice to match your brand's palette or to draw attention to it.
• Distance from center: This "explodes" a slice out from the rest of the pie. Setting a distance (e.g., 25%) is a powerful way to highlight a key data point, like your most significant revenue source or your top-performing campaign.

Chart & Axis Titles

Every chart needs a title to give it context. This section lets you add and style them.

• Title text: Write a clear, descriptive title for your chart (e.g., "Q3 Marketing Budget Allocation").
• Title font, size, and format: Adjust the appearance of your title to make it stand out. You can also center it or change its color.
• Chart subtitle: Add a smaller subtitle for extra context, like the date range or the total value represented.

Legend

The legend explains which color corresponds to which category. You have full control over its placement and style.

• Position: Change where the legend appears. Common options are "Top," "Bottom," "Left," "Right," or "Labeled," which removes the legend and relies on your slice labels. Placing it to the right or bottom is often best for readability.
• Legend font, size, and format: Just like with titles, you can customize the text in your legend.

Best Practices for Making Effective Pie Charts

Creating a chart is easy, creating a good chart takes a bit more thought. A good visualization communicates a message quickly and accurately, while a bad one just creates confusion. Here are a few tips to keep in mind:

1. Use Them Only for Part-to-Whole Relationships

Pie charts have one job: to show how parts relate to a whole. The total of all slices must equal 100%. If you're comparing data that isn't part of a whole (like website traffic over time), a line chart or bar chart is a much better choice.

2. Keep Your Categories Under Seven

When you have too many slices, a pie chart becomes a cluttered, unreadable mess of slivers. If you have more than 5-7 categories, consider grouping smaller categories into an "Other" slice or using a bar chart instead, which handles more categories much more effectively.

3. Order Your Data Logically

Before you create the chart, sort your data. The most common way is to arrange it from the largest value to the smallest. When Google Sheets creates the chart, the slices will be ordered logically, making it much easier for people to compare them.

4. Choose Clear Labels and Great Colors

Don't make your audience work to understand your chart. Use slice labels with percentages or values directly on the chart so they don’t have to keep looking back and forth between the pie and the legend. Use colors with enough contrast to be easily distinguished.

Final Thoughts

You now have everything a guide should cover when you need to insert a pie chart in Google Sheets, from structuring your data to applying the final customizations. They are a powerful visual tool for displaying proportions, and by following these steps and best practices, you can create charts that are not only accurate but also clear and compelling.

While mastering tools like Google Sheets is incredibly useful, the process of preparing data and building reports can often become repetitive and time-consuming. We built Graphed to automate that entire manual workflow. You can connect your marketing and sales data sources like Google Analytics, Shopify, and Facebook Ads, and then simply describe the dashboard you want in plain English. Graphed instantly builds you a real-time, professional dashboard, saving you the hours you’d normally spend wrangling spreadsheets.