Build 4.0.0.44 of xlsgen introduces support for funnel charts.


Funnel charts in xlsgen

Funnel charts display values as progressively decreasing proportions. A typical example of a funnel chart starts with the sales leads on top, then down to the qualified leads, the hot leads and the closed deals. A business is bound to lose some number of potential deals at each step in the sales process and this is represented by the narrowing sections as you move from the top section (the widest) to the bottom section (the narrowest.)

Funnel charts were introduced by Microsoft earlier this year in Excel 2016. More accurately, funnel charts are available to Excel users who purchased Excel 2016 on a subscription basis (Office 365) as well as Excel online and Excel and Android and iOS.

xlsgen can read and create such charts regardless of the Excel version you are using. Moreover, xlsgen actually renders funnel charts anywhere applicable, in print, preview, PDF/XPS/HTML scenarios.

It's very easy to create a funnel chart :

xlsgen::IXlsChartPtr chart = worksheet->NewChart(xlsgen::charttype_funnel,
                                                     10, //row1
                                                     2, //col1 
                                                     25, //row2
                                                     10 //col2
                                                     );

chart->MainTitle->Label = L"Funnel chart";

xlsgen::IXlsChartDynamicDataSourceSeriesPtr s1 = chart->DynamicDataSource->AddSerie();
s1->SeriesValuesFormula = L"={2;13;5;4;10;1;0;2}";
s1->DataLabelsFormula   = L"={\"cat1\";\"cat2\";\"cat3\";\"cat4\";\"cat5\";\"cat6\";\"cat7\";\"cat8\"}";