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:

Related articles

Was this helpful?
How can we improve it?