How to create pie chart from linked CSV file in Word?

[Emre Bastuz]

Hi,

I am trying to create a Word document which should contain a couple
of charts (pie, bars, etc.). The source for the charts´ data should be
a couple of csv files I have on harddisk. I would like to "link" the
csv file to the Word document (or the chart) so I don´t have to do a
manual import. Instead the charts should show the data from the current
file every time the Word document is opened.

So far I have tried to do this with a combination of Excel and Word
which does not work for me.

Basically the problems are as follows:
- when I create the chart in Word only, I can not link it to the CSV
file/s

- when I create multiple charts in one Excel file, I can use a small
VBA script to automatically read the CSV files and adjust the graphs
(each char on a differen sheet).
Unfortunately I have not found a way to link specific sheets in Excel
to specific objects in the Word document so this won´t work either.

Anyone have any idea how to do this?

Thanks in advance!

Regards,

Emre

 

[Cindy M -WordMVP-]

Hi Emre,

There won't be any way to do this between Word and the csv files,
directly. The only kind of chart Word supports that can link to data
outside it's own object is MS Graph. That can link to a Word table, but it
must be visible. But there wouldn't be any way to link the Word table to
the CSV file.

Best you could do would be to link the CSV file to Excel, base the chart
on that, and link Word to the Excel chart. But chances are things wouldn't
update automatically.

That only leaves a VBA (programmed) solution.

I am trying to create a Word document which should contain a couple
of charts (pie, bars, etc.). The source for the charts´ data should be
a couple of csv files I have on harddisk. I would like to "link" the
csv file to the Word document (or the chart) so I don´t have to do a
manual import. Instead the charts should show the data from the current
file every time the Word document is opened.

So far I have tried to do this with a combination of Excel and Word
which does not work for me.

Basically the problems are as follows:
- when I create the chart in Word only, I can not link it to the CSV
file/s

- when I create multiple charts in one Excel file, I can use a small
VBA script to automatically read the CSV files and adjust the graphs
(each char on a differen sheet).
Unfortunately I have not found a way to link specific sheets in Excel
to specific objects in the Word document so this won´t work either.

Anyone have any idea how to do this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail