Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208327 - Last Review: June 24, 2004 - Revision: 4.0
ACC2000: How to Export a Graph from Access to Excel
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).
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
-
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.
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.
APPLIES TO
- Microsoft Excel 2000 Standard Edition
- Microsoft Access 2000 Standard Edition
| kbhowto kbinterop KB208327 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate