Most reports comprise one or more data tables, and as such charting has typically been via large charts above or below the numbers, or on separate sheets. Visualisation luminaries such as Edward Tufte and Stephen Few are advocates of larger numbers of smaller, more tightly focused charts to convey information.

XLCubed’s in-cell charting, implemented through fonts, and controlled via formulae lend themselves perfectly to this approach, and can readily be used to extend existing report packs.

In this case an original data-only Excel table has been enhanced to graphically depict trend and target on a row basis. Significantly more data is being conveyed, and it can be assimilated much more quickly. The revenue plummet in early 05, and strongly over target YTD profit are apparent.

Each Chart resides within an Excel cell, and as they are implemented through fonts, the user has a great degree of control over their sizing, alignment and positioning. The in-cell charting can be picked up quickly by existing excel users, and used to extend existing reports or as part of custom built dashboards. The in-cell charts provided include Sparklines, Bullet Graphs, Columns, Bars, KPI icons, Horizon Charts, and Box Plots. Each chart type contains rich formatting options, accessible through the intuitive user interface.

XLCubed’s in-cell charting can turn Excel into a truly world class dashboard development environment, with a web deployment capability in XLCubed Web Edition.