How to Create a Sunburst Chart in Excel 2016?
In the example above, January is represented by blue color and the subgroups like week and region are represented by different divisions. Since this chart looks somewhat like an exploding sun, it is called a Sunburst Chart.Įach level of the hierarchy is represented by a circle or ring with the innermost ring representing the top of hierarchy data and the outermost ring represents the last hierarchy.Įach group is represented by a different color and the subgroups are represented by a division.
This is how an Excel Sunburst Chart looks like: But it can also show the relationships in the hierarchy. Just like a doughnut chart, Sunburst Chart is also used to display a part of the whole data and compare relative sizes. Let’s look into each of these points one-by-one!Įxcel Sunburst Chart is a built-in chart available in Excel 2016 that is used to display a hierarchical structure data in circular form.
0 kommentar(er)
