Re: Insert objects from MS Graph?
- From: Stephen Glynn <stephen.glynn@xxxxxxxxxxxx>
- Date: Mon, 16 Jan 2006 00:07:25 GMT
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
Stephen Glynn wrote:
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
.
- References:
- Insert objects from MS Graph?
- From: Stephen Glynn
- Insert objects from MS Graph?
- Prev by Date: Re: macro storage
- Next by Date: Re: macro storage
- Previous by thread: Insert objects from MS Graph?
- Index(es):
Relevant Pages
|
