Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Charting and Dashboards

    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.
    Xlc.jpg


    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.
    Gchart.jpg
    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

    In-cell charts are small, focused charts which each fit within one Excel cell.
    Incell2.jpg
    They are designed to be used within tables of data, and allow the mixing of numbers and charts together in tables. They are often a very space efficient way to give context to, or highlight outliers in a data table.

    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 Multiples

    Small Multiples, often known as Trellis charts, are highly interactive and use individual charts
    Sm24.png
    to display each slice of a data set.

    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

    Treemaps

    A Treemap is a way to display hierarchical information using nested rectangles or tiles.
    TreemapRange2Level.png
    They are most often set up where the size of the rectangle depicts one metric, and the colour depicts another. They can often help identify pattern which would otherwise be difficult to see.


    For further information go to: Treemaps

    Mapping

    XLCubed provides point and shape based Geospatial mapping.
    Map.jpg
    The maps can be zoomed and panned as needed, and can be used as a selector for a report as well as just a display.


    For further information go to: Maps