Charting and Dashboards

Revision as of 16:32, 9 September 2013 by Gcrawford (talk) (XLCubed Grid Charts)

Standard Excel Charts

XLCubed 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 Charts

XLCubed Grid Charts provide a way to tie a chart directly to an XLCubed Grid. This caters for when the grid changes in shape and the number of elements, and lets the user specify the hierarchical level of the data to be plotted. The available chart types are a subset of the Excel Chart library.

For further information go to:Grid Charts

In-cell Charts

Formula-based - for further information go to:In-Cell Charts Formula-Based

Embedded in grids - for further information go to:In-Cell Charts in Grids

Small Multiples

For further information go to:Small Multiple Charts

TreeMaps

For further information go to:Treemaps

Mapping

For further information go to:Maps