Sunburst chart

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.

  1. Select your data
  2. Go in the tab Insert
  3. In the section Chart, select the hierarchy charts
  4. Select the Sunburst chart

Understand a sunburst chart

Just after selecting the sunburst chart, the following chart appears in your worksheet.

Sunburst chart
Sunburst chart

The chart look confusing but it’s not.

List of sub-folders (first level)

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

Selection of a first 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.

Selection of a second level of a sunburst chart

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.

Tree map chart
Tree map chart

Leave a Reply

Your email address will not be published.