Plots data within a hierarchical structure.
Segments are sized proportionally based on values.
Effective at showing how a category is broken into its contributing pieces.
Data Format
- x-axis: Categories (e.g. time)
- Data must have a hierarchical order, e.g. Year, Quarter, Month.
- Each level of the hierarchy is represented by one ring with the innermost ring as the top of the hierarchy.
- A sunburst chart without any hierarchical data (one level of category) looks similar to a Doughnut chart
- Compare relative sizes of categories, similar to a Treemap chart.
- y-axis: Data Series (e.g. Export and Import trade values in $US million)
- Sort by category
- Chart handles positive and blank values, but not negative values.
| Category 1 | Category 2 | Category 3 | Series |
|---|---|---|---|
| Hierarchy 1 | Hierarchy 2 | Hierarchy 3 | # |
| Hierarchy 1 | Hierarchy 2 | Hierarchy 3 | # |
Try it now!
- Select a year from the dropdown list to view U.S. export and import data by year and quarter.
- The chart, title and values adjust to reflect the data for each year.
- The quarterly values are shown in the cells to the left and right of the chart.
- This chart was built using data validation lists, named ranges, conditional statements and the IF, INDEX and MATCH functions.
Related Hierarchy Charts