# Create Sunburst Chart with Percentage in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

When dealing with lots of data, we often represent the data in a chart form in business meetings or to the viewers or readers. The most commonly used chart is the Sunburst Chart in Excel. However, the chart is actually meant to exhibit hierarchical data. Moreover, it represents different portions of data in different outer rings, which makes the data much more attractive and easy to understand for viewers and readers. So, it is essential to learn how to insert a sunburst chart in Excel. In this article, I will show you a step-by-step procedure to create a Sunburst Chart with percentage in Excel.

## What Is a Sunburst Chart?

First of all, letâ€™s start with a quick explanation of a sunburst chart, so you donâ€™t have to spend all day on this. In a nutshell, Sunburst Chart in Excel is the dominant way of publicizing data charts with many details. It can show every portion of the data by using rings. However, a different portion of the rings represents different data values in the chart. In addition, the chart is an efficient way of visualizing how the outer rings are divided into many parts. Typically, the circles in a sunburst chart reflect the various levels of the data points that have been split into their individual components.

## Sunburst Chart with Percentage in Excel: Step-by-Step Procedure to Create

However, you want to create a Sunburst Chart for employee percentages in Excel. Moreover, the task is quite simple and easy. If you follow the below steps correctly, you will learn how to create a sunburst chart in Excel. So, without further delay, letâ€™s see the process in detail.

### ðŸ“ŒStep 1: Select Dataset

For the purpose of demonstration, I have used the following sample dataset.

Here, I have some Departments and their respective Sub Division within an organization. I have collected the number of Employees as a percentage in order to create the Sunburst Chart.

Read More: How to Sort Excel Sunburst Chart Order

### ðŸ“ŒStep 2: Insert Sunburst Chart in Excel

• Firstly, select the dataset.
• Secondly, go to the Insert tab and move to Insert Hierarchy Chart.
• Thirdly, click on Sunburst Chart.

• Lastly, you will get the Sunburst Chart.

Read More: How to Insert Sunburst Chart in Excel

### ðŸ“ŒStep 3: Modification and Final Output

• Initially, you can add a Chart Title, Data Labels, and Legend from Chart Elements.

• Then, select Data Labels and press Ctrl + 1 to open the Format Data LabelsÂ pane.

• In turn, insert a check for both Category Name and ValueÂ options.

• Finally, you will get the Sunburst Chart as in the image below.

## How to Create Sunburst Chart with Values in Excel

Furthermore, you can create Sunburst Chart with values other than percentages. For example, I have chosen the following dataset. As the dataset contains more divisions, the chart will contain multiple levels.

Similarly, you can draw the Sunburst Chart from the Insert Hierarchy Chart option on the Insert tab.

## ðŸ’¬ Things to Remember

• Initially, to find the Sunburst Chart option, you have to select the dataset and go to the Insert Tab and select the RecommendedÂ Chart.
• Then, you can choose any type of data with sub-divisions in order to draw the chart.
• Next, data labeling and chart titles are essential in this chart. Otherwise, the chart can be misleading sometimes.
• After that, you can format the chart as you wish by going to the Chart DesignÂ option.
• Lastly, legends in the chart must be put in a way that helps to understand the data.

## Conclusion

These are all the steps you can follow to create an Excel sunburst chart percentage. Overall, in terms of working with time, we need this for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. Please let us know in the comments section below if you have any queries or recommendations.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF