Difference between revisions of "Charting and Dashboards"
(→In-cell Charts) |
(→Dynamic Charts) |
||
| (16 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
==Standard Excel Charts== | ==Standard Excel Charts== | ||
| − | + | FluenceXL operates within Excel, and as such any data retrieved into the workbook using FluenceXL can be charted using any standard Excel chart type. [[File:xlc.jpg|150px|right]] | |
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. | 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. | ||
| − | == | + | ==FluenceXL Grid Charts== |
| − | + | FluenceXL Grid Charts provide a way to tie a chart directly to an FluenceXL Grid. [[File:gchart.jpg|150px|right]] 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]] | + | For further information go to: [[Grid Charts]] |
| − | ==In- | + | ==In-Cell Charts == |
| − | In-cell charts are small, focused charts which each fit within one Excel cell. | + | In-cell charts are small, focused charts which each fit within one Excel cell. 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: | In-cell charts can be used in two ways: | ||
| − | Formula-based - where an | + | Formula-based - where an FluenceXL formula controls the chart, and the data being plotted must first be returned into Excel. For more detail see: |
[[In-Cell Chart Designer]] | [[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]] | + | 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]] |
| − | == | + | [[Image:Incell2.jpg|center]] |
| − | + | ||
| + | |||
| + | [[File:In-cell-charts.PNG|600px|center|alt="FluenceXL in-cell charts in a grid in Excel"]] | ||
| + | |||
| + | ==Dynamic Charts== | ||
| + | |||
| + | Dynamic Charts, inspired by Trellis charts, are highly interactive and use individual charts 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. | 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: [[Dynamic Charts]] | ||
| + | |||
| + | [[File:XLCubed-Chart-Small-Multiple.PNG|thumb|650px|center|Several charts are displayed in one control and share an axis]] | ||
| − | + | [[File:XLCubed-Chart-Custom-Tooltip.png|thumb|650px|center|alt="FluenceXL chart with interactive and animated tooltip"|Dynamic Charts can be used as interactive and dynamic charting solutions in Excel]] | |
| − | == | + | ==Treemaps== |
| − | A Treemap is a way to display hierarchical information using nested rectangles or tiles. | + | A Treemap is a way to display hierarchical information using nested rectangles or tiles. 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]] | ||
| − | + | [[Image:TreemapRange2Level.png|center]] | |
==Mapping== | ==Mapping== | ||
| − | + | FluenceXL provides point and shape based Geospatial mapping. 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]] | ||
| + | |||
| + | [[Image:Excel-mapping-xlcubed.PNG|750px|center]] | ||
| + | |||
| + | ==Dynamic Dashboards== | ||
| + | |||
| + | FluenceXL allows for the creation of special sheets which are responsive to screen size. Any FluenceXL component can be added to the sheet to create highly dynamic and interactive dashboards suitable for viewing on any device. | ||
| + | |||
| + | For further information go to: [[Dashboard sheets]] | ||
| + | |||
| + | [[File:Dashboard-dynamic-excel-xlcubed.PNG|800px|center|alt="A responsive sales dashboard built in Excel using FluenceXL Dashboard Sheets"]] | ||
| − | + | [[Category:Getting Started]] | |
| + | [[Category:Visualisations]] | ||
Latest revision as of 13:29, 2 August 2023
Contents
[hide]Standard Excel Charts
FluenceXL operates within Excel, and as such any data retrieved into the workbook using FluenceXL 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.
FluenceXL Grid Charts
FluenceXL Grid Charts provide a way to tie a chart directly to an FluenceXL 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
In-cell charts are small, focused charts which each fit within one Excel cell. 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 FluenceXL 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
Dynamic Charts
Dynamic Charts, inspired by Trellis charts, are highly interactive and use individual charts 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: Dynamic Charts
Treemaps
A Treemap is a way to display hierarchical information using nested rectangles or tiles. 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
FluenceXL provides point and shape based Geospatial mapping. 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
Dynamic Dashboards
FluenceXL allows for the creation of special sheets which are responsive to screen size. Any FluenceXL component can be added to the sheet to create highly dynamic and interactive dashboards suitable for viewing on any device.
For further information go to: Dashboard sheets
