Blog Archive

Excel: Creating Sunburst Chart

 Microsoft finally included sunburst chart into Excel and made it easy to make a sunburst chart with Excel 2016. How to create a sunburst chart with Excel versions prior to 2016 is explained in this post.

I am going to use the same dataset that I used for the previous sunburst chart tutorial. We are going to visualize an ERP project team in this example. Here is the data we are going to work with:Sunburst Chart With Excel 2016 1
Select this hole data set and insert a Sunburst Chart as shown below:
Sunburst Chart With Excel 2016 2
Your chart will automatically created:
Sunburst Chart With Excel 2016 3
At this step, all you need to do is to change chart title and add a textbox to the center of the chart that holds project manager.
Sunburst Chart With Excel 2016 4
It is this easy to create a sunburst chart with Excel 2016. As long as you have an arranged dataset, you can do it with one click.
Source: BeatExcel