Show All

Hide All

In Access 2000 and earlier, you add a chart to a form or report by using the chart control (Microsoft Graph). Access 2002 provides a better technique for including charts in your forms and reports: You can embed a form that is open in PivotChart view as a subform in another form or report.

In Access 2002 or later, forms support two new views: PivotTable view and PivotChart view. PivotTable view uses the Office PivotTable Component to facilitate interactive data analysis. PivotChart view uses the Office Chart Component to help you create dynamic, interactive charts.

The following illustration shows a form in PivotChart view.

The following illustration shows the Categories form that displays sales details for each category in a chart.

Advantages of embedding a subform in PivotChart view:

• PivotChart view supports more chart types and formatting options than the chart control.
• Compared to using the chart control, it is easier to create record-bound (synchronized) charts by embedding a subform in a main form.
• PivotChart view provides several tools, such as the field list and property sheet, to help you create a chart that meets your requirements.
• If you need to write code to create and manipulate the chart, you will find it easier to use PivotChart view because the view's events and methods are integrated into the Access object model. The chart control is an external component and has its own object model.

For more information about how to design and format a PivotChart view, see Access Help.

Create a form or report that uses a subform in PivotChart view to display charts