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 the whole data set and insert a Sunburst Chart as shown below:

Sunburst Chart With Excel 2016 2

Your chart will be created automatically:

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

5 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??

  5. Pam Shoberg says:

    I want to use a Starburst chart as a way to display descendants from a common ancestor, with the common ancestor being in the center of the chart. I want the segments of the chart to be in the same sequence as I’ve entered them in my spreadsheet, not sorted by size. Is there an option to do this in Excel, or would you recommend another charting package? Thanks.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.