Build 4.0.0.12 of xlsgen adds support for creating Excel 2016 pareto 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.


Pareto charts in xlsgen

Pareto charts is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. The purpose of the Pareto chart is to highlight the most important among a (typically large) set of factors.

Here is how to create a Pareto chart (using Java) :

XlsChart chart = worksheet.NewChart(xlsgen.charttype_pareto,
					     10, //row1
					     2, //col1 
					     25, //row2
					     10 //col2
					     );

XlsChartDynamicDataSourceSeries s1 = chart.getDynamicDataSource().AddSerie();
s1.putSeriesValuesFormula("=Sheet1!$B$1:$B$5");
s1.putDataLabelsFormula("=Sheet1!$A$1:$A$5");