| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Small Multiple Charts based on SQL"
(Created page with "From v7.5, XLCubed has the ability to create Small Multiple Charts from data in relational databases. To insert a new chart: # Select the {{Menu|XLCubed|Insert|Small Multipl...") |
|||
| Line 5: | Line 5: | ||
# XLCubed will then insert an empty chart for you, ready for your columns selections | # XLCubed will then insert an empty chart for you, ready for your columns selections | ||
| − | To edit the connection, you may click the {{Menu|Select data source}} toolbar button in the Task Pane: [[File:SelectDataSourceIcon.png]] | + | These small multiple charts are identical to the Analysis Services based charts described on the [[Small Multiple Charts]] page, except for a few differences: |
| + | * There is no Header area: the charts are always based on the entire data set | ||
| + | * Any numeric column can be selected for the Y Axis values. When appropriate, this also applies to X Axis and Colour values. | ||
| + | * To edit the connection, you may click the {{Menu|Select data source}} toolbar button in the Task Pane: [[File:SelectDataSourceIcon.png]] | ||
==See Also== | ==See Also== | ||
Revision as of 17:33, 21 June 2013
From v7.5, XLCubed has the ability to create Small Multiple Charts from data in relational databases. To insert a new chart:
- Select the XLCubed > Insert > Small Multiples > SQL... ribbon item
- Select the data source and query, as described in SQL Data Tables (Administrators)
- XLCubed will then insert an empty chart for you, ready for your columns selections
These small multiple charts are identical to the Analysis Services based charts described on the Small Multiple Charts page, except for a few differences:
- There is no Header area: the charts are always based on the entire data set
- Any numeric column can be selected for the Y Axis values. When appropriate, this also applies to X Axis and Colour values.
- To edit the connection, you may click the Select data source toolbar button in the Task Pane:
