Build 3.0.0.71 of xlsgen introduces a new chart type : outliers.


Chart outliers in xlsgen

Chart outliers is a unique chart in xlsgen for showing data outside a predefined or dynamically calculated range, called the normal range. Such data outside the normal range are called outliers.



xlsgen::IXlsChartPtr chart = wksht->NewChart(xlsgen::charttype_outliers, 4, 3, 18, 8);
chart->DataSource->Range = L"R1C2:R3C6";
chart->CustomProperties->OutlierPercent = 40; // show 40% of outliers


Alternatively, the range can be predefined :

xlsgen::IXlsChartPtr chart = wksht->NewChart(xlsgen::charttype_outliers, 4, 3, 18, 8);
chart->DataSource->Range = L"R1C2:R3C6";
chart->CustomProperties->OutlierAbsoluteMaximum = 1.2;
chart->CustomProperties->OutlierAbsoluteMinimum = 0.6;