Microsoft KB Archive/208327

= ACC2000: How to Export a Graph from Access to Excel =

Article ID: 208327

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208327



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



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



MORE INFORMATION
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
 Open the database that contains the graph that you want to export, and then open the report that contains the graph in Design view. Click the graph object to select it, and then on the Edit menu, click Copy. Create a new form not based on any table or query in Design view. On the Edit menu, click Paste. The graph object appears on the form. Note that the graph displays sample data in Design view. Set the following properties for the graph object:

Enabled: Yes

Locked: No

 View the form in Form view so that the graph can calculate actual data.</li> Click the graph object to select it, and then on the Edit menu, click Copy.</li> Start Excel and open the worksheet in which you want to place the graph.</li> On the Edit menu, click Paste to insert the graph.</li></ol>

Exporting a Graph on a Form
<ol> 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.</li> Set the following properties for the graph object:

Enabled: Yes

Locked: No

</li> View the form in Form view so that the graph can calculate actual data.</li> Click the graph object to select it, and then on the Edit menu, click Copy.</li> Start Excel and open the worksheet in which you want to place the graph.</li> On the Edit menu, click Paste to insert the graph.</li></ol>

<div class="references_section">