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. This approach obviously would require some experimentation to get exactly the right look, but it is a great approach if the data that underlies the table will change periodically.Sunburst chart is basically a stacked pie chart. You can then overlay the five charts to get the desired effect. You format each chart, individually, so that each of them leaves only a single slice visible. Thus, if you have five slices in your pie chart, you would make five charts (one for each slice) that start out exactly the same. Each chart is based on the entire original data table, but you set the colors for the group to be represented by the particular chart, and then make the other groups "invisible" by turning off their borders and colors. The only approach that we could make work is to make a chart for every grouping in your original data. There is no way to group individual slices of the pie prior to exploding, nor does Excel provide a way to push selected slices together. Gloria was looking for a way to have different slices grouped together in the view. When you pick an exploded pie chart as your chart type, all the slices of the pie are "pushed back," away from the center of the pie. Gloria asked if there was a way, in a 3-D pie chart, to "explode" groups of slices, instead of individual slices.
0 kommentar(er)
