15-09-2021

Sunburst Chart Excel 2016

Excel 2016 has some new chart types. One of them is sunburst. Strangely, this chart is not accessible by macro.
Scenario
- I have a excel template with placeholder for my data and a sunburst chart
- In my application, data is populated in the sheet, resulting is chart getting filled up
- However, chart is not accessible by referencing xlws.chart. Debug window shows that it has nothing
I tried

No matter whatever I tried, the chart object had nothing. There when I tried below statement

It gave an error that method 'SetSourceData of object' _chart failed
Runtime error '-214717851 (800010105)'

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.

How To Rotate Sunburst Chart In Excel 2016

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.

Sunburst Chart In Excel 2016

Graph Excel

I remarked that all new charts came from Office 2016 version are not visible when the Excel file is created on Excel for Office 365 (16.0.4). I tested to only 'save as' a file created on my server with waterfall or sunburst chart from my server, and I have same result: my chart cannot be displayed on my server. 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. In Excel 2016, Microsoft presented two hierarchical chart types. Sunburst chart and Treemap chart. In this article, we will learn when and how to use Excel Treemap chart. A treemap chart consists rectangles of different size and colors.