Charting and Dashboards
Standard Excel ChartsXLCubed operates within Excel, and as such any data retrieved into the workbook using XLCubed can be charted using any standard Excel chart type.
If the data being plotted is static in shape and you need very fine grain control over the chart formatting this is likely the best approach.
XLCubed Grid ChartsXLCubed Grid Charts provide a way to tie a chart directly to an XLCubed Grid.
For further information go to: Grid Charts
In-Cell ChartsIn-cell charts are small, focused charts which each fit within one Excel cell.
In-cell charts can be used in two ways:
Formula-based - where an XLCubed formula controls the chart, and the data being plotted must first be returned into Excel. For more detail see: In-Cell Chart Designer
Embedded in grids - where the charts are generated directly as part of the grid, and support data growth - for more detail see: In-Cell Charts in Grids
Small MultiplesSmall Multiples, often known as Trellis charts, are highly interactive and use individual charts
The axes are on a common scale, and the only variable is the data set slice being changed. They make it easy to see shared trend and pattern or outliers across the data set.
For further information go to: Small Multiples
TreemapsA Treemap is a way to display hierarchical information using nested rectangles or tiles.
For further information go to: Treemaps
MappingXLCubed provides point and shape based Geospatial mapping.
For further information go to: Maps