Excel Sunburst Chart

Sunburst chart is a nice way of presenting relational datasets together in a compact form. This chart type is very strong in summarizing data but can be a little hard to read. Nevertheless, it looks pretty. That’s why I am going to show you how to make an Excel Sunburst Chart.

Sunburst chart is basically a stacked pie chart. It is created by stacking necessary amount of pie charts on top of each other. But there is a couple of tricks to do in order to make a decent one.

As an example, I am going to visualize project teams for a fictional software project. Here are the steps for creating an Excel Sunburst Chart for visualizing project teams:

This is our project team data. It is not very useful in this state. So we need to make some arrangements to make it suitable for a sunburst chart.

Here is the arranged version of same data. I made 3 groups from this data as Project manager, groups and team members. I assigned identical values to each team member to be able to plot them as visible data series. Team names gets the total value of their members. And project manager gets overall total value.

Now that our data is ready, let’s start building our chart:

  1. Insert a pie chart for each data groups. To insert pie chart, select cells; Project manager B1:C1, groups B3:C9 and team members B11:C44. Than insert a pie chart each time.
  2. Delete any legend, title, etc. on charts.
  3. Set background fill color as “no fill” and border color as “no color” for project manager and group charts.
  4. Resize charts arranging team members as largest and project manager as smallest.
  5. Place 3 charts on top of each other and align using lines between slices. We are doing this to get a feeling of how things are going to look like when finished. This is how it is supposed to look like at this stage:
  6. Now add data labels to each pie and select appropriate option from label options to display PM, group and member names. You may need to move charts to apply these changes. It is not a problem, we will re-stack them again anyway.
  7. Now that we have our labels displayed correctly, we need to reposition them to fit into their respective slices. For project manager and groups, just reposition labels by dragging them.
  8. For group members, you shouldn’t move labels. Make sure “Best Fit” is selected for label position. Select each label and adjust its alignment value from label options until it fits into related slice. Excel will position it inside the slide when it has a suitable alignment value.
  9. Re-stack pie charts when you are happy with labels.
  10. Now adjust colors of slices as you like. Coloring from lighter tones to darker tones and coloring related slices with same color is a good style. I colored each group with a separate color. Then I colored each member with a darker tone of same color as the group they belong to.
  11. Add a chart title if you like.

You can download example workbook for this Excel Sunburst Chart and inspect it yourself. You can also leave a comment below if you have any question regarding this tutorial or just to say hi 🙂

You may also like...

14 Responses

  1. David Craig says:

    Hi Melih: I like your style, and think I understood. But what I need in addition to what you’ve explained (and before I begin my own sunburst graph) is a dynamic element, whereby I can click on any segment of any layer and obtain information about whatever subject is presented, in your example, an employee, but in my case, definitions of elements of poetry, or rhetoric, for example. Can I do this on excel and if so, how?

    • melih says:

      Hi David,
      Only way I can think of is to use VBA for what you need.
      Since these charts are on top of eachother, you may not click on every slice (especially lower ones).
      So you can save the chart as apicture and place transparent boxes on each slice. Than code some complex macro to display info when a box is selected or when mouse hovers over it.
      I can’t think of an easy way, sorry.
      Best regards

  2. David Craig says:

    Thanks Melih. I’ll do as you suggest, although the code thing is a bit scary: I’ll have to learn. let me know if you have a ‘eureka’ moment about how to do the thing easily.

    dc

  3. SK says:

    Simply superb! Easy to follow. I did one within 5 minutes… Thanks a TON!

  4. SB says:

    Amazing!

  5. Sarah Mahone says:

    Hi Melih, great description about sunburst. Do you know a way, which makes it possible clicking a cell with a defined color and the suitable Segment dyes the same color ? I know that i have to create a Makro respectivley a VBA- Code, but i can’t name the segments in the “code-language”. At old charts the Name is “Points”.

  6. Anup Shah says:

    hi, i am unable to get Legend Name near to respective area in chart and also unable to format part of chart in different colour. I am not getting it easily. Plz guide me.

  7. Anup Shah says:

    Or can you share your you tube link if it is recorded how to it?

  8. melih says:

    Hi,
    Unfortunately I didn’t record the process of building this chart.
    I downloaded and confirmed that I can move the legend anywhere within the chart just by dragging it.
    Did you enabled editing from the yellow band over the screen or options?

  9. Jill Orhun says:

    Just wanted to say Thank You for posting. The other online examples require JSON files, or Excel 2016 (which I have no desire to download). This was for demonstration purposes, to show what could be done with the chart type, and worked beautifully. Thanks again!

  10. How to create sunburst chart in excel 2013

    • melih says:

      Hi. This is the way to create sunburst chart in excel 2013 and prior. You can also read about creating sunburst chart with excel 2016 in charts section.

  11. ferdy says:

    how to do the color grouping in the team member chart?

  1. March 18, 2016

    […] One (Code-Free) Way to Make It — by BeatExcel […]

Leave a Reply

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