You can insert In-cell charts that contain XL3DataSeriesLookup formulas directly into the spreadsheet using the Anaplan XL > Insert Formula > Data Series ribbon or menu option.
To insert a chart:
- Select the Anaplan XL > Insert Formula > Data Series ribbon or menu option.
- Choose a location for the new formulas.
- Choose the connection to use from the dropdown.
- Select a measure to chart.
- Select the hierarchy of the desired members.
- Select the members to chart by selecting a member, then a set based around that member
- Select OK, to insert the formulas.
Additional options
You can specify additional filters in the grid at the bottom of the dialog.
