Plots data proportional to the sum of items.
Data points shown as a percentage of the whole.
Unlike a pie chart, can display multiple categories.
Data Format
- x-axis: Categories (e.g. country)
- Chart handles multiple categories.
- Becomes visually complex as more categories are added.
- y-axis: Data Series (e.g. access to electricity (% of population))
- There can be multiple 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.
| Series 1 | Series 2 | Series 3 | |
|---|---|---|---|
| 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 chart, title and values adjust to reflect the data for each country or region.
- Each layer of the doughnut 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
- Pie or Pie of pie or Bar of pie