Microsoft finally included sunburst chart into Excel and made it easy to make a sunburst chart with Excel 2016. How to create a sunburst chart with Excel versions prior to 2016 is explained in this post. I am going to use the same dataset that I used for the previous sunburst chart tutorial. Dec 28, 2020 The sunburst chart is available for Excel 2016. It is very useful to visualize the hierarchy between your data.
Sunburst Chart Excel 2016 Pdf
Only works on data arranged in categories with sub-categories.
Sunburst Chart Excel 2016 Download
Excel’s Sunburst Chart is such a visually effective way to demonstrate data that is organised in categories with sub-categories. The example below reflects sales figures for an ice-cream parlour in Plettenberg Bay (a popular seaside holiday town). Sales data is typically recorded on a monthly basis. Additionally, the sales data is divided into four, financial quarters.
Sunburst Chart Excel 2016 Template
The 4th Quarter comprises the summer months and the end-of-year school holidays, and the chart below makes it abundantly clear that this is when the business does most of (more than 50%) its business.