Working with charts

By default, an ad-hoc report displays a data table. You can add a chart before or after the table.

Click Chart Settings in the Ad-hoc Report group on the ribbon and select Chart and Table or Table and Chart.

See Ribbon and groups.

To change the type of chart, right-click the chart and select Change Chart Type.

Microsoft Excel's chart options can be used in formula reports.

Drill down, roll up, collapse, expand

You can Drill Down, Roll Up, Collapse and Expand the data series of a chart in the same way as data.

See Drill down/expand.

Right-click a data series and select from the menu.

Option	Description
Expand	Show the values of the elements and the next level.
Collapse	Display the values at the previous level.
Drill down	Show the values of the children of an element.
Roll up	Show the values of the parents.
Change Chart Type	Display the Change Chart Type dialog.

The data in the table expands and collapses with the data in the chart.

Note: If you use provider formatting. You cannot display charts in Alea ad-hoc reports.

See Working with data formatting types