93

Sunbrust Chart in Excel

Visualizing your Excel data using Charts that display hierarchical flows can help you convince your target audience and share your data quickly. Therefore, Microsoft Excel added Sunburst Chart in Excel 2016 because a Sunburst Diagram is an easy-to-interpret and provides an amazingly insightful visualization. It helps our brains to determinate high-to-low or low-to-high order information instantly.

This tutorial will discover the newly introduced chart in Excel 2016 – Sunburst Chart, a step-by-step method to create this chart, format it, and its advantages and disadvantages.

What is an Excel Sunburst Chart?

“Sunburst Chart, also commonly known as the Sunburst Partition Chart, Ring Chart, or Radial Treemap, helps display hierarchy in your raw data through a series of concentric rings. Each circle in the Sunburst Chart represents a defined level in the hierarchy of data points segmented proportionally to define its constituent components.”

Excel Sunburst Chart is an inbuilt chart introduced with Excel 2016 versions that represent the hierarchical structure of your data in circular form. Unlike a doughnut chart, a Sunburst Chart’s prime motive is to display a subpart of the entire dataset and compare the relative categories. The only difference between these charts is that Sunburst Chart can also show the relationships between different hierarchy levels.

This is how the Sunburst Chart looks like in Excel:

In the example above, Asia is defined by blue color, and different divisions represent the subgroups like Session1, Seesion2 and Final.

One might wonder why Microsoft has named an Excel chart as Sunburst. Since this chart looks relatively like an exploding sun, therefore it is known as the Sunburst Chart, where a circle or ring describes each hierarchy level of this chart. The innermost circle denotes the top of the hierarchy level of your dataset, and the outermost circle denotes the last hierarchy of the data.

A different color represents each group, and a division represents the subgroups for a Sunburst chart. Although Excel automatically selects a different color for different categories of the chart. But if you are not satisfied with the colors or the layout, you can change it by using the layout of the data labels to differentiate between different categories.

However, a sunburst chart with multiple categories indicates how the outer circles relate to the inner circles. The sunburst chart is an apt choice when the user wants to show how one ring is split into its contributing parts. In contrast, a Treemap chart (another type of hierarchical chart) is excellent for comparing relative sizes.

Advantages and Disadvantages

The advantages of using Sunburst Chart in an Excel worksheet are as follows:

1. This chart shows the relationships of data in the hierarchy.
2. This chart is used to display the breakdown of different categories.

The disadvantages of using a Sunburst Chart in an Excel worksheet are as follows:

1. To implement this chart, firstly, the user needs to align data series in a special format. Sometimes it can be a headache.
2. The Sunburst chart can only be used to display the data from a percentage perspective, and it can’t be used to show data with magnitude representation.
3. It’s difficult to understand the data labels on this chart.
4. A lot of Sunburst chart area is unused. Use that area to explain the chart.

Sunbrust Chart: Tips & Tricks

There are a few points the Excel user should keep in mind when they are working with Sunburst Charts in their Excel worksheet:

1. A Sunburst chart looks similar to a donut chart, where the innermost ring denotes the highest hierarchy and outermost rings signifies lower hierarchy level. Because this chart looks relatively like an exploding sun, therefore it is known as the Sunburst Chart. Sometimes it is also known as ‘Starburst chart‘.
2. There should be two levels or more levels of hierarchyto create Sunburst charts.
3. The data should not hold the subtotal valuesas this will misrepresent your chart. Excel only wants data at the lowest level of the hierarchy to create Sunburst Charts.
4. It is advised not to sort the data based only on the lowest hierarchy level.
   First, sort them on the basis of the first hierarchy level and then the last level of hierarchy.
5. The Sunburst Chart was initially introduced to accommodate subunits of the Pie Chart’s primary segments.

Steps to create a Sunburst Chart

A company is running an IQ test program for its workers in different parts of the country. Each worker has to attend 3 exams, Session1, Session 2 and Final. Only the candidates who will clear the first exam are eligible to attend the next exam.

In the above data, we can see that the company has 350 workers in the Asia region. Out of 350, only 200 cleared Session 1 then out of 200 only 110 passed Session 2, and 40 cleared the Final exam. The same concept flows for the candidates who gave exam in Europe and Africa region.

Below given are the step-by-step procedure on how to create a Sunburst Chart in Excel worksheet:

STEP 1: Select your data table and go to Insert > Hierarchy Charts.

NOTE: You can also use the Recommended Charts -> All Charts option to create a sunburst chart.

STEP 2: From the list of charts, select the Sunburst Chart option.

STEP 3: As a result, Microsoft Excel will create a Sunburst chart in your worksheet. The circles or rings represent each hierarchy level of the given dataset. The innermost circle denotes the top of the hierarchy level of your dataset, and the outermost circle denotes the last hierarchy of the data. A different color represents each group, and a division represents the subgroups for a Sunburst chart.

STEP 4: The best way to start customizing your charts is by providing an appropriate chart title to it. Whenever you create a new chart, Microsoft aligns the name ‘Chart Title’ to it by default. All you have to do is click on the text box, it will change to dotted lines and thereafter type a new name.

STEP 4: Although Excel automatically selects a different color for parent categories of the sunburst chart. But if you are not satisfied with the colors or the layout, you can change it by using the layout of the data labels to differentiate between different categories.

• Right-click one of the rectangles on the chart > click on the Format Data Series option.
  
• Under Series Options > click on Label Options, select any of the display option you want.
  

STEP 4: You can further customize the look and feel of your Sunburst Chart, by going to Chart Tools > Design / Format.

Note: You can also use the Chart Design and Format tabs to customize your Sunburst chart’s appearance and look and feel. Sometimes both these tabs are not activated. Click anywhere in the Sunburst chart to activate those tabs.

Since you know how to create your Sunburst chart from the given set of hierarchical data, you can now quickly present to your management the data series in the most efficient way.

Interpretation of Sunburst Chart

So, now we have learned the steps to create a Sunburst chart. But how do we interpret it? The sunburst chart is likely similar to a pie/donut chart. The bigger part-owns most of the share of the total data. From the above example, you can conclude that Africa contains most of the total. We can notice how many workers from the African region have passed session 1 and then how many workers have clear level 2 and then final.

When to use Sunburst Chart over Treemap

1. The Sunburst chart is a good choice when the user wants to represent a multi-level hierarchy. In contrast, the Treemap is an excelled choise if the user only has 2 to 3 levels of the hierarchy.
2. Sunburst is easier to understand when compared to the treemap chart. It is visually more attractive and self-explanatory.

---