With a Sunburst chart you can present your hierarchy data in a very comprehensive way.
In this article, we will see how to visualise the contain of a folder and sub-folder but a sunburst chart could be also the best chart to see the hierarchy in a company (for the number of employees, for the salary amount, …)
Export files from folder
In this article, I have explained how you can export all your files’ name and their size with Power Query.
Now, let’s see how to represent this data in a chart.
Insert a Sunburst chart
Create a sunburst with Excel 2013 or 2016 is very easy.
- Select your data
- Go in the tab Insert
- In the section Chart, select the hierarchy charts
- Select the Sunburst chart
Understand a sunburst chart
Just after selecting the sunburst chart, the following chart appears in your worksheet.
The chart look confusing but it’s not.
In fact the first ring close to the center, represent the first level of folders sorted by size.
When you look carefully each sector of the first ring, you can see that the first one, Power Pivot, is the biggest which means that it’s the one who takes more spaces on the computer.
Then, the further you go from the center, the more you see the size of directories by hierarchy level
As you can see on the previous picture, when you click on a sector of the first ring, automatically, you select all the other levels. And it’s the same if you select a sub-level.
Size of the sectors
With a sunburst chart, it’s easy to visualise the hierarchy of your data. Each area represents the size of a level. But nowhere in the options of this chart, you will be able to display the size in a label.
If you want to do have a better visualisation of the size, you should use a tree map chart.