Difference between revisions of "Insert Data Series"
(Created page with 'MicroCharts containing {{Code|XL3DataSeriesLookup}} formulae can be inserted directly into the spreadsheet using the {{Menu|XLCubed|Insert Formula|Data Series}} ribbon or men…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | [[In-Cell Charts]] containing {{Code|[[XL3DataSeriesLookup]]}} formulae can be inserted directly into the spreadsheet using the {{Menu|FluenceXL|Insert Formula|Data Series}} ribbon or menu option. | |
''To insert a chart:'' | ''To insert a chart:'' | ||
| − | # Select the {{Menu| | + | # Select the {{Menu|FluenceXL|Insert Formula|Data Series}} ribbon or menu option |
# Choose a location for the new formulae | # Choose a location for the new formulae | ||
# Choose the connection to use from the dropdown | # Choose the connection to use from the dropdown | ||
| Line 18: | Line 18: | ||
[[Category:Formula Reporting]] | [[Category:Formula Reporting]] | ||
[[Category:Formula Wizards]] | [[Category:Formula Wizards]] | ||
| + | [[Category:In-Cell Charts]] | ||
Latest revision as of 08:34, 4 July 2023
In-Cell Charts containing XL3DataSeriesLookup formulae can be inserted directly into the spreadsheet using the FluenceXL > Insert Formula > Data Series ribbon or menu option.
To insert a chart:
- Select the FluenceXL > Insert Formula > Data Series ribbon or menu option
- Choose a location for the new formulae
- Choose the connection to use from the dropdown
- Select a measure to chart
- Select the hierarchy the desired members belong to
- Select the members to chart by selecting a member, then a set based around that member
- Click OK and the formulae will be inserted
Additional Options
- Additional filters can be specified in the grid at the bottom of the dialog
