Microsoft Excel Charts banner image.

Only works on data arranged in categories with sub-categories.

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.

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.

Excel Sunburst Chart with data
Excel Sunburst Chart with data

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.