Pie charts

Use a pie chart when you want to compare parts of a single data series to the whole. For example, compare how many new customers were acquired through different marketing channels.

Learn how to add & edit a chart.

Pie chart

How to format your data

  
  • First column: Enter a label or category for each row.
  • Second column: Enter positive numeric data. You can also add a label name in the first row (optional).
  • Rows: Each row represents a slice of the pie.

Tip: If the value of a label is negative or 0, it won’t show up in the chart.

Examples

Monthly expenses
Expenses / month Percentage
Rent 40%
Food 15%
Utilities 7%
Car 9%
Phone 8%
Miscellaneous 15%
Savings 6%

 

Pie chart showing monthly expenses

Make a copy

Course feedback
Course feedback Percentage
Positive 48%
Negative 22%
Neutral 30%

 

Pie chart showing course feedback

Make a copy

Other types of pie charts

Doughnut chart

Use a doughnut chart when you want to compare contributions from parts of one or more data series to the whole.

Learn how to add & edit a chart.

Doughnut chart

How to format your data

 

  • First column: Enter a label or category for each row.
  • Second column: Enter positive numeric data. You can also add a label name in the first row (optional).
  • Rows: Each row represents a different section of the doughnut chart.

Tip: If the value of a label is negative or 0, it won’t show up in the chart.

Example

Sales by region

Sales by region Percentage
N America 40%
Asia 35%
Africa 10%
Australia 5%
Europe 10%

 

Doughnut chart showing sales by region

Make a copy

Customize a pie chart

  
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Choose an option:
    • Chart style: Change how the chart looks.
    • Pie chart: Add a slice label, doughnut hole, or change border color.
    • Chart & axis titles: Edit or format title text.
    • Pie slice: Change color of the pie slice, or pull out a slice from the center.
    • Legend: Change legend position and text.

Related articles

  
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
14143336593772610995
true
Search Help Center
true
true
true
true
true
35
false
false