ARTICLE / 5 MIN READ
How to Create a Pie Chart in Google Sheets
FEBRUARY 18, 2026
Pie charts are one of the most recognizable chart types in the world — and also one of the most misused. The good news: making one in Google Sheets takes about two minutes. The better news: you’ll also learn when not to use one, which will save you from some embarrassing charts down the line.
When a Pie Chart Actually Makes Sense
Use a pie chart when:
- You’re showing how a total breaks down into parts (market share, budget allocation, survey responses)
- You have 5 or fewer slices — ideally 3–4
- The differences between slices are visually obvious (roughly half, a quarter, a small slice)
Skip the pie chart when:
- You have more than 5–6 categories — the thin slivers become impossible to compare
- The values are all similar in size — a pie chart can’t show the difference between 18% and 22% clearly
- You’re trying to show change over time — use a line chart instead
A good rule: if your biggest slice isn’t at least twice the size of the smallest, a bar chart will communicate your data more honestly.
Step 1 — Prepare Your Data
Pie chart data is the simplest structure in all of spreadsheets: two columns. One for category names, one for values.
| Category | Amount |
|---|---|
| Marketing | 32000 |
| Sales | 28000 |
| Operations | 18000 |
| R&D | 12000 |
Make sure your values don’t include a “Total” row — Google Sheets will try to plot that as its own slice and your chart will be wrong.
Step 2 — Select Your Data and Insert the Chart
Click and drag to select both columns including the header row. Then:
Insert → Chart
The Chart Editor opens on the right. Google Sheets may or may not guess “Pie chart” automatically. If it picked something else, click the Chart type dropdown and scroll to find Pie chart.
You’ll see the chart update in real time as you make changes.
Step 3 — Customize the Labels
By default, Google Sheets shows the legend on the side instead of labeling slices directly. For a pie chart, it’s much cleaner to show labels on the slices themselves.
In the Chart Editor → Customize tab → Pie chart section:
- Slice label: change from “None” to “Label and percentage” or “Percentage”
This puts the category name and/or percentage directly on each slice, making the chart readable without needing to cross-reference the legend.
Step 4 — Adjust Colors
Each slice gets an auto-assigned color. To change them:
In the Customize tab → Pie slice → use the dropdown to select a specific slice → click the color box to pick a new color.
If your data has a natural ordering (like traffic light colors for good/warning/bad), assign colors intentionally. Random colors are fine for internal use but look amateurish in reports.
Step 5 — Optional: Make It a Donut Chart
Google Sheets can turn your pie chart into a donut chart (a pie with a hole in the middle) with one click.
In Customize → Pie chart → drag the Donut hole slider to the right.
Donut charts are a stylistic choice — they look more modern and the center hole can be used to display a key number or title. Neither is “better”; it’s just preference.
Adding a Chart Title
Click the Customize tab → Chart & axis titles → type your title in the “Chart title” field.
A good pie chart title states both what’s being measured and the time period: Budget Allocation — FY 2026 or Traffic Sources — Q1 2026
Sharing Your Pie Chart
As an image: Click the three dots (⋮) in the chart’s top-right corner → Download → PNG.
In Google Slides: Copy the chart and paste it into Slides. Choose “Link to spreadsheet” so it stays connected and updates automatically when your data changes.
In a report: Download as PNG and insert it into your Google Doc or Word file.
The Honest Caveat
Pie charts are great for one thing: giving someone a quick visual sense of proportion. For anything more nuanced — comparing close values, showing trends, ranking items — a bar or column chart is almost always clearer.
When you’re not sure which to use, make both and see which one communicates the point faster at a glance. That’s your answer.
Pie charts don’t need to be complicated. Two columns of data, five minutes, and you’ve got something that immediately tells a story.