Automating charts in word

[helen.s]

Is it possible to automatically update charts within a word document from a
data source and thus create automated reports? I want to create several
research reports which will contain around 10 charts (e.g. excel bar charts).
The data will be in one source and will contain flags for sector. Each sector
will get a seperate report. I want to create it in word so that I can easily
add text to form a story around the charts. The text will not be generated
automatically and may be of different lengths depending on the results.

Any suggestions would be appreciated, thanks.

 

[Jean-Guy Marcil]

helen.s was telling us:
helen.s nous racontait que :

Is it possible to automatically update charts within a word document
from a data source and thus create automated reports? I want to
create several research reports which will contain around 10 charts
(e.g. excel bar charts). The data will be in one source and will
contain flags for sector. Each sector will get a seperate report. I
want to create it in word so that I can easily add text to form a
story around the charts. The text will not be generated automatically
and may be of different lengths depending on the results.

Any suggestions would be appreciated, thanks.

Create the Word document without the charts.
Create the charts in an Excel workbook.
Make sure the Excel workbook and the Word document are in the same folder
(It is not absolutely necessary, but it make things easier if you move them
around later)
Select the first chart in Excel and do CTRL-C
Go to the Word document, place the cursor where you want the chart.
Do Edit menu >Paste Special > Paste Link and Select Excel Chart

Now your chart in word are linked to the Excel one and what ever change you
do in the Excel workbook will be visible in the Word document.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org