Plot direct record values in PivotChart view
By default, totals from your source data are plotted in a PivotChart view. The Plot detail records option allows you to plot values from individual records rather than the totals for groups of records.
- Open a datasheet or form in PivotChart view.
- On the PivotChart toolbar, click Properties , and then click the General tab.
- Make sure Chart Workspace is selected in the Select list.
- Click the Data Details tab.
- Select the Plot detail records check box.
Caution Selecting and clearing the Plot detail records check box clears formatting and layout on the chart.