Plot direct record values in PivotChart view

Microsoft Office Access 2003

Show All Show All

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.

  1. Open a datasheet or form in PivotChart view.
  2. On the PivotChart toolbar, click Properties Button image, and then click the General tab.
  3. Make sure Chart Workspace is selected in the Select list.
  4. Click the Data Details tab.
  5. Select the Plot detail records check box.

Caution  Selecting and clearing the Plot detail records check box clears formatting and layout on the chart.