About charts

In a form or report, you can use Microsoft Graph to create a chart linked to data from the available tables, queries, or other record sources. The charts can be global (including all data) or record-bound (reflecting data only from the current record, in which case the chart updates as you move from record to record).

Several chart types, including two-dimensional (2-D) and three-dimensional (3-D) types, are available for you to choose from. Formatting options include adding text and graphics to the charts, changing colors, and adding trendlines and error bars.

You can use Microsoft Office Chart (a Microsoft Office Web Component) to create dynamic, interactive charts in a data access page that you can then make available on the Web. For example, you can create a chart by using data in a table that stores sales figures. When you update the sales figures, the chart updates— so users can always see the latest information on their Web pages.

You can create a chart in a page by using data from tables or queries, or from a Spreadsheet Component or PivotTable list. You can choose from a variety of chart types in which you can add text, change colors, and take advantage of other formatting options, such as adding trendlines and error bars.

You can also modify a chart in a page that was published as an interactive chart from Microsoft Excel. When you publish an interactive chart in Excel, the data for the chart is published with it as a Spreadsheet Component or PivotTable list. For more information about publishing charts from Excel, see Microsoft Excel Help.

Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later is required to create a chart on a page.

In an Access database or Access project, you can display a datasheet or form that contains sales figures as a dynamic, interactive chart in PivotChart view. PivotChart view automatically uses Microsoft Office Chart (a Microsoft Office Web Component) to display the chart. In PivotChart view, you can choose from a variety of chart types in which you can add text, change colors, and take advantage of other formatting options, such as adding trendlines and error bars.