NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Charts›Create a pie chart

Google Sheets · Verified tutorial

Create a pie chart in Google Sheets

Create a pie chart from A1:B5 using Category as the labels and Amount as the values.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Create a pie chart from A1:B5 using Category as the labels and Amount as the values.

Step-by-step

1

Select the targetCreate a pie chart from A1:B5.

2

Apply the changeCategory as the labels and Amount as the values.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A pie chart uses the complete A1:B5 data range.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:B5 and repeat the final action. A pie chart uses the complete A1:B5 data range.

Example spreadsheet data

This is the clean fixture used for the verified run.

Category	Amount
Hosting	80
Software	120
Design	300
Advertising	200

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create a pie chart from A1:B5.
Apply the change. Category as the labels and Amount as the values.
A pie chart uses the complete A1:B5 data range.