reportpax.blogg.se

Use some predefined formattings to make the chart look like this. Go to insert -> Charts -> Insert Hierarchical charts -> Sunburst Charts.

Out of 300, only 200 passed Level 1 then out of 200 only 80 passed Level 2, and 30 passed Final. In the above image, we can see that we have 310 employees in the North region. The employees who pass the first level exam will able to attend the next exam. Each individual will attend 3 exams, Level 1, Level 2 and Final. So to explain the use of the Sunburst chart in excel, I have prepared this simple hierarchical data.Ī company is running a certification program for its employees. Each group is represented in a different color and subgroups are shown as a division of that part. Just like pie and donut chart, the Sunburst chart is used to visualize part of the whole data. Due to the appearance of an exploding sun, it got the name Sunburst chart. In this article, we will learn how and when to use Excel Sunburst Chart.Ī Sunburst chart looks like a donut chart, where the inner circle represents the highest hierarchy and outer circles represent lover level hierarchy. These two types are Treemap and Sunburst chart. In excel 2016, excel introduced two chart types to visualize hierarchical data.

When we have hierarchical data, it's hard to represent it visually.