Build 4.0.0.10 of xlsgen adds support for creating Excel 2016 sunburst charts. As the name implies, these are Excel 2016 charts in that only Excel 2016 will render those charts, no older Excel version will do. xlsgen reads, creates and writes such charts.


Sunburst charts in xlsgen

Sunburst chart is another chart type for showing data which is hierarchical in nature. It is made of multiple rings which reflects the hierarchy, and as such is different from a doughnut chart or exploded pie chart, which xlsgen also supports. A segment of the inner circle bears a hierarchical relationship to those segments of the outer circle which lie within the angular sweep of the parent segment. The multiple rings are created from a single series of values associated to multiple columns of categories, reflecting the hierarchies, for instance a quarter/month/week hierarchy as in the example above.

And here is how you do it (in VB) :

Dim chart As IXlsChart 
Set chart = worksheet.NewChart(enumChartType.charttype_sunburst, _
					     10, _ 'row1
					     2,  _ 'col1 
					     25, _ 'row2
					     10  _ 'col2
					     )

Dim s1 As IXlsChartDynamicDataSourceSeries
Set s1 = chart.DynamicDataSource.AddSerie
s1.SeriesValuesFormula = "=Sheet1!$D$2:$D$16"
s1.DataLabelsFormula   = "=Sheet1!$A$2:$C$16"