ACC2000: How to Export a Graph from Access to Excel

ID: Q208327

The information in this article applies to:
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 an 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, copy it 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

  1. Open the database that contains the graph that 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:


    6. Enabled: Yes
    Locked: No
  6. View the form in Form view so that the graph can calculate actual data.


  7. Click the graph object to select it, and then on the Edit menu, click Copy.


  8. Start Excel and open the worksheet in which you want to place the graph.


  9. On the Edit menu, click Paste to insert the graph.


Exporting a Graph on a Form

  1. Open the database that contains the object that you want to export, and then open the form containing the graph in Design view.


  2. Set the following properties for the graph object:


    3. Enabled: Yes
    Locked: No
  3. View the form in Form view so that the graph can calculate actual data.


  4. Click the graph object to select it, and then on the Edit menu, click Copy.


  5. Start Excel and open the worksheet in which you want to place the graph.


  6. On the Edit menu, click Paste to insert the graph.



REFERENCES

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.

Additional query words: 


Keywords          : kbinterop kbdta FmrHowto IntpGrph 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: August 9, 1999