Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Buckinghamshire, UK
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Excel Chart Object in Report (Access 2000)

    i am trying to insert an object in a report named "MS Excel Chart" under the design mode of reports. It does install however when I try to put data into it from a query i get error message "Operation on the OLE object failed. OLE server may not be registered. To register OLE server reinstall it" . I then went to references under the module pane and loaded up various libraries and I still get same message. What am i doing wrong?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert Excel Chart Object in Report (Access 2000)

    Sorry, but why are you trying to insert an Excel chart as opposed to simply using Microsoft Graph (which is also what Excel uses) anyhow?
    Charlotte

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Insert Excel Chart Object in Report (Access 2000)

    Charlotte,

    I am having the same problem. I can create the graph I want in excel, however, when using Microsoft Graph, the graph does not provide the same look. Of course, it could be that I don't truly understand Microsoft Graph, but that is another problem.

    Is there a way to get around this error message??
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Insert Excel Chart Object in Report (Access 2000)

    ... I figured out how to make the chart work as required....
    Regards,

    Gary
    (It's been a while!)

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert Excel Chart Object in Report (Access 2000)

    Then it would be nice if you posted your solution so others can benefit.
    Charlotte

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Insert Excel Chart Object in Report (Access 2000)

    ... I used a query to create the same dataset that I use for excel, however, I only provide visibility on two of the fields to be graphed. When trying to use all of the fields, the graphs did not work correctly. The two fields then populated the x and y axis's. I did not set a data series as I have various graphs for each set of data.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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