Plots data proportional to the sum of items.
Data points shown as a percentage of the whole.
2D and 3D options are available.
Data Format
- x-axis: Categories (e.g. country)
- Chart handles multiple categories.
- Becomes visually complex as more categories are added.
- Pull out slices of a pie chart manually to emphasize the slices.
- y-axis: Data Series (e.g. access to electricity (% of population))
- There is only 1 data series.
- Data should total 100%. Series are presented as % of whole.
- Chart only handles positive values, not negative values.
- It is better if almost none of the data has a zero value.
- Multiple pie charts are required to show change over time.
| Series 1 | |
|---|---|
| Category 1 | # |
| Category 2 | # |
| Category 3 | # |
Try it now!
- Select a country/region from the dropdown list to view access to electricity (% of population) data.
- The charts, title and values adjust to reflect the data for each country or region.
- Each of the 3 charts represents a different year.
- This chart was built using data validation lists, named ranges, conditional statements and the INDEX and MATCH functions.
Related Pie and Doughnut Charts