ACC2000: How to Export a Graph from Access to Excel
ID: Q208327
|
The information in this article applies to:
-
Microsoft Access 2000
-
Microsoft Excel 2000
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and 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.
-
Click the graph object to select it, and then on the Edit menu, click Copy.
- Start Excel and open the worksheet in which you want to place the graph.
- On the Edit menu, click Paste to insert the graph.
Exporting a Graph on a Form
-
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.
- 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.
-
Click the graph object to select it, and then on the Edit menu, click Copy.
- Start Excel and open the worksheet in which you want to place the graph.
- On the Edit menu, click Paste to insert the graph.
REFERENCESFor 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.
Additional query words:
Keywords : kbinterop kbdta FmrHowto IntpGrph
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto
|