Financially-focused Interactive Charting

Dynamic charts connect directly to the data source and are highly interactive. Charts components can  be used as selection filters for other parts of the report, or for other charts. Charts can be zoomed, drilled into, or expanded to a Small Multiple view where each chart varies by one selection (e.g. one waterfall chart per business unit).

They can be used to quickly configure a pre-determined view of the data in formal reports and dashboards, or for interactive data discovery.

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.