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: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.

 

 

You may also like...

4 Responses

  1. Nick says:

    Thanks for this great explanation. How can you render a pivot table data set though? I’ve found I have to a) create a data set then, b) copy and paste values into adjacent cells and then, c) create the sunburst chart. To this each week though isn’t great. It is a tad manual…

    I am also thinking of creating an INDEX MATCH argument. Maybe this could work?

  2. melih says:

    Hi,

    Excel doesn’t allow us to use Sunburst Chart (along with scatter, bubble or stock charts) with pivot table. Therefore your way of dealing with this seems to be the only way.
    You can try to read data into a table with formulas to decrease manual work.
    You have several options for formulas, like vlookup+sumifs or offset. Index+match should also work.

    Best Regards

  3. umut says:

    Hi Melih,

    thnaks for info, but it is not easy, maybe i write a macro 🙂

  4. Preeti says:

    hi,
    it doesn’t show all the labels on the chart… how to fix it??

Leave a Reply

Your email address will not be published. Required fields are marked *