Last Updated on August 7, 2021 by Jake Sheridan
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:
- A set of labels for the individual categories or “slices” of the chart
- 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:
Select the data range you want to graph
Open the Insert menu, and select the Chart option
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
Your chart will update to a Pie Chart
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.
Select the chart and click on the 3 dot menu icon in the corner of the chart.
In the menu that appears, hover over the Download submenu, and click on the file type you’d like to export:
Select the filename and location for the file download and click OK
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.