How to Create a Pie Chart in Google Sheets

Mehjabi Khan

Published By

Mehjabi Khan

Published On

Reading Time

7 min read

Learn how to create and customize a pie chart in Google Sheets with our step-by-step guide. Perfect for visualizing data effectively!

Pie charts are a fantastic way to visualize data and present it in a clear, easy-to-understand format. Google Sheets makes it simple to create pie charts, whether you’re tracking expenses, survey results, or any other data set. In this blog post, we’ll walk you through the process of creating a pie chart in Google Sheets step-by-step. We'll cover everything from setting up your data to customizing your chart to make it look professional.

Setting Up Your Data

Before you can create a pie chart, you need to have your data organized properly in Google Sheets. Here are the steps to set up your data:
  1. Open Google Sheets: Start by opening Google Sheets and either create a new spreadsheet or open an existing one where your data is stored.
  1. Enter Your Data: Your data should be organized in a table with labels and corresponding values. For example:
notion image
  1. Highlight Your Data: Click and drag to highlight the cells that contain your data, including both the labels and the values.
notion image

Creating the Pie Chart

Once your data is set up, you can create the pie chart. Here’s how:
  1. Insert the Chart: With your data highlighted, go to the menu bar and click on Insert -> Chart. This action will open the Chart Editor on the right side of your screen.
notion image
  1. Choose Chart Type: In the Chart Editor, Google Sheets will automatically select a chart type for you. To change it to a pie chart, click on the dropdown menu under Chart type and select Pie chart.
notion image
notion image
  1. Customize the Chart: Google Sheets will generate a pie chart based on your data. You can customize the chart using the options in the Chart Editor. Here are some customization options:
      • Chart Style: Change the background color, border color, and font.
      • Pie Slice: Modify the color of each pie slice, add labels, or explode slices to emphasize specific data points.
      • Chart & Axis Titles: Add and format the title of your chart and the legend.

Customizing Your Pie Chart

Customization helps in making your pie chart more informative and visually appealing. Let’s look at some key customization options:
  1. Chart Title and Labels:
      • Add a Title: In the Chart Editor, click on the Customize tab, then select Chart & axis titles. Enter your desired title in the Title text box.
      • Label Each Slice: Go to Customize -> Pie slice and check the Label box to add data labels to each slice of your pie chart.
  1. Change Slice Colors:
      • Colors: In the Pie slice section, you can click on each color box next to your categories to change the colors of the pie slices.
      • Explode Slices: To highlight a specific slice, you can 'explode' it by dragging the slice away from the center of the pie.
  1. Legend:
      • Position: Change the position of the legend (e.g., top, bottom, left, right).
      • Font and Color: Customize the font style and color of the legend for better visibility and aesthetics.

Advanced Tips for Pie Charts

While the basic pie chart creation and customization cover most needs, here are some advanced tips to further enhance your pie charts:
  1. Data Labels: Use data labels to display the percentage each slice represents of the whole. This can be done by checking the Use column as labels box in the Chart Editor.
  1. Multiple Pie Charts: If you have more than one data set, consider creating multiple pie charts to compare different categories side by side.
  1. Interactive Charts: Make your pie charts interactive by embedding them into Google Docs or Google Slides. This can be done by copying the chart and pasting it into your document or presentation. The chart remains linked to the Google Sheet, so any changes in the data are reflected in the chart automatically.
  1. Exporting Charts: You can export your pie chart as an image or PDF by clicking on the three vertical dots in the upper right corner of the chart and selecting Download.

Conclusion

Creating a pie chart in Google Sheets is a straightforward process that can greatly enhance the presentation of your data. By following the steps outlined in this guide, you can set up your data, create a pie chart, and customize it to fit your needs. Whether you’re a student, a business professional, or simply someone looking to organize their data visually, Google Sheets provides powerful tools to create and customize pie charts easily.
Remember, the key to an effective pie chart is not only in the creation but also in how well it communicates the data story. So, take your time to customize and tweak the chart until it perfectly represents the insights you want to convey.

Share on socials

About the author

Mehjabi Khan profile photo
Mehjabi Khan— Technical Writer & Sheets Automation Specialist

Mehjabi Khan is one of our talented technical writers with a background in creating spreadsheet solutions for major companies like Mahindra and Suzuki. She specializes in Google Sheets automation, custom functions, and workflow optimization. Her clear, step-by-step tutorials make complex spreadsheet concepts accessible to everyone.

More from Mehjabi

More from the blog