# How to Create a Sunburst Chart in Excel (With Detailed Steps)

## Introduction to Sunburst Charts

A Sunburst chart is a powerful visualization tool for displaying hierarchical data in a circular format. It resembles the sunâ€™s rays or the rings of a tree. Each ring of the chart represents a level in the hierarchy. Hereâ€™s what you need to know about Sunburst Charts:

• Purpose: Sunburst charts help visualize the proportionate distribution of data categories using color and size.
• Hierarchy: The innermost circle represents the main categories, while outer segments represent subcategories or levels within those main categories.
• Ordering: Data in a Sunburst chart is sorted from largest to smallest amount clockwise by default.

### Steps:

• Data Preparation:
• Ensure your data is organized hierarchically.
• For example, consider term final results of students, where each student has scores distributed across different terms.
• Calculate Total Students:
• To find the total number of students combining all term final results, use the formula:
`=SUM(G6:G8)`

• Remark on Performance:
• Insert the following formula to remark on student performance:
`=IF(G5>250,"Excellent",IF(C5=250,"Good",IF(C5<250,"Average")))`
• Press Enter.

• Insert the Sunburst Chart:
• Click on the SunburstÂ option under the InsertÂ tab (available in Excel 2016 and later versions).
• The Sunburst chart will appear in your worksheet.

• Customize Appearance:
• Go to the Chart DesignÂ tab and select your preferred design from the ribbon.

• We created a Sunburst Chart quite easily.

Read More: How to Insert Sunburst Chart in Excel

## Important Notes:

• Selection:
• Keep a cell selected inside the table while generating the Sunburst Chart.
• If you donâ€™t select the generated chart, the Chart DesignÂ tab wonâ€™t appear for design changes.
• Manual Data Update:
• If chart data doesnâ€™t update automatically with underlying data changes, right-click on the chart and select Edit DataÂ to redirect it manually.

1. Difference Between Sunburst and Treemap Charts:
• Both explain hierarchical patterns.
• Sunburst: Central circle with concentric rings.
• Treemap: Divides area into nested rectangles.
2. Use of Sunburst Diagram in Excel:
• Display hierarchical data relationships (e.g., population across cities, states, countries, continents).
• Useful for analyzing industry firm details.
3. Components of a Sunburst Chart:
• Inner circle (main categories) surrounded by outer rings (subcategories).

## Sunburst Chart in Excel: Knowledge Hub

<< Go Back to Excel ChartsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Tags:

Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF