Working with Charts

Charts are useful tools for both forms and reports. They enable you to visually display aggregate data in trends or compared with other data. There are two types of charts you can use on reports. The first is created using the Microsoft Graph OLE Object and can be inserted using the Insert Chart button on the Design tab in the Report Designer. The other is a PivotChart, which can be created using a form. That form can subsequently be used as a subreport on a report to display the chart. The PivotChart object is more flexible and contains a rich object model that you can use from Access. While a discussion of this object model is beyond the scope of this book, there are some useful things you can do using PivotCharts such as display a chart in a group for a subset of records in a hierarchy.

Both types of charts can display related data using the LinkChildFields and LinkMasterFields properties.

0 0

Post a comment