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

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
6. View the form in Form view so the graph can calculate actual data.
7. Click the graph object to select it, and then on the Edit menu, click Copy.
8. Start Microsoft Excel and open the worksheet into which you want to paste the graph.
9. 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.