Insert objects from MS Graph?

[Stephen Glynn]

I'm not sure if I should be asking this here or in one of the Access
groups...

I've created some MS Graph pie charts in MS Access 2000 based on
queries, which are currently unbound OLE objects in some Access forms.
I'd like to get them into a Word 2000 document. Is there an easy way
to do it?

Would I be better advised to do it via Excel, where I could run Graph
again, using my Access queries as a data source?

The general idea is that the charts will form part of a regular
management report that'll contain a lot of analysis and commentary, so
it's obviously going to a Word document as much as possible. I'd like
to set something up that'll update the charts and tables as
automatically as possible (and as painlessly as possible) each time we
do the report.

Steve

 

[Stephen Glynn]

Cracked it. It seems the easiest way to do what I wanted, should
anyone else have the same problem, is to re-write the Access query on
which the graph is based so that it includes the aggregate functions --
e.g. count() and sum() -- that the Access Chart Wizard uses when it
creates the graph; send the query results to MS Word (or go into Word
and use 'Insert Database', which is on the Database toolbar in Word 2000
-- don't know else it lives) as a Word Table, and then follow the
instructions at

http://office.microsoft.com/en-us/assistance/HA011327521033.aspx

to construct a chart with Microsoft Graph (essentially, select the whole
table, and use Insert-Picture-Chart, assuming you've installed Graph).

Easy peasy (at least if you understand reasonably simple Access
aggregate functions).

Steve