Sunburst Chart With Excel 2016
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:
Select this hole data set and insert a Sunburst Chart as shown below:
Your chart will automatically created:
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.
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.