Build 4.0.0.97 of xlsgen adds support for creating bubble cloud charts.


Bubble clouds in xlsgen

Bubble clouds sparks a new form of data analysis by arranging bubbles in ways that reveal links and associations. As such,

• bubbles are adjacent one another
• bubbles are partially chained together, i.e. it's not possible to have a bubble standing alone

The source code involved for creating such chart is concise and straight forward.

(C++ code)

xlsgen::IXlsEnginePtr engine( __uuidof(xlsgen::CoXlsEngine) );

xlsgen::IXlsWorkbookPtr wbk = engine->New( L"bubblecloud.pdf" );

xlsgen::IXlsWorksheetPtr wksht = wbk->AddWorksheet( L"Sheet1" );

xlsgen::IXlsVisualComponentPtr comp = wksht->NewVisualComponent(L"BubbleCloud.ARsTdesign.1",
	   1,1, 13,4, 0,0,0,0);

comp->ParameterByName[L"AddValues"]->Formula = L"={10;15;25;10;10;20;10;10;10;10;10;10;10;10;10;10;10;10;10;10;10;10}";

comp->ParameterByName[L"AddLabels"]->Formula = L"={\"2\";\"3\";\"cr4\";\"5\"}";

//comp->ParameterByName[L"SetBorderColors"]->Formula = L"={\"0x00FF00\"}";

comp->ParameterByName[L"SetFillColors"]->Formula = L"={\"0xFF8080\";\"0x80FF80\"}";

comp->ParameterByName[L"SetChartTitle"]->ValueAsLabel = L"bubble cloud";
comp->ParameterByName[L"SetFontName"]->ValueAsLabel   = L"Calibri";

wbk->Close();