Can You Create a Pie Chart in Google Sheets? Here’s How

Can You Create a Pie Chart in Google Sheets? Here's How

Yes. In Google Sheets in a web browser, select a table of category names and values, choose Insert > Chart, then set Chart type to Pie chart in the Chart editor. Sheets creates an editable chart you can label, format, move, and update as the data changes.

What a Google Sheets pie chart shows

A pie chart divides one whole into slices, with each slice representing a category’s share of the total. It is most useful when you want to communicate a small set of parts that add up to a meaningful whole, such as how a monthly budget is divided or what proportion of survey responses falls into each answer category.

For example, suppose a monthly spending table lists Rent at $1,200, Food at $500, Transport at $200, and Utilities at $100. Together, the values total $2,000. A pie chart can show rent as 60% of that total, food as 25%, transport as 10%, and utilities as 5%. That makes the broad pattern easy to see without asking readers to compare four separate numbers.

A pie chart is not automatically the right choice just because the data is in categories. It works best when the categories are mutually exclusive and collectively describe the whole. If categories overlap, or if the values are unrelated counts such as sales from different years, the slices may suggest a part-to-whole relationship that the data does not support.

Prepare the data before inserting the chart

Put category labels in one column and the corresponding numeric values in the next. Use one row per category, with an optional header row. For the spending example, the range A1:B5 could contain “Category” and “Amount” in the first row, followed by the four spending categories and their amounts. Select the full range, including the headers, before inserting the chart.

Clean, consistent source data makes chart setup more reliable. Before creating the chart, check that:

Each category has one clear label and one numeric value.
Values are stored as numbers, not text that merely looks like a number.
There are no accidental subtotals or grand-total rows included as categories.
The values represent comparable parts of the same whole and use the same unit.
Category names are distinct enough for a reader to tell the slices apart.

For a pie chart, the clearest starting layout is usually one label column plus one value column. Avoid selecting several unrelated numeric columns: Sheets may interpret them as multiple data series, which is not the intended structure for a simple pie. If you have a total row, leave it out of the selected chart range because adding the total as another slice would count the same values twice.

Create the pie chart in Google Sheets

In the browser version of Sheets, the basic process is short:

Select the category and value cells, including the header row if there is one.
Choose Insert > Chart from the menu.
In the Chart editor, open the Setup tab if it is not already selected.
Open the Chart type menu and choose Pie chart.
Review the preview and confirm that the labels and slices match the intended data.

Sheets may initially choose a different chart type based on the selected range. That is normal; change it in the Chart editor rather than rebuilding the table. If the chart does not use the category column as labels, check the data range and the settings for using the first row as headers and the first column as labels. The exact controls shown can depend on the structure of the selected data.

The chart appears on the sheet as an object. Drag it to reposition it, or use its corner handles to resize it. To reopen its settings, click the chart and use the three-dot menu to choose Edit chart, or double-click the chart. The Chart editor lets you make changes without altering the original values.

Customize labels, colors, and the legend

To make the slices easier to interpret, select the chart and use the Customize tab in the Chart editor. The available choices depend on chart type, but the pie-specific controls are under Pie chart. Use Slice label to show a category label, value, percentage, or a combination of value and percentage when that option is available. Percentages are often the most direct way to show each category’s share; values are useful when readers also need the underlying amount.

Under Chart & axis titles, add a concise chart title that says what the whole represents, such as “Monthly spending by category.” A title like “Spending” is less informative if the time period or population matters. Use the legend controls to place the key where it does not crowd the chart. With a small number of slices and readable labels, a legend may be less necessary; with longer category names, a legend can be cleaner than labels placed around the pie.

Google Sheets also lets you change the appearance of individual slices. In the pie-chart customization settings, choose a slice and adjust its color or offset it from the pie when you need to draw attention to a specific category. Use that emphasis sparingly: a dramatic color or separated slice can imply that the category is especially important, even when the data alone does not make that claim. Keep colors distinct enough to tell slices apart, and do not rely on color alone if the chart will be difficult for some readers to distinguish.

When a pie chart is a good choice—and when it is not

Pie charts are strongest when there are only a few categories and the differences in share are meaningful. A chart with four or five clearly named slices is generally easier to scan than one with many narrow slices. There is no universal category count at which a pie chart becomes unusable, but every additional slice makes labels, colors, and comparisons harder to follow.

Consider another chart when categories are numerous, values are close together, or readers need to compare exact amounts. A bar chart makes it easier to compare category lengths, especially when values are similar. A line chart is generally more appropriate for showing change over time. A pie chart can also mislead if the numbers are not parts of one total—for instance, comparing the number of visitors in three different months does not necessarily describe one whole.

Before deciding, ask what the reader needs to learn. If the main point is “these are the parts of this total,” a pie chart may be effective. If the point is “which category is larger?” or “how did the values change?”, a bar or line chart is often clearer. Choosing a chart for the question, rather than choosing one because it looks familiar, improves the result.

Common problems and how to fix them

If Sheets produces the wrong chart, first confirm that you selected just the intended label and value columns. A blank row, an unrelated column, or a total included as an extra category can confuse the chart setup. Re-select the correct range and change the chart type to Pie chart in Setup. Check that the first column contains category names and that the values column contains numbers.

Labels appear as slices: Check whether the header and label settings are correct, and make sure the selected range includes the intended numeric column.
A category is missing: Look for a blank or text-formatted value, and verify that the chart’s data range includes that row.
The chart includes a total as a slice: Edit the chart’s data range to exclude the total row.
The chart is hard to read: Reduce the number of categories, use clearer labels, or switch to a bar chart when precise comparisons matter.
Changes to the table do not show as expected: Open Edit chart and check that the chart’s data range includes the updated cells.

Zero values do not represent a visible share, while negative values do not make sense as portions of an ordinary whole. If your source contains refunds, losses, or other negative numbers, decide how those should be represented before making a pie chart. Do not silently remove or change values just to make the chart look tidy; explain any exclusions or use a chart type that can show the data faithfully.

Editing, sharing, and using the chart elsewhere

A chart remains connected to its source range in the spreadsheet. When you edit a value or label within that range, the chart can reflect the change. If you add new categories outside the existing range, check the chart’s data range so the additional rows are included. This is especially useful for a recurring report, but it also means it is worth checking the chart before sharing a copy or presenting it.

To share the chart in context, share the spreadsheet using Google Sheets’ sharing controls and choose permissions appropriate for the audience. You can also copy a chart and paste it into another Google application, such as Docs or Slides; depending on the paste options, it may remain linked to the spreadsheet or be pasted without a live link. Review the options shown at paste time, since a linked chart can be updated from its source, while an unlinked image will not automatically follow later data edits.

Creating a pie chart is part of using Google Sheets; there is not a separate chart-making purchase within the spreadsheet. Access to Sheets and certain account features can depend on whether you use a personal Google account or a Google Workspace account, and Workspace plans and terms can vary. For a basic chart, the important requirements are access to the spreadsheet and permission to edit it.

Pie charts versus donut charts and other options

A donut chart is a close alternative: it also shows parts of a whole, but leaves a hole in the center. In Google Sheets, look for the donut chart option in the Chart type menu. It can suit a simple share breakdown, especially if the center is left empty, but it does not solve the difficulty of comparing many similar-sized slices. Labels and a small number of categories still matter.

Bar charts are often better when readers need to rank categories or compare exact sizes. A stacked bar chart can show contributions to a total while making it easier to compare several groups, if your data is organized for that purpose. These alternatives do not make pie charts obsolete; they answer different questions. Use a pie or donut when the whole and its parts are the message, and use bars when comparisons between categories are the message.

Frequently Asked Questions

Can Google Sheets automatically make a pie chart?
Sheets can create a chart from selected data using Insert > Chart and may suggest a chart type. If it chooses something else, set Chart type to Pie chart in the Chart editor.

How do I show percentages on a Google Sheets pie chart?
Select the chart, open Edit chart, then go to Customize > Pie chart. Choose Percentage in the Slice label setting. The labels show each category’s share of the chart’s total.

Can I make a pie chart with more than one data series?
A standard pie chart represents one series of values divided among categories. For a simple chart, arrange one category column and one values column. If you need to compare multiple groups or series, consider a bar or other chart type instead.

Why is my pie chart showing the wrong values?
Check the selected range, confirm that the correct column contains numeric values, and make sure you have not included a total row or unrelated data. Open the Chart editor’s Setup tab to review the range, labels, and chart type.

Can I change the colors of individual slices?
Yes. In the Chart editor, use Customize > Pie chart to select and format a slice. Choose colors that remain easy to distinguish and use special emphasis only when it supports the point you want the chart to communicate.

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.