It’s a surefire way to understand data when numbers are just a bit too noisy. You can change the colors and label the pie and pie slices however you want. This means that the whole pie is 100% and each slice is a division of the total 100%. A pie graph is like a pizza pie, it’s a circle sliced up into sections according to the data input. You can download example workbook for this Excel Sunburst Chart and inspect it yourself.Analyzing data? Creating a pie graph is an easy way to see your information broken down by variable and in proportions. Then I colored each member with a darker tone of same color as the group they belong to. I colored each group with a separate color. Coloring from lighter tones to darker tones and coloring related slices with same color is a good style.
Now adjust colors of slices as you like. Re-stack pie charts when you are happy with labels. Excel will position it inside the slide when it has a suitable alignment value. Select each label and adjust its alignment value from label options until it fits into related slice. Make sure “Best Fit” is selected for label position. For group members, you shouldn’t move labels. For project manager and groups, just reposition labels by dragging them. Now that we have our labels displayed correctly, we need to reposition them to fit into their respective slices. It is not a problem, we will re-stack them again anyway. You may need to move charts to apply these changes. Now add data labels to each pie and select appropriate option from label options to display PM, group and member names. This is how it is supposed to look like at this stage: We are doing this to get a feeling of how things are going to look like when finished. Place 3 charts on top of each other and align using lines between slices. Resize charts arranging team members as largest and project manager as smallest. Set background fill color as “no fill” and border color as “no color” for project manager and group charts. To insert pie chart, select cells Project manager B1:C1, groups B3:C9 and team members B11:C44. Insert a pie chart for each data groups. Now that our data is ready, let’s start building our chart: And project manager gets overall total value. Team names gets the total value of their members. I assigned identical values to each team member to be able to plot them as visible data series. I made 3 groups from this data as Project manager, groups and team members. Here is the arranged version of same data. So we need to make some arrangements to make it suitable for a sunburst chart. Here are the steps for creating an Excel Sunburst Chart for visualizing project teams: But there is a couple of tricks to do in order to make a decent one.Īs an example, I am going to visualize project teams for a fictional software project. 
It is created by stacking necessary amount of pie charts on top of each other. Sunburst chart is basically a stacked pie chart.
0 kommentar(er)
