Interactive Charting

XLCubed version 7.5 provides the ability for more interactive, chart-driven reporting. This is achieved by extending the existing Small Multiple charts in the product.

Small Multiples have been extended in three key areas: 1) Full control over selected chart and chart area. 2) More control over axis and title formatting 3) In addition to cubes, Small Multiple charts can also be built from an Excel Range or directly from SQL.

Chart Selections

When building reports, it's now possible to track any selected element of a Small Multiple Chart. This includes an axis element, an individual chart, or any data point in the chart. This information can be output to a range of Excel cells, and then other parts of the overall report, including grids and formulae, can be based on the content of these cells. The chart will also indicate by colour which chart or datapoint is selected. This is handled by all unselected elements being displayed in a much lighter shade, while the selected item retains the original colour.

These output properties are configured in the properties for the chart control, as shown in the screenshot. To track an element, select the relevant checkbox and chose the desired output cell.

'Link to' is also available as an option, where the focus can be moved to another area of the report in the context of the selected chart or chart element.