Microsoft KB Archive/158928

= ACC: How to Export a Graph from Microsoft Access to Microsoft Excel =

Article ID: 158928

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q158928



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
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.



MORE INFORMATION
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

 * 1) Open the database that contains the graph you want to export, and then open the report containing the graph in Design view.
 * 2) Click the graph object to select it, and then on the Edit menu, click Copy.
 * 3) Create a new form not based on any table or query in Design view.
 * 4) On the Edit menu, click Paste. The graph object appears on the form. Note that the graph displays sample data in Design view.
 * 5) Set the following properties for the graph object:

Enabled: Yes Locked: No
 * 1) View the form in Form view so the graph can calculate actual data.
 * 2) Click the graph object to select it, and then on the Edit menu, click Copy.
 * 3) Start Microsoft Excel and open the worksheet into which you want to paste the graph.
 * 4) On the Edit menu, click Paste to insert the graph.

Export a Graph on a Form

 * 1) Open the database that contains the object you want to export.
 * 2) Open the form containing the graph in Design view.
 * 3) Perform steps 5-9 in the "Export a Graph on a Report" section.

