Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Insert objects from MS Graph?
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 |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Insert objects from MS Graph?
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/as...327521033.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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Address Button v. Envelopes | Microsoft Word Help | |||
Insert Objects | Microsoft Word Help | |||
Accidentally removed "symbol" from Insert menu...Help Please! | Microsoft Word Help | |||
How come when I insert clipart or drawing objects, they disappear. | Microsoft Word Help | |||
Insert objects at page breaks | Microsoft Word Help |