Excel chart in Access report

[Dave Stone]

Apologies if this isn't the right forum, but I'm clutching at straws
here....

I have a chart which must be created in Excel because the Access chart
interface does not (to my knowledge) permit custom error bars. The problem
is that I want then to include the graph in an Access report. I can see
how, via automation, I can address the chart from code in the Access report.
I just don't know how to actually include it, if you get my meaning. I
thought placing an unbound OLE object control in the report would be a good
start, but I don't seem to be able to move the chart data into it.

Any suggestions gratefully received,

Dave


--
************************************************************************
Dave Stone e-mail: (e-mail address removed)
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************************************

 

[John de Beer]

You just gave me a wonderful idea for my own project.

Here's how I plan to approach it.

Export your chart from your Excel file as a gif file. Will cut it
down in size. This will not be a updateable chart.

Then insert the gif into your report as a picture using VBA code.
Don't know how to do that just yet but i will figure it out.

In my project I export a bunch of charts to gif and then import the
gifs into powerpoint, so I can send a bunch of charts to people to
review. If I can do it to powerpoint i can do it to a series of
reports.

My 2 cents.

jdb

 

[Dave Stone]

You just gave me a wonderful idea for my own project.

Aye well, they say one man's problem is another man's opportunity!

Here's how I plan to approach it.

Export your chart from your Excel file as a gif file. Will cut it
down in size. This will not be a updateable chart.

Then insert the gif into your report as a picture using VBA code.
Don't know how to do that just yet but i will figure it out.

Sounds a possibility I should explore - thanks.

I've seen various other posts in this and other newsgroups which
suggest that this was the way to tackle it. Unfortunately, none have
included the magic lines of code which associate the XL chart with the
Access OLEUnbound thingy.