Guides · Google Sheets
How to make a pie chart in Google Sheets
Google Sheets draws a pie chart that stays linked to the cells. Use that when the table is still changing. Use a paste when you want a picture for a slide and you are done editing. Pie Chart Maker is not part of Google. You do not sign in to use the paste.
Insert the chart in Sheets
- Arrange labels in one column and numbers in the next. Leave out the total row.
- Select the range, including the header.
- Choose Insert, then Chart. The chart editor opens on the right.
- Set Chart type to Pie chart. If Sheets guessed a different type, change it in the Setup tab.
- Open Customize, then Pie chart. Set the slice label to Percentage, or to Percentage and value if you want both. Category names can go in the legend instead of on the slices.
The chart updates when the cells change. To get a file out, you can download the sheet as PDF or copy the chart into a slide. Copying into Google Slides sometimes keeps a link and sometimes pastes a picture, depending on how you paste. A downloaded PNG is more predictable.
Paste, if you only need the figure
Select the two columns, copy, and paste into the pie chart maker for Google Sheets. The box reads the tabs Sheets puts on the clipboard. Download PNG for Google Slides or SVG for a design tool. Nothing is written back to the sheet.