To make a pie chart in Google Sheets with percentage labels on each slice, the quickest path is to skip the spreadsheet's built-in chart editor entirely: copy your two columns — category labels and their raw values — out of Google Sheets, paste them as "Label, Value" lines into the Pie Chart Maker, and let the tool compute the percentages and draw the slices for you. The percentage on each slice equals that slice's value divided by the sum of every value, so the slices always add up to 100%. You do not need to add a percentage column in Sheets, you do not need to wrestle with the chart editor's "Customize" pane, and you do not need to format anything by hand. The result is a clean, color-coded pie chart with a legend that already lists label, raw value, and percentage, and you can download it as a PNG with one click. This approach works for browser market-share figures, survey responses, budget breakdowns, or any other list of categories paired with numbers — and because the chart is drawn on your own device using an HTML canvas, nothing in your spreadsheet leaves the browser.
Why a Browser Tool Often Beats the Native Google Sheets Chart
Google Sheets can absolutely produce a pie chart, but the experience is heavier than most people expect. You select the data range, open Insert > Chart, pick "Pie chart" from the Chart type dropdown, and then drill into the Customize tab to flip on "Slice label" and change it from "None" to "Percentage" or "Label and percentage". The chart preview updates only after each setting change, the legend has to be repositioned manually if it overlaps a slice, and the final image you save is whatever Google decides to export — usually a slightly compressed PNG that may include extra white margins. For a one-off chart in a hurry, that is a lot of clicking.
A purpose-built tool collapses all of that into three small steps. The trade-off is that the chart lives outside your spreadsheet, but for a static image that goes into a slide, a doc, or a chat message, that is usually exactly what you want. If you do prefer to stay inside Sheets and use the native editor, our step-by-step walkthrough of the built-in Google Sheets route covers that path in detail.
Getting Your Data Out of Google Sheets
Your Google Sheets data needs to be in two adjacent columns: one for labels (the names of the slices) and one for the numeric values that decide slice size. A typical setup for browser market share looks like the table below.
| Browser | Market Share |
|---|---|
| Chrome | 63 |
| Safari | 20 |
| Firefox | 12 |
| Edge | 5 |
To copy these into the Pie Chart Maker, drag-select the two columns (skip the header row if you do not want the header text in the chart legend), press Ctrl+C on Windows or Cmd+C on Mac, then open the tool in a new browser tab and paste into the input box. Sheets pastes each row as a tab-separated line, so you need one quick replace: use Ctrl+H to turn the tab character into a comma followed by a space, so "Chrome\t63" becomes "Chrome, 63". Header rows, blank lines, and rows that have no number are all ignored by the tool, so a rough paste usually works without further edits. For larger datasets, paste a small block first to confirm the format is right, then paste the rest.
Build the Percentage Pie Chart in Three Steps
- Enter your data in the input box, one item per line in the format "Label, Value". For the market-share example, the four lines are: Chrome, 63 / Safari, 20 / Firefox, 12 / Edge, 5.
- Watch the pie chart redraw instantly. Each slice is sized by its share of the total, given a distinct color from the built-in palette, and listed in a legend that already shows the label, the raw value, and the percentage. The percentages are computed for you from the values you enter, so the slices always add up to 100%.
- Optionally add a chart title that describes what the whole pie represents (for example, "Desktop browser market share, 2024"), then click Download to save the chart as a PNG image with a white background.
Worked example with the four values above: 63 + 20 + 12 + 5 = 100 total. Chrome 63 ÷ 100 = 63%. Safari 20 ÷ 100 = 20%. Firefox 12 ÷ 100 = 12%. Edge 5 ÷ 100 = 5%. The slices in the chart match those percentages exactly, which is also a quick way to sanity-check your source data — if a slice looks the wrong size, the number behind it is probably the wrong number.
Tips for a Cleaner Percentage Chart
A pie chart is at its best with a small number of slices and short labels. Once you go past seven or eight categories, the slices get hard to tell apart and the legend starts to dominate the image. Group tiny categories into an "Other" row whenever you can — if you have a long tail of small values, sum them into a single line such as "Other, 14" and the chart becomes much easier to read at a glance.
Order your rows from largest to smallest. Slices are drawn in the order you list them starting from the top, so listing the biggest slice first and working down keeps the visual flow tidy. Keep labels short too: two or three words is usually enough, since long category names stretch the legend and force the chart to shrink. State what the whole pie represents in the title — "Desktop browser market share" is more useful than "Sheet1" and saves every viewer a guess.
Once the PNG is downloaded, reuse it wherever you need it: drop it into a Google Slides deck, a Google Doc, an email, or a chat message. The image is a standard PNG, so it pastes anywhere without a second export step.
Pie Chart Tools Compared
| Tool | Where it runs | Percentage handling | Output | Best for |
|---|---|---|---|---|
| Google Sheets chart editor | Browser, inside your spreadsheet | Manual — enable Slice label → Percentage in the Customize tab | PNG export from the chart menu | Charts that stay live-linked to the data |
| Pie Chart Maker | Browser tab, on your device | Automatic — computed from the values you enter | One-click PNG download | A finished, shareable percentage chart with no setup |
| Microsoft Excel | Desktop or Excel for the web | Manual — Data Labels options on the chart | PNG or copy-paste image | Users already working in Excel |
| Canva | Browser, online editor | Manual — drag-and-drop labels onto slices | PNG or PDF | Highly designed slides and reports |
The right pick depends on what you need. If the chart must update whenever the spreadsheet changes, the native Google Sheets editor keeps a live link between the data and the image. If you want a clean, percentage-labeled pie chart you can paste anywhere right now, the Pie Chart Maker is faster end to end because the percentages are computed for you, the legend is built in, and the downloaded PNG is ready to drop into a slide the moment it lands on your desktop.