How to Set Up a Pie Chart in Google Sheets Easily

To set up a pie chart in Google Sheets, put category names in one column and their numeric values in the next, select the data, then choose Insert > Chart and select Pie chart in the Chart editor. You can then adjust the labels, colors, and chart title. This guide is for Google Sheets in a web browser; Excel uses a different chart-insertion interface.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in your browser.
A short list of categories and the number or amount for each category. For example, a department in column A and its expenses in column B.
Data that can sensibly be shown as parts of one whole. Pie charts work best when the values are nonnegative and represent comparable parts of the same total.

You do not need to calculate percentages yourself. Sheets can calculate each slice’s share and display it as a percentage. You should, however, check that the values add up to the total you mean to represent. If the categories leave out part of the whole, the chart will show only the proportion of the values you selected.

Step-by-Step

Arrange the source data in two columns. Put one category per row in the first column and its corresponding number in the second. For example, enter Category and Units sold as headers in A1 and B1, then enter Books and 40, Games and 25, and Music and 35 in rows 2 through 4. Each label must line up with the value it describes. A pie chart needs a single set of values; it is not designed to compare several independent numeric series.
Check and clean the data. Make sure each value is a number rather than text that merely looks like a number. Remove blank rows within the list, stray notes, and totals that should not be counted as categories. If you include a total row along with the individual values, the chart will treat that total as another slice and distort the proportions. Keep the header row if you want Sheets to identify the column names.
Select the range you want to chart. Click the first header cell and drag across both columns and down through the last category. In the example, select A1:B4. You can also click a cell in the data and insert a chart, then correct the range in the Chart editor. Selecting the full range first usually makes the initial chart setup easier. Do not include unrelated notes or extra numeric columns.
Insert a chart. Choose Insert > Chart from the menu. Sheets adds a chart to the sheet and opens the Chart editor, usually on the right. The chart may initially appear as a column chart or another chart type; that is normal. The Chart editor lets you change the type and adjust which cells supply the labels and values.
Choose the pie chart type. In the Chart editor, open the Setup tab and select the Chart type menu. Choose Pie chart. If you want a ring-shaped chart, choose Doughnut chart; it is a related chart type, but not the standard pie chart. A 3D pie option may also be available, but a flat pie chart is generally easier to read because perspective can make slice sizes harder to compare.
Confirm the chart’s data range and labels. In the Setup tab, review the data range. For the example, it should include A1:B4. Check that the category names are being used as labels and the numbers as values. If the available controls show options such as Use row 1 as headers and Use column A as labels, enable them when your first row contains headings and your first column contains category names. For a pie chart, the chart editor may show label and value fields; make sure they point to the correct columns.
Correct the range if the chart is wrong. If the chart has too many slices, too few slices, or uses the header as a slice, edit the data range or label settings in Setup. You can type a range such as A1:B4 into the data-range field, or use its range selector to select the cells on the sheet. Keep the category and value ranges aligned, with one label for every value. If your source data is on another sheet, include that sheet in the selected range using the range selector.
Add a useful title and labels. Open the Customize tab and expand Chart & axis titles. Choose the chart title option, then enter a concise title that explains what the slices represent and, if useful, the time period. To show details on the slices, expand Pie chart and choose a suitable Slice label, such as Label, Value, or Percentage. The exact label choices shown can depend on the chart type and editor options.
Adjust the appearance. In Customize, use the chart style and pie-chart settings to refine the background, border, slice colors, or label text. Pick colors that remain distinct and readable. Avoid relying on color alone if the chart will be viewed by people who may have difficulty distinguishing colors; slice labels can help. Make changes gradually and check that the chart remains legible at its actual size.
Position and resize the chart. Close the Chart editor when you are finished. Click the chart and drag its border or corner handles to resize it, or drag the chart itself to move it. Keep enough room for the title and any labels so they do not overlap. Sheets saves changes automatically, so there is no separate save command to finish the chart.
Verify what the chart communicates. Compare the slices with the source values. In the example, the values 40, 25, and 35 total 100, so their percentages are 40%, 25%, and 35%. If your chart does not show the expected proportions, check that the range contains the intended values and does not include a total or unrelated row. Consider whether the categories truly make up one whole before sharing the chart.

Common Mistakes

Including a grand total as a slice: A total row is useful in a table, but it should normally be left out of the chart range when the rows above it are the parts that add up to that total. Including it counts the same quantities twice and makes every displayed share misleading.

Selecting extra columns or rows: A note, blank row, or second numeric measure can confuse the chart setup. Select just the category labels and the one set of values you want to visualize. If you have many categories, the chart may become crowded even when the selection is technically correct.

Using categories that do not describe parts of one whole: A pie chart implies that the slices are parts of a combined total. Comparing unrelated measures, such as temperatures in different cities, usually calls for a different chart. A bar chart is often clearer for comparisons or for values that can be negative.

Leaving duplicate labels unexplained: Repeated category names may appear as separate slices rather than being combined in the way you intended. If repeated entries should count as one category, summarize or group them in the source data before charting. Check the result instead of assuming Sheets has consolidated them.

Making the chart hard to read: Too many small slices, long labels, similar colors, or labels placed over one another can make a pie chart difficult to interpret. Use a shorter category list, a clear legend, or a different chart type if the slices are crowded.

Tips

Sort the source table before charting if the order of categories matters to your audience. For instance, sorting by value can make the largest slices easy to identify. The chart follows the order of the underlying categories, so change the table order if you want a different slice sequence.

Use a descriptive title rather than a generic heading such as “Results.” “Share of quarterly support requests by topic” tells readers both what the categories mean and what the whole represents. If the values cover a particular month, region, or reporting period, include that context in the title or a nearby note.

Choose one or two label types rather than trying to show every possible detail on each slice. Percentages are useful for showing share; category names help identify slices; values are helpful when the actual counts matter. For a small chart, put some details in the legend instead of crowding the slices.

Keep the data table beside the chart or on a clearly named sheet. This makes it easier for someone else to check where the proportions came from. If the chart will be copied into a report, test its readability at the size it will appear there, not only while it is enlarged in the spreadsheet.

For a chart that needs to update as new rows are added, make sure the chart’s data range includes those rows or update the range when the table grows. Check the chart after extending the source data. Do not assume every future row will be included if the chart range stops at the last row that existed when you created it.

Troubleshooting

The chart does not appear as a pie: Select the chart, open the Chart editor’s Setup tab, and set Chart type to Pie chart. If you cannot see the editor, double-click the chart or use its three-dot menu to open editing options.

The chart shows the wrong labels or values: Review the data range and the label/value assignments in Setup. Confirm that the names and numbers occupy the columns you expect, that headers are identified as headers, and that the selected range does not start or end one row too early. Correct the range and check the chart again.

Some categories are missing: Look for blank labels, blank or nonnumeric values, and rows outside the selected range. Confirm that the missing entries are included in the range and that their values are stored as numbers. Zero values have no visible slice because they contribute no share; negative values are not suitable for representing parts of a whole.

Every category appears as an equal slice: Check whether the values were imported or formatted as text. Re-enter or convert them to numbers, then verify that each number is paired with the correct label. Also check that the chart is using the intended value column rather than a column of repeated values.

The percentages do not add up as expected: Check the chart range for an included total, duplicate entries, or omitted categories. Rounding can make displayed percentages sum to slightly more or less than 100%, even when the underlying shares total 100%. If the difference is substantial, inspect the selected data and calculate the total from the intended categories.

The chart is unreadable or too crowded: Reduce the number of categories by grouping small ones where it makes sense, enlarge the chart, or show labels in a legend instead of on every slice. If readers need to compare many similar values precisely, replace the pie chart with a bar chart rather than forcing more labels into the same space.

Frequently Asked Questions

Can Google Sheets make a pie chart from two columns?
Yes. Use one column for category labels and an adjacent column for numeric values, select both columns, then choose Insert > Chart. Check the Setup tab to confirm that Sheets interpreted the columns correctly.

How do I show percentages on the slices?
Select the chart, open Customize in the Chart editor, expand Pie chart, and choose Percentage in the Slice label setting if that option is available. If labels overlap, enlarge the chart or use a legend and fewer on-slice details.

Can I change the colors of individual slices?
Yes. In the Chart editor, open Customize and expand Pie chart. Use the slice formatting controls to select a slice and change its color. Keep the palette consistent and make sure neighboring slices are easy to distinguish.

Why does my pie chart leave out a category?
Check whether the category is inside the chart’s data range and whether its value is a valid number. A zero value produces no visible slice, while a blank label or a misaligned range can prevent the category from appearing as expected.

Can a pie chart show negative numbers?
A pie chart is intended to show nonnegative parts of a whole, so negative values cannot be represented as meaningful slices. Use a bar or column chart when your data includes negative values or when the categories are not components of one total.

Will the chart update when I change the numbers?
Yes. A chart generally updates when values in its source range change. If you add new categories beyond the selected range, edit the chart’s data range in Setup so those rows are included.

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.