Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Insert Data Series

    In-Cell Charts 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:

    1. Select the XLCubed > Insert Formula > Data Series ribbon or menu option
    2. Choose a location for the new formulae
    3. Choose the connection to use from the dropdown
    4. Select a measure to chart
    5. Select the hierarchy the desired members belong to
    6. Select the members to chart by selecting a member, then a set based around that member
    7. Click OK and the formulae will be inserted

    Additional Options

    • Additional filters can be specified in the grid at the bottom of the dialog

    See Also