Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to make a pie chart in Google Sheets

Show how parts make up a whole: select your data, insert a chart and choose Pie chart.

Accounting & Finance
6 steps 2 min Community template
1

Select your data

Highlight the cells to chart, including the header row - here, the categories and their amounts.

docs.google.com/spreadsheets/
Select your data
2

Click Insert

Open the Insert menu.

docs.google.com/spreadsheets/
Click Insert
3

Click Chart

Choose Chart. A chart appears and the Chart editor opens.

docs.google.com/spreadsheets/
Click Chart
4

Click the Chart type box

In the Chart editor, open the Chart type list under Setup.

docs.google.com/spreadsheets/
Click the Chart type box
5

Click Pie chart

Pick Pie chart from the list.

docs.google.com/spreadsheets/
Click Pie chart
6

Pie chart created

Each slice shows one category's share of the total. Use the Customize tab to add percentages or change colors.

docs.google.com/spreadsheets/
Pie chart created

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.