The sunburst chart is a built-in chart type in Excel 2016+. A sunburst chart is used to display hierarchical data in a circular format where each level of the hierarchy is represented as a ring. Top level categories make up the inner ring, and sub-categories are plotted as outer rings. Segments in each ring are sized proportionally using a value series. Like a treemap chart, the sunburst chart can be used to compare relative sizes.
Pros
- Quick visualization of hierarchical data
- At-a-glance breakdown of data in categories
Cons
- Data must be sorted by category
- Limited options for controlling format and presentation
A Combo Chart is a hybrid of two more chart types, for example, a column chart plus a line chart.
Pros
- Able to display multiple chart types in a single chart
- Able to plot values with completely different sales
- Can show how one factor is influenced by another
Cons
- Inherently more complex than other chart types
- Can become complicated quickly
