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.
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
|
|---|
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.
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
|
|---|
Customize a pie chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- 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.