How to Create a Pie Chart in Google Sheets

Pie charts are one of the most intuitive ways to visualize proportional data — showing how individual parts make up a whole. Google Sheets has a built-in chart tool that makes creating one straightforward, but getting a clean, accurate, and useful pie chart depends on how your data is structured and what you're actually trying to communicate.

What You Need Before You Start

Before inserting a chart, your data needs to be organized in a way Google Sheets can interpret correctly. For a pie chart, you typically need two columns:

• One column for labels — the category names (e.g., product names, months, departments)
• One column for values — the corresponding numeric data (e.g., sales figures, percentages, counts)

The values don't need to be pre-calculated as percentages. Google Sheets will calculate the proportional slices automatically based on the raw numbers you provide.

Example layout:

If your data includes a header row — which is recommended — Sheets will use those headers as chart labels automatically.

Step-by-Step: Creating a Pie Chart in Google Sheets 🥧

1. Select Your Data

Click and drag to highlight both columns, including the header row if you have one. You can also click the first cell, hold Shift, and click the last cell in your value column.

2. Open the Chart Editor

Go to the menu bar and click Insert → Chart. Google Sheets will automatically generate a chart based on what it thinks best represents your data. It often defaults to a bar or column chart.

3. Change the Chart Type to Pie

In the Chart editor panel that opens on the right:

• Click the Chart type dropdown under the "Setup" tab
• Scroll down to the Pie section
• Select Pie chart (standard), Donut chart (hollow center), or 3D pie chart depending on your preference

The chart on your sheet will update in real time as you make changes.

4. Verify Your Data Range

Still in the Setup tab, check that the Data range field reflects the correct cells. If your chart looks off — slices are missing or labels are wrong — this is usually where the issue lies. Adjust the range manually by typing in the correct cell references (e.g., A1:B5).

5. Customize in the Customize Tab

Click the Customize tab in the Chart editor to access visual options:

• Pie chart section: Control slice colors, slice labels (value, percentage, or label), and whether to explode a slice (pull it slightly apart for emphasis)
• Chart & axis titles: Add or edit the chart title and subtitle
• Legend: Reposition or hide the legend
• Slice labels: Choose between showing the label text, the raw value, or the percentage — this matters a lot for readability depending on your audience

6. Move or Resize the Chart

Once created, click anywhere on the chart to select it, then drag it to reposition it on your sheet. Drag the corner handles to resize. To place it on its own dedicated sheet tab, click the three-dot menu (⋮) in the top-right corner of the chart and select Move to own sheet.

Common Issues and What Causes Them

Slices look wrong or uneven: This usually means your value column contains text, empty cells, or inconsistent formatting. Check for hidden spaces or cells formatted as text rather than numbers.

Labels are missing: If your label column wasn't included in the selection — or wasn't recognized as a label column — Sheets may use generic labels like "Row 1, Row 2." Re-check your data range and ensure the header row is included.

Chart defaults to a bar chart instead: Google Sheets infers chart type from data structure. Two columns with a text column and a numeric column should trigger a pie chart suggestion, but it doesn't always happen. Manually switching in the Chart editor takes only a few seconds.

Too many slices: Pie charts become hard to read with more than 6–8 slices. If you have many categories, consider grouping smaller values into an "Other" category before charting, or explore whether a bar chart serves the data better.

Pie Chart vs. Donut Chart: A Quick Distinction

Google Sheets offers both. The donut chart is visually identical to a pie chart except for a hollow center — often used to place a total value or label in the middle for dashboard-style displays. The 3D pie chart adds a visual tilt, which can look polished in presentations but can distort perceived proportions, making some slices appear larger or smaller than they are. That's a known issue with 3D charts in general, worth keeping in mind if accuracy of interpretation matters.

How Your Use Case Changes the Setup 📊

The steps above cover the mechanics, but what "done" looks like varies considerably:

• A student building a class presentation might prioritize bold colors and large percentage labels for visibility on a projector
• A business analyst sharing a report might strip down labels, use branded colors, and export the chart as an image for a slide deck
• A small team tracking budget categories might embed the chart directly in the sheet alongside the source data for easy updating
• Someone using Google Sheets on mobile will find the chart editing options more limited — significant customization generally requires the desktop browser version

The degree to which you need to customize slice colors, adjust label formatting, or connect the chart to dynamic data that updates automatically will shape how much time you spend beyond the basic steps. A simple static chart takes minutes; a polished, automatically refreshing dashboard visual takes more planning around how the underlying data is structured and maintained.