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...") |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | From v7.5, | + | From v7.5, FluenceXL has the ability to create [[Small Multiple Charts]] from data in relational databases. To insert a new chart: |
| − | # Select the {{Menu| | + | # Select the {{Menu|FluenceXL|Insert|Small Multiples|SQL...}} ribbon item |
# Select the data source and query, as described in [[SQL|SQL Data Tables (Administrators)]] | # Select the data source and query, as described in [[SQL|SQL Data Tables (Administrators)]] | ||
| − | # | + | # FluenceXL 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, and each returned column can be placed anywhere on the chart designer. | ||
| + | * 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== | ||
Latest revision as of 09:36, 4 July 2023
From v7.5, FluenceXL has the ability to create Small Multiple Charts from data in relational databases. To insert a new chart:
- Select the FluenceXL > Insert > Small Multiples > SQL... ribbon item
- Select the data source and query, as described in SQL Data Tables (Administrators)
- FluenceXL 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, and each returned column can be placed anywhere on the chart designer.
- 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:
