ACC: How to Export a Graph from MS Access to MS Excel
ID: Q158928
|
The information in this article applies to:
-
Microsoft Access versions 7.0, 97
-
Microsoft Excel 97 for Windows
-
Microsoft Excel for Windows 95, version 7.0
SUMMARY
Moderate: Requires basic macro, coding, and interoperability skills.
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
- Open the database that contains the graph you want to export, and then
open the report containing 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 the graph can calculate actual data.
- Click the graph object to select it, and then on the Edit menu, click
Copy.
- Start Microsoft Excel and open the worksheet into which you want to
paste the graph.
- On the Edit menu, click Paste to insert the graph.
Export a Graph on a Form
- Open the database that contains the object you want to export.
- Open the form containing the graph in Design view.
- Perform steps 5-9 in the "Export a Graph on a Report" section.
REFERENCES
For more information about using graphs in Microsoft Access, search the
Help Index for "graphs," or ask the Microsoft Access 97 Office Assistant.
For more information about displaying actual graph data in Design view of a
form or report, please see the following article in the Microsoft
Knowledge Base:
Q154454 ACC: Microsoft Graph Always Shows Sample Data in Design View
Keywords : kbinterop FmrHowto IntpGrph
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbhowto