| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Insert Data Series
Revision as of 15:09, 13 October 2010 by Antonio.remedios (talk | contribs) (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…')
MicroCharts containing XL3DataSeriesLookup formulae can be inserted directly into the spreadsheet using the XLCubed > Insert Formula > Data Series ribbon or menu option.
To insert a chart:
- Select the XLCubed > 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
