How to Make a Pie Graph in Google Sheets

A pie graph needs one column of category labels and another of values. When categories repeat in the raw records, aggregate them into one row per category before creating the chart.

On the template’s Pie Chart Builder sheet, you’ll use:

• B3: Chart title
• B4: Reporting date
• B5: Unit
• B6: Minimum readable slice, entered as 0.05 for 5%
• F4:F9: Up to six category names
• A15:D30: Source records

Enter a date in column A, a category in column B, a nonnegative numeric amount in column C, and an optional audit note in column D. The category text and spelling in B15:B30 must match a category in F4:F9. Otherwise, the template treats the label as unmapped.

The dates in column A and the reporting date in B4 document the period, but they don’t filter the summary. Every populated source row within A15:D30 is included, regardless of date. When replacing or appending records, make sure they belong to the intended weekly or reporting period.

Set the reporting details in B3:B6, then use F3:I11 to verify that the source data is ready for a pie graph.

The baseline example uses the following category and ticket-count inputs in B15:C26. The corresponding dates in column A serve as audit metadata and don’t affect these totals.

These records aggregate into the chart-ready summary in F3:I9:

The control total is:

Login/access: 42 + 33 + 25 = 100
Billing: 18 + 14 = 32
Performance: 21 + 17 = 38
Feature request: 12 + 9 = 21
Bug: 27 + 19 = 46
Other: 6

Total: 100 + 32 + 38 + 21 + 46 + 6 = 243 tickets

Replace A15:D30 with one dated category count per row. Repeated category labels are combined automatically.

Before creating the graph, check these cells:

• G10 equals 243, confirming the mapped total.
• H10 equals 100%.
• I10 says Ready to chart.
• G11 equals 0, confirming there are no unmapped amounts.
• I11 says All mapped.

When a source category isn’t defined in F4:F9, its amount appears in G11. For example, changing B21 from Other to the undefined label Account deletion produces 6 unmapped tickets. It also reduces the mapped total to 237 and changes the controls to Fix unmapped and Fix source labels.

If every source amount is zero, G10 becomes 0 and I10 says Add amounts. A pie graph can’t show meaningful proportions when the total is zero.

Select only F3:G9, which contains the headers and six intended slices.

Select F3:G9 to create the pie graph. Exclude rows 10 and 11 because they are validation controls rather than slices.

Next:

1. Choose Insert > Chart.
2. In Chart editor > Setup, open Chart type.
3. Select Pie chart.
4. Enable Use row 3 as headers.
5. Enable Use column F as labels.
6. Confirm that the data range remains F3:G9.

Google documents the general creation and editing process in its chart and graph help.

Don’t include rows 10 or 11. Total mapped duplicates the sum of the categories, so including it would distort their percentages. Unmapped amount is a validation control rather than a valid slice. A nonzero unmapped amount changes the proportions, while a zero amount can create an unnecessary zero-value category.

Open the chart’s Customize tab, then apply these settings:

• Under Chart & axis titles, select Chart title and enter Support Ticket Mix - Oct 1-12, 2026, matching B3.
• Under Pie chart, set Slice label to Percentage.
• Under Legend, choose a position that doesn’t cover the graph.
• Move and resize the finished chart over approximately A32:I45.

Changing B3 later doesn’t automatically rename the existing chart. You’ll need to update the title manually through Customize > Chart & axis titles.

In the example, Other is flagged because 6 divided by 243 is approximately 2.47%, which is below the 5% threshold in B6.

A small slice isn’t necessarily an error. Keep it separate when the distinction matters. If several related categories are too small to read, you can assign their source records to a clearly defined Other category. Don’t combine categories simply to conceal meaningful differences.

Pie graphs work well for part-to-whole snapshots with relatively few categories. A bar chart is usually clearer when:

• Several values are close together.
• Readers need precise category comparisons.
• There are too many slices to label clearly.
• Values don’t represent parts of one total.

Google’s chart-type documentation describes pie charts as a way to show proportions of a whole.

For a new weekly batch:

1. Update B3:B4 with the new title and reporting date.
2. Clear only A15:D30.
3. Enter the replacement records starting in row 15.
4. Confirm that the record dates belong to the intended period.
5. Recheck G11, I10, and I11.
6. Manually update the chart title to match B3.

For a cumulative view, append records through row 30 instead of clearing the previous batch. The template supports 16 source rows and doesn’t automatically expand, import, synchronize, or filter its source range.

For more detail on refresh behavior, see Do Google Sheets charts update automatically from source data?.

ModelMonkey can inspect spreadsheet context, organize data, and create or adjust charts in Google Sheets. For this example, you could ask:

Inspect Pie Chart Builder!F3:I11. Confirm that the unmapped amount is zero and the status says Ready to chart. Then create a pie chart from F3:G9 with percentage labels and the title from B3. Do not include rows 10 or 11.

Before using the result, review the proposed range, labels, totals, and chart. You can open the ModelMonkey sidebar in Google Sheets for help checking or adjusting the chart.