Our overall perspective on data visualisation has been inspired by field experts like Edward Tufte and Stephen Few. We focus on charting which works for business reporting, and have added a number of charting and visualisation components to address gaps in native Excel.
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.
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.
TreeMaps represent hierarchical data as a set of nested rectangles (tiles) where the area of the tile represents one metric and the colour a second metric. They can be a highly effective way to visualise regional sales where for example States may be the outer tile, and Cities would be nested tiles within the State. Colour is often used to identify an issue in the data, for example red may signify negative margin.
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.
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.
Maidenhead Court Boathouse, Court Road, Maidenhead, Berkshire
SL6 8LQ, United Kingdom
+44 1628 763 222