Sunburst Chart in Excel
Like the Treemap chart, the Sunburst chart in excel is also a hierarchical chart. Instead of using the rectangle sizes to represent a value, it uses the size of pie pieces.
An advantage of the Sunburst chart over the Treemap chart is that it can represent more columns of labels. In the example for the Treemap chart, the first column (State) was used for the headings and the next column (Product) was used to represent the individual rectangles. If we wanted to break things down farther by going State, then Counties, and then Products within those counties, the Counties wouldn’t display in the Treemap chart but they would in a Sunburst chart.
Using the same data, we used for the Treemap chart and selecting the same options, let’s look at the result for the Sunburst chart in the image below.
Note: Please first see our tutorial about Treemap Chart to understand the data.
The Sunburst chart clearly shows that Indiana is our most profitable state. It’s easy to see from the chart that donuts are the most profitable item we sell in Indiana.
The pie slice for muffins in Michigan isn’t large enough to display the label and the value. If we remove the values the label for the muffins becomes visible. (See Image below)
The label for the muffins profit in Michigan is now visible. (See Image below). If you want to know the value associated with each slice just move your cursor over one of the items.
Creating a Sunburst Chart In Excel
This exercise covers selecting what data you wanted to represent in the Sunburst chart as well as selecting portions of the chart and applying styles.
1. Open workbook. Select the worksheet named Sunburst.
The image below shows the data.
2. Select the cell range A2:D15 and complete the following:
a. On the Ribbon’s Insert tab, click the dialog box launcher (See All Charts) for the Charts group.
b. Click the All Charts Tab.
c. Select Sunburst in the left pane. Click on the Ok button.
d. Enlarge the chart. (See Image below)
The Sunburst chart makes it easy to see that we sell the most items in the North region and that Indiana and Michigan are the biggest selling states.
3. Delete the Sunburst chart.
4. Select the cell range A2:C15, hold down the Ctrl key and select the cell range F2:F15. Let’s apply a cell style to the range so that we can easily identify which columns are being used for the chart.
5. On the Ribbon’s Home tab in the Styles group, click the Cell Styles button. Select Accent5. (See Image below)
Your spreadsheet should look like the image below.
6. On the Ribbon’s Insert tab, click the dialog box launcher (See All Charts) for the Charts group.
7. Click the All Charts Tab. Select Sunburst in the left pane. Click on the OK button.
8. Enlarge the chart. (See Image below)
We sell our product in New York City in a very upscale area at a higher price, which makes our New York pie slice much larger than it was for the number of dozens sold.
9. Change the chart to a more 3D- looking chart by selecting the chart and then, from the Ribbon’s Design tab, selecting the last chart choice from the Chart Styles group. (See Image below)
Just like with the Treemap chart you can select a group of pie slices by triple-clicking one of the slices or a legend item. You can then select an individual slice by clicking one of the slices in the selected group. (See Image below)