Plots data within a hierarchical structure.
Categories are displayed by color and proximity and are sized proportionally based on values.
Easily show lots of data which would be difficult with other chart types.
Data Format
- x-axis: Categories (e.g. Gender)
- Data must have a hierarchical order, e.g. Gender, Country.
- Each category is represented by one square in the chart.
- Compare relative sizes of categories, similar to a Sunburst chart.
- y-axis: Data Series (e.g. Labor Participation rate)
- Sort by category
- Chart handles positive and blank values, but not negative values.
| Category 1 | Category 2 | Series |
|---|---|---|
| Hierarchy 1 | Hierarchy 2 | # |
| Hierarchy 1 | Hierarchy 2 | # |
Try it now!
- Select a region from the dropdown list to view labor force participation (% males and females) by country.
- The chart, title and values adjust to reflect the data for each region.
- This chart was built using data validation lists, named ranges, conditional statements and the COUNTIF, COUNTIFS, IF, IFERROR, MATCH and OFFSET functions.
Related Hierarchy Charts