How To Make A Pie Chart In Google Sheets

Pie Charts are used to show data as “slices of pie,” or proportions of a whole.

Google Sheets makes it quick and easy to generate pie charts from spreadsheet data. When your data updates, the pie chart will automatically update to reflect the change.

Every pie chart needs:

1. A set of labels for the individual categories or “slices” of the chart
2. A set of numbers or percentages associated with these labels that are used to calculate the size of each slice

Insert a Pie Chart in Google Sheets

To insert a Pie Chart in Google Sheets, follow these steps:

Step 1

Select the data range you want to graph

Step 2

Open the Insert menu, and select the Chart option

Step 3

A new chart will be inserted as a floating element above the cells, and the Chart Editor sidebar will appear with options to edit the chart.

To turn this chart into a pie chart, click on the Chart Type dropdown menu and select the PIe Chart option

Step 4

Your chart will update to a Pie Chart

Step 5

You can also select the 3D Pie Chart or Doughnut Pie Chart options to change the look of your pie chart

Editing Your Pie Chart

To edit a chart you’ve already created, first open the Chart Editor for that graph by selecting the chart and clicking on the 3 dot menu icon in the corner of the chart.

From the menu that appears, select Edit Chart. The Chart Editor for that graph will open.

You can then make edits to the chart type, data range, or any of the other chart settings available in the Chart Editor and your chart will update to reflect the changes

Exporting a Pie Chart

If you need to use your pie chart in a presentation or document outside of Google Sheets, you can export it as a .PNG, .PDF, or .SVG.

Here’s how:

Step 1

Select the chart and click on the 3 dot menu icon in the corner of the chart.

Step 2

In the menu that appears, hover over the Download submenu, and click on the file type you’d like to export:

Step 3

Select the filename and location for the file download and click OK

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make a pie chart in Google Sheets. Want more? Check out all the Google Sheets Tutorials.