Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: access to excel and back

    a user of one of my databases wants a excel chart instead of the actual report. I can use the query to analyze the data with excel and create the chart but I can't find a way to import the chart so that the user can open. Can someone tell me how to do this? I looked in help and it doesn't tell me anything.
    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I believe the same chart control is used in Access as Excel. Is there a reason you're not creating your chart in Access?

    In most cases, you would be importing data to create a chart in Access as opposed to an actual image.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Dunno about getting the chart back in but have a look here (exporting data from access to excel & producing a chart in Excel from that):
    http://www.dbforums.com/showpost.php...81&postcount=4
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Teddy
    I believe the same chart control is used in Access as Excel.
    Now I can think of no reason why that would not be the case but the whole reason I wrote code to create charts in Excel is because the object model just seemed easier to manipulate & more comprehensive.

    Might have been me though.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2004
    Posts
    214
    I tried to create the charts in access but it does not cooperate like excel.

Posting Permissions

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