Site icon TestingDocs.com

How to create a Sunburst chart in Excel

Overview

In this tutorial, we will go through the steps involved to create a Sunburst chart in Excel. The sunburst chart is also known as a Ring chart. It is a hierarchy chart that is used to compare parts to whole types of data.

Sample data

We would use a sample Sales report for two quarters and generate the Sunburst chart for the sales report.

Steps to create

Select the data for the chart.

Insert Sunburst chart

Click Insert >> Recommended Charts >> All Charts >> Sunburst.

or

Click Insert > Insert Hierarchy Chart > Sunburst.

 

 

Exit mobile version