Pie charts in Google Sheets - Step-by-Step Guide

Introduction

Pie charts help you show parts of a whole using slices. They make it easy to see how different categories compare in size. This is useful when you want to visualize percentages or proportions in your data.

When you want to show how your monthly expenses break down by category.

When you need to display the market share of different brands in a simple visual.

When you want to compare the sales of different products as parts of total sales.

When you want to present survey results showing the percentage of answers for each option.

When you want to quickly see which category has the largest or smallest share in your data.

Steps

Step 1: Select

- the cells containing your categories and their values

The data range is highlighted on the sheet

Step 2: Click

- Insert menu

A dropdown menu appears

Step 3: Select

- Chart

A chart editor panel opens on the right side

Step 4: In the Chart editor, click

- Setup tab, then Chart type dropdown

A list of chart types appears

Step 5: Scroll and click

- Pie chart option

The chart on the sheet changes to a pie chart showing your data

Step 6: Use

- Customize tab in the Chart editor

You can change colors, labels, and other style options of the pie chart

💡 Try adding slice labels to show percentages for better understanding

Before vs After

Before

A table with categories like Food, Rent, and Transport and their amounts in two columns

After

A pie chart appears showing slices sized by the amounts for Food, Rent, and Transport

Settings Reference

Chart type

📍 Chart editor > Setup tab > Chart type dropdown

Choose the style of chart to display your data

Default: Column chart

Slice label

📍 Chart editor > Customize tab > Pie chart > Slice label

Show labels on each slice to explain what it represents

Default: None

Pie slice colors

📍 Chart editor > Customize tab > Pie chart > Slice colors

Change the color of each slice to make the chart clearer or match your style

Default: Automatic colors

Common Mistakes

Selecting only the values without the category names

The pie chart will not show labels or categories, making it confusing

Always select both the category names and their corresponding values before inserting the chart

Using pie charts for too many categories

Too many slices make the chart hard to read and understand

Limit pie charts to 5-7 categories or group smaller ones into an 'Other' category

Summary

Pie charts show parts of a whole using slices sized by values.

Select both categories and values before inserting a pie chart.

Use the Chart editor to customize labels and colors for clarity.