Create Sunburst Chart in Excel using Doughnut
The chart is created using Doughnut chart and each level is added as a series in it. The macro is used to prepare the chart data and add the series to charts dynamically as per the selected level. You can add further levels in the chart all you need to do is create the sheets like level 1, level 2 ,etc which are already existing in the template and make the changes in the code as per the requirement
With Color Formatting
Download Link
Steps to create
- Download the template link
- Make sure data is sorted
- Click on prepare data button
- Choose the level from the drop -down
- Select the chart to activate the mouse over effect
The chart is created using Doughnut chart and each level is added as a series in it. The macro is used to prepare the chart data and add the series to charts dynamically as per the selected level. You can add further levels in the chart all you need to do is create the sheets like level 1, level 2 ,etc which are already existing in the template and make the changes in the code as per the requirement
With Color Formatting
Download Link
Thank you for sharing. I want to advise you to the website templates. Here is a link http://charts.poweredtemplate.com/powerpoint-diagrams-charts/index.html. There you'll find some you like. I hope someone can help.
ReplyDelete