ACC2000: How to Export a Graph from Access to Excel

You can use Microsoft Graph to embed a graph object in a Microsoft Access form or report. However, if you export the form or report to an Excel worksheet, the graph does not appear in the worksheet.

This article describes how to export a Microsoft Graph object to an Excel worksheet.

If the graph that you want to export to Excel is on a report, you must copy the graph to a form first; then, you can copy the graph from the form and paste it into an Excel worksheet. If you copy the graph directly from a report and paste it into an Excel worksheet, you see only sample graph data on the worksheet.

To export a graph from an Access form or report to an Excel worksheet, follow the steps for the object that you are using.

Exporting a Graph on a Report

1. Open the database that contains the graph that you want to export, and then open the report that contains 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
6. View the form in Form view so that the graph can calculate actual data.
7. Click the graph object to select it, and then on the Edit menu, click Copy.
8. Start Excel and open the worksheet in which you want to place the graph.
9. On the Edit menu, click Paste to insert the graph.

Exporting a Graph on a Form

1. Open the database that contains the graph that you want to export, and then open the form that contains the graph in Design view. Note that the graph displays sample data in Design view.
2. Set the following properties for the graph object:
   Enabled: Yes
   Locked: No
3. View the form in Form view so that the graph can calculate actual data.
4. Click the graph object to select it, and then on the Edit menu, click Copy.
5. Start Excel and open the worksheet in which you want to place the graph.
6. On the Edit menu, click Paste to insert the graph.

For more information about using graphs in Microsoft Access, click Microsoft Access Help on the Help menu, type graphs in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.