How to Make a Pie Graph in Google Sheets: A Clear Guide

To make a pie graph in Google Sheets, put each category in one column and its numeric value in the next, select both columns, then choose Insert > Chart and select Pie chart in the Chart editor. You can then add slice labels, adjust colors, and position the chart. A pie graph shows how categories contribute to a whole, so it works best when the values are nonnegative and the number of categories is manageable.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
A sheet containing category names and one set of numbers to compare, such as product names and sales.
Values that represent parts of one whole. They can be counts, amounts, or percentages; Sheets can calculate each slice’s share from the values.

You do not need to calculate percentages or write a formula before making the chart. These instructions apply to Google Sheets in a browser. Excel also has pie charts, but its chart controls and menu paths differ from the ones described here.

Step-by-Step

Arrange the source data. Put category names in the first column and their values in the next column. For example, enter Category in A1 and Items sold in B1, followed by Apples and 30 in row 2, Oranges and 20 in row 3, and Pears and 10 in row 4. Keep one category per row. Use a single numeric column for the pie slices; do not include a separate total row in the selected range. Check that values are numbers rather than text, and remove blank rows within the data if possible.
Select the data range. Click and drag from the header cell at the top left through the last category and its value. In the example, select A1:B4. Include the header row so Sheets can use it to identify the data series, but do not select unrelated notes or other numeric columns. If the data is far apart, hold Ctrl on Windows while selecting additional ranges only when needed; for a straightforward pie chart, a continuous two-column range is simpler and less error-prone.
Insert a chart. With the range selected, choose Insert > Chart from the menu. Sheets places a chart on the current sheet and opens the Chart editor, usually on the right. The chart may initially be a column chart or another type chosen automatically. That is expected; you will set the type in the next step. If the editor does not appear, double-click the chart to reopen it.
Choose the pie chart type. In the Chart editor, open the Setup tab. Open the Chart type dropdown, then choose Pie chart from the Pie section. Do not choose Doughnut chart unless you specifically want a ring-shaped chart with an empty center. The preview should now show one slice for each category with a nonzero value.
Check how Sheets reads the range. In the Setup tab, confirm that the data range includes the intended labels and values. With the example range A1:B4, Sheets should use the first column as labels and the second as the series. If the slices show numbers as labels, enable Use column A as labels if that option appears. If the header is being plotted as a slice, enable Use row 1 as headers. The exact options shown can depend on the selected range. For a pie chart, make sure the chart uses one value series rather than treating several columns as separate series.
Add a descriptive chart title. Open the Customize tab, then expand Chart & axis titles. In the title type dropdown, choose Chart title, then type a short title in the title text box, such as Items Sold by Fruit. You can also adjust the title font, size, format, and color in this section. A useful title says what the values represent and, if needed, the period covered. Pie charts do not have axes, so you do not need to add axis titles.
Show useful slice labels. In Customize, expand Pie chart and open Slice label. Choose an option such as Label, Value, Percentage, or Value and percentage, depending on what you want readers to see. For a presentation about shares, Percentage is usually easiest to scan. For a chart where the actual counts matter, Value or Value and percentage may be more useful. Labels can overlap when there are many thin slices; if the chart becomes crowded, show fewer labels or use a different chart type.
Adjust the appearance and position. In Customize > Pie chart, select a slice from the slice dropdown if you want to change that slice’s color or offset. You can also expand Legend to choose a position, text color, or font size, and expand Chart style to change the background or border. To move the chart, click and drag it on the sheet. Drag a corner or edge handle to resize it. Keep it large enough for the title, legend, and labels to remain readable.
Review and keep the chart up to date. Check that every displayed slice matches a category and that the percentages make sense. The example totals 60 items, so Apples account for 50%, Oranges for about 33.3%, and Pears for about 16.7%. If you later change a value in the selected range, Sheets updates the chart. If you add more categories below the range, edit the chart’s data range in Setup to include the new rows. The chart does not necessarily expand to include data placed outside its original range.

Common Mistakes

Selecting several value columns. A pie chart represents one series of parts. Selecting columns for multiple months or departments may make Sheets interpret the range in an unexpected way. Choose one label column and one value column, or prepare a separate two-column summary for the specific comparison you want to show.

Including a total as another category. A total row is not an extra slice; it is the sum of the slices. Including it makes the whole chart add up to the categories plus the total, so every share is misleading. Leave the total outside the selected range.

Using negative, blank, or text values. Negative values cannot represent a slice of a whole, and text that looks like a number may not be charted as intended. Remove invalid entries, convert values to numeric cells, and make sure the remaining values have a positive total. Zero-value categories have no visible slice.

Making a pie chart with too many categories. A long list creates many tiny slices and labels that are hard to compare. Group small categories into a meaningful Other category when appropriate, or use a bar chart when precise comparisons matter more than showing proportions.

Confusing values with percentages. You can enter counts such as 30, 20, and 10; Sheets calculates their relative shares for the chart. Avoid entering both the original values and a percentage column as separate data series.

Tips

Use category names that are short but clear, and sort the source table in a deliberate order. Sorting values from largest to smallest can make a chart easier to interpret, though the slice order follows the source data and may change if you sort the table. If the category order has a meaningful sequence, such as steps in a process, preserve that order instead.

Choose labels based on the chart’s purpose. Percentages work well when the question is how the whole is divided; values work better when the audience needs counts. A legend can clarify categories without placing text over small slices. If both the legend and direct labels make the chart crowded, remove one of them using the Legend controls or the Slice label setting.

Keep the source data on the sheet rather than typing values into the chart itself. This makes it easier to correct a number and have the chart update automatically. Consider adding a note near the chart that defines the time period or population represented. A pie chart communicates proportions, but readers still need to know what the total includes.

Use a pie chart only when the categories add up to a meaningful whole and are mutually distinct. If categories overlap, such as customers who can belong to more than one group, their values do not form a valid partition. For comparisons across several time periods, a line or bar chart is usually clearer than multiple pie charts.

Troubleshooting

The chart is blank or has no visible slices: In Setup, check the data range and make sure it includes the numeric values, not just the category names. Confirm that the cells contain numbers and that the total is greater than zero. If values were imported as text, re-enter or convert them into numeric values and check for stray spaces or symbols.

Category names do not appear: Check that the names are in the column beside the values and that the correct column is being used for labels. In Setup, turn on the option to use the first column as labels if it is available. Also confirm that the selected range starts with the intended label column rather than the values column.

The chart shows a header or total as a slice: Return to Setup and check the header setting and selected range. Enable Use row 1 as headers when the first row contains column names, and remove any total row from the chart range. The total can remain on the worksheet; it simply should not be included as a category.

The percentages look wrong: Verify that each category appears only once and that the range excludes totals, notes, and unrelated rows. For values 30, 20, and 10, the total is 60, so the expected shares are 50%, 33.3%, and 16.7%. If the result differs substantially, inspect the source values and the range for an extra row or column.

Labels overlap or are difficult to read: Increase the chart size, shorten category names, reduce the number of slices, or change Slice label to a less detailed option. You can also use a legend rather than labels on every slice. If small categories still cannot be distinguished, switch to a bar chart, which is often more readable for many categories.

The new category does not appear after editing the table: Open the chart’s Setup tab and expand the data range to cover the added row. Editing cells already within the chart range updates the chart automatically, but adding data below or beside that range may require changing the range manually.

Frequently Asked Questions

Can Google Sheets calculate the percentages automatically?

Yes. Select Percentage under Customize > Pie chart > Slice label to display each category’s share. You can chart the original counts or amounts; you do not need to calculate a percentage column first.

Can I make a pie chart with more than one data series?

A standard pie chart displays one series of values, with each value becoming a slice. To compare different series, such as sales in several years, make separate charts or choose a chart type designed for side-by-side comparisons.

How do I change the color of one slice?

Double-click the chart to open the Chart editor, then go to Customize > Pie chart. Use the slice selector to choose a category and set its color. If you do not see the control, confirm that the chart type is Pie chart.

Can I make a doughnut chart instead?

Yes. In the Chart editor’s Setup tab, open Chart type and choose Doughnut chart. It uses the same category-and-value data structure, but displays a hole in the center. Use it when that layout suits the presentation; it still represents one series.

How do I download or share the pie graph?

To share the sheet, use the Share button and set the appropriate access. To export only the chart, click it, open its three-dot menu, and choose Download, then select an available format. Menu choices can vary slightly as Google updates Sheets.

Why is a pie chart sometimes a poor choice?

It is difficult to compare slices with similar sizes, and many categories make the chart cluttered. Use a pie chart for a small set of parts that add up to a whole. For precise ranking or changes over time, a bar or line chart is usually easier to read.

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.