Pie charts

You can use a pie chart to show the relationship of parts to the whole. Data in columns or rows on a sheet can be transformed into a pie chart.

Pie charts show the sum of the items in one data series and the proportion of each item to the sum of items. In a pie chart, the data are displayed as a percentage of the whole pie.

pie chart

You can use a pie chart in the following cases:
  • You have only one data series to display.
  • The categories represent parts of the whole pie.
  • None of the values are negative.
  • Almost none of the values are zero values.