Financially-focused Interactive Charting

Also known as Trellis charts, Small Multiples connect directly to the data source and are highly interactive.

They are used to display multiple charts varying by one selection criteria on the same chart framework, for example each chart displaying sales for a different product across the same time period. They can be used to quickly configure a pre-determined view of the data, or for interactive data discovery through chart driven drilldown.

Responsive, device optimised dashboards can be developed in Excel using all the regular XLCubed features and then published to XLCubed Web for simple mobile use. The reports auto-fit any screen size and their layout can be optimised simply for any device type.

The Repeater control extends the concept of a small multiple chart - where it is very easy to quickly build several charts varying by just one element - to any part of a report, not just one chart or one grid.

It lends itself really well to card based reporting where a summary view is defined, potentially combining XLCubed and native Excel functionality, along with charts. Having built the base layout as required, (for a specific location, for example) the process of extending that across other locations, and displaying them together in a consolidated view becomes extremely quick and straightforward. 

In-cell charts display within an individual Excel cell, and can be highly effective as part of a data table to show historical context, show relative volumes, actual to target, distribution or to flag issues. Easy to use and highly configurable they are a great addition to business reporting which require very little screen real estate.

Users face two common layout challenges in complex Excel reports & dashboards:

Firstly, handling row dynamic elements within a formatted report, particularly where there is other content below the variable length section.

Secondly, columns can only be one width for the whole worksheet, which can lead to layout challenges with different sections of the report.

Viewports adress both issues by providing a dynamic, scrollable window to another part of the workbook, allowing users to display any data in the workbok anywhere, free from the row and column boundaries.

XLCubed provides both point and shape based geospatial mapping. Maps are interactive and can be zoomed and panned as required, can be configured to display additional information on hover over, and used as selectors for other areas of the report.