Google Sheets Pie Charts: Create, Customize, and Fix Them

To make a pie chart in Google Sheets, put category names in one column and their numeric values in the next, select both columns, then choose Insert > Chart and set Chart type to Pie chart. The chart turns the values into slices that show each category’s share of the total. You can then add a title, labels, and colors in the Chart editor.

What You’ll Need

A Google account and Google Sheets open in a web browser. The steps below use the desktop browser interface.
A small, tidy table with one category per row and a nonnegative number for each category. For example, list product types and their sales, or expense categories and their amounts.
A clear idea of what the whole pie represents. Pie charts work best when the categories are parts of one meaningful total and do not overlap.

Step-by-Step

Arrange the source data. Put category names in the first column and values in the next, with a descriptive header in the top row. For example, enter Category in A1, Orders in B1, then Snacks and 42, Drinks and 31, and Meals and 27 in rows 2 through 4. Each row should describe one category, and each value should use the same unit. Do not include a grand-total row in the chart range: Sheets calculates the total from the selected category values, so including a total would count it as another slice.
Check the numbers before selecting them. Make sure the value cells contain numbers rather than text that only looks like a number. Remove blank category rows and decide how to handle missing values; a blank should not quietly stand in for a real zero. Pie slices represent shares of a whole, so use values that are zero or positive. If your data includes negative amounts, choose a different chart type, such as a column chart, that can show values below zero.
Select the labels and values together. Drag across the complete table, including the headers. In the example, select A1:B4. Keeping the names beside their values helps Sheets assign the first column as slice labels and the second as the single data series. If the columns are separated by other data, it is usually simpler to make a compact two-column table first rather than selecting scattered ranges.
Insert a chart. From the menu, choose Insert > Chart. Sheets creates a chart and opens the Chart editor, usually on the right side of the window. It may initially choose a column chart or another type; that is normal. The chart is an object on the sheet, so you can drag it to another spot or use its corner handles to resize it without changing the source table.
Choose the pie chart type. In the Chart editor, open the Setup tab and select the Chart type dropdown. Scroll to the Pie section and select Pie chart. The standard pie chart is suitable for showing category shares. If you prefer a ring-shaped chart with a hole in the middle, choose Doughnut chart instead. Confirm that the preview shows one slice per category rather than a separate series for each category.
Confirm the data range and chart setup. In Setup, check that Data range covers the intended labels and values, including the headers but excluding any totals or notes. Look at the X-axis and Series fields: the category names should be used as labels, and the numeric column should be the one series. If Sheets has interpreted the rows and columns the wrong way, use Switch rows / columns if that control is available for the chart, or correct the range and verify the column selection. Make sure Use row 1 as headers and Use column A as labels are selected when those options appear and match your layout.
Add a title and useful slice labels. Open Customize, then Chart & axis titles. Use the title-type dropdown to choose Chart title and enter a short, informative title, such as Orders by Category. Next open Pie chart and choose a Slice label option. Label displays category names, Value displays the underlying numbers, and Percentage shows each slice’s share; available options can vary slightly with the chart setup. For a quick share comparison, Percentage is often clearest. If readers need to identify categories without relying on color, choose Label or use a legend as well.
Adjust the appearance and check the result. In Customize, open Legend to change its position, or open Pie slice to select a category and change its color or offset when those controls are available. Use colors with enough contrast, but avoid making every slice visually loud. Review the chart at its final size: labels should be readable, all categories should be identifiable, and the title should explain what the data covers. Close the Chart editor when you are done. Changes to the source values will update the chart, so check it again after editing the table.

Common Mistakes

Including the total as a category: If the selected range contains a row labeled Total, Sheets treats that row as another slice. The proportions become misleading because the total is counted in addition to its parts. Select only the individual categories.
Using categories that overlap: A pie chart suggests that every item belongs to one, and only one, part of the whole. For example, a person counted under both Online and Returning customers makes the slices add up to more than the distinct population. Define non-overlapping categories first.
Charting unrelated measures together: Do not combine dollars, units, and percentages as though they were comparable parts of one total. Use one measure and one period, or make separate charts.
Leaving the labels ambiguous: Generic names such as Item 1 or short codes can make a chart hard to interpret. Use concise category names and a title that states the subject or time period.
Adding too many slices: A pie with many small categories becomes difficult to read, especially when labels collide. Group genuinely minor categories into Other only if that grouping makes sense and you can still explain what it contains; otherwise, consider a bar chart.
Assuming colors communicate exact values: Similar shades can be hard to distinguish, and color alone is not a precise comparison. Turn on useful labels or keep a visible legend.

Tips

Use percentages when the share matters. A pie chart expresses each value as a fraction of the sum of the plotted values. For example, 42, 31, and 27 total 100, so their displayed shares are 42%, 31%, and 27%. If the values total 200 instead, Sheets still calculates each slice as a share of 200; the numbers do not need to add up to 100 beforehand.
Keep the chart focused. A short title and a small number of well-named slices make the point easier to see. Put detailed notes in nearby cells rather than squeezing a paragraph into the title or labels.
Choose labels based on the reader’s task. Use category labels when people need to identify the slices, percentages when they need to compare shares, and a legend when direct labels would crowd the chart. Try one option at a time and inspect whether the chart remains easy to scan.
Leave room for changes. If you expect to add categories, include appropriate blank rows in the chart’s data range or update the range when you add a new row. Do not include large areas of unrelated cells just in case; an overly broad range can make the chart pick up empty or irrelevant data.
Use a different chart when comparison is the priority. People are better at comparing lengths than angles. If several slices are close in size, or the exact ranking matters, a bar chart can be easier to interpret than a pie chart.

Troubleshooting

The chart shows columns or bars instead of a pie: Click the chart, open Edit chart if the Chart editor is closed, then go to Setup > Chart type and explicitly choose Pie chart. Do not rely on Sheets to guess the chart type from the selection.
The chart shows the wrong categories or values: In Setup, inspect Data range and confirm it includes the category column and the intended numeric column. Check the X-axis and Series entries, and make sure the header and label settings match the table. If you have a total row, remove it from the range.
Labels are missing, overlapping, or hard to read: Under Customize > Pie chart, try a different Slice label choice or turn labels off and use the legend. Enlarge the chart by dragging a corner, shorten long category names in the source data, or reduce the number of slices. A larger chart will not solve every problem if there are too many categories.
A category does not appear as a slice: Check that its value is numeric and greater than zero. A zero has no visible slice, while text, blanks, or a value stored in an unexpected format may not be plotted as you expect. Correct the source cell, then confirm that the row falls inside the chart’s data range.
The shares look wrong after an edit: Verify that the chart is based on the intended rows and that no duplicate, subtotal, or total is included. Remember that the percentage for each slice is calculated from the values in the chart range, not from a separate percentage column unless you deliberately chart that column.
The Chart editor is not visible: Select the chart and use its three-dot menu to choose Edit chart. If the chart is difficult to select, click its edge rather than a slice, or reload the sheet after checking that your internet connection is active.

Frequently Asked Questions

How do I show percentages on a Google Sheets pie chart?

Select the chart, open Customize in the Chart editor, expand Pie chart, then set Slice label to Percentage. If you also need category names, use a legend or choose a label option that makes the categories clear; displaying every detail directly on a small chart can cause clutter.

Do the values have to add up to 100?

No. Sheets calculates each slice as its value divided by the sum of all plotted values. Values of 42, 31, and 27 happen to add to 100, but values of 420, 310, and 270 would show the same proportions. Use consistent units and make sure the selected categories represent the whole you want to explain.

Can a pie chart update when I change the data?

Yes. A chart linked to its source range updates when values in that range change. If you add a new category outside the selected range, edit the chart’s Data range in Setup so the new row is included. Check that the added row has both a label and a numeric value.

Can I make a pie chart with several data series?

A pie chart is designed to show one series of values split among categories. If you need to compare the same categories across multiple years or groups, use a different chart type, or create a separate pie chart for each series and label them clearly.

Are these instructions the same in Excel?

No. These menu paths are for Google Sheets in a web browser. In Excel for Microsoft 365 on Windows, select the data and use Insert > Insert Pie or Doughnut Chart; chart formatting is handled through Excel’s chart tabs and format controls rather than the Google Sheets Chart editor.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.