Build 4.0.0.8 of xlsgen adds support for creating Excel 2016 box & whisker 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.


Box & whisker charts in xlsgen

Box and whisker charts display the dispersion of values in one or more series. Boxes represent main quartiles, lines represent the dispersion of values outside the main quartiles (the larger the lines, the most varying the values), X signs show the mean and dots represent outliers (i.e. values outside the most meaningful quartiles). Box and whisker charts can be put to great use in statistical and financial charts, notably, in addition or in contrast of histogram charts.

IXlsChart chart = worksheet.NewChart(enumChartType.charttype_boxwhisker,
					     10, //row1
					     2, //col1 
					     25, //row2
					     10 //col2
					     );

IXlsChartDynamicDataSourceSeries s1 = chart.DynamicDataSource.AddSerie();
s1.SeriesValuesFormula = "=Sheet1!$B$2:$B$16";
s1.DataLabelsFormula   = "=Sheet1!$A$2:$A$16";

IXlsChartDynamicDataSourceSeries s2 = chart.DynamicDataSource.AddSerie();
s2.SeriesValuesFormula = "=Sheet1!$C$2:$C$16";
s2.DataLabelsFormula   = "=Sheet1!$A$2:$A$16";

IXlsChartDynamicDataSourceSeries s3 = chart.DynamicDataSource.AddSerie();
s3.SeriesValuesFormula = "=Sheet1!$D$2:$D$16";
s3.DataLabelsFormula   = "=Sheet1!$A$2:$A$16";

chart.MainTitle.Label = "Box and Whisker chart type";