Advanced Visualization Tools: Generating Sunburst Charts

Advanced Visualization Tools: Generating Sunburst Charts

4th April, 2023

Data visualization is a crucial aspect of data analysis, allowing users to understand complex information and gain insights from large datasets quickly. Sunburst charts are an advanced and visually appealing tool for representing hierarchical data among various chart types. This article explores the concept of sunburst charts, explains their advantages, and provides a step-by-step guide to generating sunburst charts in Excel.

What Are Sunburst Charts?

Sunburst charts, also known as “radial treemaps” or “multi-level pie charts,” are a type of information visualization that displays hierarchical data structures in a circular format. These charts consist of concentric circles, each level representing a layer in the hierarchy. The innermost circle represents the “root” node, and each subsequent ring displays the “children” nodes of the previous level. The size of each segment is proportional to the value it represents, making it easy to compare and identify trends within the data. The following is an example of what a sunburst chart looks like:

Meirc training and consulting
An Application of Sunburst Charts

For example, let’s say that a Dubai-based supermarket is analyzing its sales of Vimto during 2022. Data generated from its ERP shows the following:

Meirc training and consulting

A typical way of visualizing this data is through a bar chart graph:

Meirc training and consulting

Naturally, more intricate ways exist to show this data (for example, by using vertical/horizontal stacked bars). While this is perfectly acceptable, a sunburst chart is more visually appealing and allows the audience to focus on specific areas of interest. A sunburst chart generated from the ERP data using Excel will look like this:

Meirc training and consulting

The above sunburst chart shows that Q2 is the most popular quarter for Vimto sales. Additionally, within Q2, April is the month for Vimto sales in Dubai (can you guess why). Let’s say your manager wants a more granular view of April and wants you to show the sales broken down by week. Going back to the ERP data, you find that the weekly data for April is 4095 for the first week, 2559 for the second week, 2047 for the third week, and 1,536 for the final week. By adding another layer of weekly data (for April only), the new sunburst chart will look like this:

Meirc training and consulting
The Advantages of Sunburst Charts

1. Intuitive Representation of Hierarchical Data: Sunburst charts offer an intuitive way to visualize hierarchical data, making it easy for users to understand relationships between different levels and categories.

2. Space Efficiency: Sunburst charts can represent large datasets with many categories compactly due to their circular layout. This makes them particularly suitable for visualizing data with multiple hierarchy levels, where traditional tree diagrams or bar charts may need to be more attractive.

3. Visual Appeal: Sunburst charts are visually engaging, allowing users to quickly grasp the structure of the data and identify patterns or trends. Using color and varying segment sizes can also help highlight specific data points and make the chart more accessible.

Generating Sunburst Charts in Excel: A Step-by-Step Guide

To create a sunburst chart in Excel, follow these steps:

1. Prepare the Data: Ensure your data is organized hierarchically, with each level represented as a separate column in your dataset. For example, the Vimto data needs to be rearranged into the following table:

Meirc training and consulting

2. Generate the Chart: Select the data you want to include in the sunburst chart. Click insert -> Insert Hierarchy Chart -> Sunburst

Meirc training and consulting

3. Configure Settings: Review the generated sunburst chart to ensure it accurately represents your data and provides the desired insights. Adjust the chart settings, such as changing colors or segment sizes, to improve clarity and readability.

Conclusion

Sunburst charts offer an advanced and visually appealing way to represent hierarchical data, making them an excellent choice for analyzing complex datasets with multiple levels of hierarchy. Following the steps outlined above, you can generate your sunburst chart and unlock valuable insights from your data. Like any visualization technique, the key to success lies in choosing the right tool, properly preparing your data, and refining the chart settings to communicate the information best.

About the Author
Dr. Mohammed Nayal

Deputy General Manager

Dr. Mohammed Nayal is a partner at Meirc Training & Consulting and Deputy General Manager for the company’s offices in Riyadh, Kingdom of Saudi Arabia. He holds a bachelor of science degree in systems and control engineering from Case Western Reserve University, a master of science in engineering economic systems from Stanford University, a master's in business administration from the University of California at Berkeley, and a doctorate in education from the University of Glasgow. In addition, Dr. Nayal is a certified business data analyst (CBDA) from the International Institute of Business Analysis (IIBA) and a certified training practitioner (CTP) from the Institute for Performance and Learning (I4PL).

View profile
The Comedy of KPIs: Al-Meqyass Family Saga
The Comedy of KPIs: Al-Meqyass Family Saga

Once upon a time, in a cozy suburban neighborhood, lived the Al-Meqyass…

Rabih Rizk
5th February, 2024
Read More
Public Sector Benchmarking: Driving Success Through Comparative Analysis and Innovation
Public Sector Benchmarking: Driving Success Through Comparative Analysis and Innovation

When I worked in the public sector, benchmarking was one of the crucial…

Dr. Mohammed Nayal
9th April, 2023
Read More
Cobras and the Law of Unintended Consequences
Cobras and the Law of Unintended Consequences

In my government strategy course, I present a public sector policy and…

Dr. Mohammed Nayal
1st August, 2022
Read More
The Changing Role of the Modern Business Analyst
The Changing Role of the Modern Business Analyst

Business Analysts (BAs) are in high demand by organizations in a wide…

Dr. Mohammed Nayal
20th April, 2020
Read More