Article ID: 158928 - View products that this article applies to.
This article was previously published under Q158928
Moderate: Requires basic macro, coding, and interoperability skills.
In Microsoft Access, you can use Microsoft Graph to embed a graph object in a form or report. However, if you export the form or report to a Microsoft Excel worksheet, the graph does not appear in the worksheet.
This article describes how to export a Microsoft Graph object to a Microsoft Excel worksheet.
If the graph you want to export to Microsoft Excel is on a report, you must copy the graph to a form first, and then you can copy it from the form and paste it into Microsoft Excel. If you copy the graph directly from a report and paste it into a Microsoft Excel worksheet, you only see sample graph data on the worksheet. To export a graph from a Microsoft Access form or report to a Microsoft Excel worksheet, follow these steps:
Export a Graph on a Report
Export a Graph on a Form
For more information about using graphs in Microsoft Access, search the Help Index for "graphs," or ask the Microsoft Access 97 Office Assistant.
For more information about displaying actual graph data in Design view of a form or report, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/154454/EN-US/ )ACC: Microsoft Graph Always Shows Sample Data in Design View
Article ID: 158928 - Last Review: January 19, 2007 - Revision: 3.2