How to Create a Pie Chart in Google Sheets Step by Step

To create a pie chart in Google Sheets, arrange your categories in one column and their numeric values in the next, select the data, then choose Insert > Chart. In the Chart editor, set Chart type to Pie chart. You can then add a title, display slice labels, and adjust the legend so readers can understand the proportions at a glance. These instructions are for Google Sheets in a web browser.

What You’ll Need

A Google Sheets spreadsheet containing the data you want to chart.
A category for each slice, such as a product name, expense type, or survey response.
A numeric value for each category. Pie charts work best when the values are nonnegative parts of a meaningful whole and at least one value is greater than zero.
A clear idea of what the total represents, such as total monthly spending or all responses to one question. This helps you choose categories that make sense together.

Step-by-Step

Arrange the source data. Put a heading above each column. For example, enter Category in A1 and Amount in B1, then list categories and their values below: Rent, 1200; Food, 450; Transport, 150; and Utilities, 200. Each category should occupy one row, with its corresponding value directly beside it. Use one row per slice and avoid blank rows within the list.
Check that the values are suitable. Make sure the amounts are numeric values rather than text that only looks like a number. Remove currency symbols typed directly into cells if they prevent Sheets from recognizing the values; you can apply currency formatting afterward. A pie chart is most useful for parts of one total, not for comparing unrelated measurements or values that can be negative.
Select the chart data. Drag across the category and value columns, including the headings. In the example, select A1:B5. Including headings makes it easier for Sheets to identify the series and use the column names in the chart. If your data is in separate columns with other information between them, select just the relevant range, or set the precise range in the Chart editor afterward.
Insert a chart. With the range selected, choose Insert > Chart from the menu. Sheets adds a chart to the sheet and opens the Chart editor, usually in a panel on the right. The first chart type may not be a pie chart; that is normal. The chart remains an editable object that you can move or resize.
Choose Pie chart. In the Chart editor, open the Setup tab, then open the Chart type dropdown. Find the Pie section and choose Pie chart. The preview should change to a circle divided into slices. If the preview is blank or the slice names look wrong, check the data range and the setup options before changing the chart’s appearance.
Confirm the data range and labels. In Setup, check that Data range covers both the category names and their values, including headers if present. For a two-column list, the first column should provide the slice labels and the second should provide the values. If Sheets has interpreted the data backwards, use the available options for using the first row as headers or the first column as labels. Adjust the range if it includes extra columns, totals, or unrelated rows.
Add a useful chart title. Open Customize in the Chart editor, then Chart & axis titles. Use the title-type dropdown to select Chart title, and enter a short, descriptive title in the title text field. For example, Monthly household spending is clearer than Chart 1. If the chart needs context, use a subtitle to explain the time period or the group represented.
Show labels on the slices if helpful. In Customize, open Pie chart and choose an option from Slice label. Depending on your needs, you can display category labels, values, percentages, or a combination available in the dropdown. Percentage labels make the parts of the whole easy to compare, while category labels can help when the legend is distant. Avoid turning on more information than the slices can comfortably display.
Position the legend and tidy the chart. Open Customize, then Legend, to choose a position such as right, left, top, or bottom, or to hide the legend if slice labels already identify every category. You can also adjust chart style and text formatting in the relevant Customize sections. Keep the colors distinct and the text readable; a decorative background or many competing colors can make comparisons harder.
Review and place the finished chart. Close the Chart editor when you are done; the chart stays on the sheet. Drag it to a suitable location and use its corner handles to resize it. Check that every category is represented, the title is accurate, and labels do not overlap. If the source values change later, the chart generally updates from its linked data range. Reopen the editor by double-clicking the chart to make further changes.

Common Mistakes

Including the total as another category. If a table lists individual expenses and then a Total row, selecting the total along with the categories counts the same amounts twice in the visual. Select only the category rows, not the summary total. Keep totals outside the chart’s source range unless the total is itself a separate category in the data.

Mixing categories that do not make up one whole. A pie chart implies that its slices are components of a combined total. Comparing revenue from different years, for example, can be misleading if the years are not parts of one whole. Use a column chart for comparisons across separate periods or groups. Also avoid mixing units, such as dollars and units sold, in one pie chart.

Leaving blank, text, or negative values in the value column. Blank cells can lead to missing slices, text may not be plotted as a number, and negative values are not suitable pie slices. Check for accidental spaces, labels in the wrong column, and values stored as text. Correct the source cells rather than trying to make the chart’s colors or labels disguise a data problem.

Using too many small categories. A chart with many narrow slices is difficult to read, especially when labels are switched on. Group minor items into a category such as Other only when that grouping is meaningful and you can still explain what it contains. Otherwise, choose a bar or column chart that can show many categories more clearly.

Tips

Sort the source data in a way that helps readers interpret it, such as largest value to smallest. Sorting is not required for a pie chart, but it can make the legend and slices easier to scan. If you want to preserve a particular order, such as a sequence of survey choices, keep that order and make sure the legend is easy to follow.

Use percentages when your audience needs to understand each category’s share of the total. If you also need the original amounts, show values in a nearby table or choose a label option that includes both when available. Keep in mind that rounded percentages may not add up to exactly 100 percent, even when the underlying values do.

Keep the chart linked to a clean, compact data range. If you expect to add rows, check the chart’s Data range after expanding the table; newly added data is not always included if it falls outside the selected range. For a presentation or report, leave enough room around the chart for the title and legend rather than shrinking it until the labels become difficult to read.

Google Sheets and Excel have similar charting goals but different menus. In Excel, select the data and use Insert > Insert Pie or Doughnut Chart; the chart formatting controls are on Excel’s chart tabs rather than in the Sheets Chart editor. Follow the Sheets menu paths above when working in a browser-based Google spreadsheet.

Troubleshooting

The chart is blank or says it has no data. Open the chart editor and inspect Setup > Data range. Confirm that the range includes the numeric values and that the values are recognized as numbers. If cells contain text, check for leading apostrophes, spaces, or imported data that needs reformatting. Make sure there is at least one positive value and that you have not selected only the heading row.

The slice names are numbers, or the chart uses the wrong column. In Setup, check the selected range and the options for headers and labels. For a simple layout, put category names in the first column and values in the second, with one heading row. If the range includes an unrelated numeric column, remove it from the range. A mistaken row-versus-column interpretation can often be corrected using the Setup options.

Some categories or labels are missing. Look for blank category cells, blank values, duplicate or unclear category names, and rows outside the chart’s range. A zero value has no visible slice, so it may appear to be missing. If labels overlap, make the chart larger, move the legend, use fewer on-slice labels, or show percentages instead of long category names.

The chart changes unexpectedly after editing the sheet. Reopen Setup and confirm that the chart still points to the intended cells. A changed range may include a total row, a new column, or empty rows. Correct the Data range, then review the chart again. If you copied the chart, check which source cells the copy uses before assuming it reflects a different table.

Frequently Asked Questions

Can I make a pie chart with more than two columns?

A basic pie chart needs one set of category labels and one set of numeric values. If your table has extra columns, select only the category and value columns or set the Data range so the chart uses the intended pair. An extra column can make Sheets interpret the series incorrectly.

Can a pie chart show percentages?

Yes. Open the Chart editor, choose Customize > Pie chart, and select Percentage from the Slice label options. The percentage is calculated from the values in the chart. If the labels crowd each other, enlarge the chart or use a legend instead.

Can I change the colors of individual slices?

Yes. In Customize > Pie chart, look for the Pie slice controls, choose a category, and adjust its color. The exact controls shown can depend on the selected chart and editor layout. Use colors with enough contrast to distinguish adjacent slices, and do not rely on color alone if the chart needs to be accessible.

Why do the percentages not add up to exactly 100 percent?

Sheets may round the displayed percentages. Several rounded labels can total slightly below or above 100 percent even though the underlying slices represent the complete whole. This is usually a display effect, not a sign that the chart is adding the values incorrectly.

Can I make a pie chart from a pivot table?

Yes. Select the pivot table’s category labels and summarized values, then use Insert > Chart and choose Pie chart. Exclude grand-total rows from the chart range so the total is not counted again as a slice. If the pivot table changes size, review the chart range afterward.

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.