Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create Chart in Excel From Access (Access 2000)

    I have data I would like to pass to Excel, have it create a chart and then send that chart back to access. Can this be done? If so, how?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Create Chart in Excel From Access (Access 2000)

    Do you really need the chart to be created in Excel? You can create charts directly in Access, either interactively or in code (using the Microsoft Graph 9.0 Object Library).

    Also see ACC97: Microsoft Access 97 Sample Graphs Available in Download Center - although it's for Access 97, the code demonstrated there works in later versions too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •