xlsgen > overview > Bubble clouds

Introducing bubble clouds

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

Such characteristics are a reflection of the nature of real objects and that is why the bubble cloud display is so meaningful.

Creating bubble clouds

Bubble clouds is one of the pre-installed visual components from the open xlsgen visual component architecture.

Bubble clouds support a number of properties :

• set a list of values whose values are used in the bubble radiuses
• set a list of labels which are displayed in bubbles. This can be anything, values, names. Optional.
• set a list of border colors, so that bubbles can have individually different border colors. Optional.
• set a list of fill colors
• set a font name, which is used to rendering any text
• set a chart title

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();