Plots data proportional to the sum of items.
Data points shown as a percentage of the whole.
Smaller values displayed in a secondary pie.
Data Format
- x-axis: Categories (e.g. countries)
- Chart handles multiple categories.
- Becomes visually complex as more categories are added.
- Pull out slices of a pie chart manually to emphasize the slices.
- Smaller values shown in a pie of pie to make them easier to distinguish.
- y-axis: Data Series (e.g. military expenditure)
- 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 region from the dropdown list the top 10 countries for military expenditure.
- The charts, title and values adjust to reflect the data for each country or region.
- The larger chart shows the top 5 countries. The split segment shows a pie of pie with the remaining countries.
- This chart was built using data validation lists, named ranges, conditional statements and the IF, IFERROR, MATCH, OFFSET, SUM and SUMIF functions.
Related Pie and Doughnut Charts