Difference between revisions of "Small Multiple Charts based on SQL"
m (Text replacement - "XLCubed" to "FluenceXL")
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
−
From v7.5, XLCubed has the ability to create [[Small Multiple Charts]] from data in relational databases. To insert a new chart:
+
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|XLCubed|Insert|Small Multiples|SQL...}} ribbon item
+
# 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)]]
−
# XLCubed will then insert an empty chart for you, ready for your columns selections
+
# 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:
 
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 teh chart designer.
+
* 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.
 
* 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]]
 
* To edit the connection, you may click the {{Menu|Select data source}} toolbar button in the Task Pane: [[File:SelectDataSourceIcon.png]]

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:

  1. Select the FluenceXL > Insert > Small Multiples > SQL... ribbon item
  2. Select the data source and query, as described in SQL Data Tables (Administrators)
  3. 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: SelectDataSourceIcon.png

See Also

Retrieved from ‘https://help.fluencexl.com/index.php?title=Small_Multiple_Charts_based_on_SQL&oldid=11427’