Type
Sunburst Chart / Multi-level Pie Chart
Function
Hierarchy, Composition, Part of Whole
How to use and edit this chart template
To edit this chart template, execute following steps.
- Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
- Enter main categories in column A. These categories form the node 1 / level 1 of the sunburst chart.
- Enter first level sub-categories in column B. These categories form the node 2 / level 2 of the sunburst chart.
- Enter second level sub-categories within the sub-categories specified in step 3 above in column C. These categories form the node 3 / level 3 of the sunburst chart.
- Enter data values for each of the sub-sub-category in column D. These data values determine the size of each sub-sub-category / segment. Larger the data value, bigger is the segment. The data values can be numeric, percentages or currency values.
- You can add your data manually or copy data from Excel or any other data source.
- Close the Excel sheet.
- Restyle and customize to change text, fonts, colors etc. to match your brand guidelines, corporate identity / corporate design and preferences.
- Modify the template for your own use case, industry or job function. Easily change, add or delete categories and corresponding data series, if you have more/less data than provided in this ready-to-use template.
- File format: PPTX. Compatible with Office 365, PowerPoint 2016 and above.
Use case example: Brand market share
The sunburst chart in above example shows market share of 5 brands, dealing in computers and phones, in three countries – USA, India and Canada. This chart template uses 3 nodes.
The first node represents countries. The second node represents categories (phones and computers). The third node represents brands. The third node also shows the percentage market share of each brand. The arc length of slices in each node is proportional to the data value it represents.
Also see sunburst chart template for analysis of revenue from top 5 customers
