insert pie chart using merge data

[Steph J.]

Hi!

As part of a mailmerge document I need to insert a pie
chart. The pie chart will be different for each merged
record. I know there is an "insert excel chart"
and "insert picture" option in Word, but I can't seem to
figure out how to connect that with the merged data.

I greatly appreciate any help you can provide!!!

Thanks so much,
Steph

 

[Charles Kenyon]

Is your data in Excel? If not, perhaps you need to put it there and generate
a chart.

 

[Steph J.]

Yes, the data is in Excel. There are almost 500 records
though. Will I need to generate a chart for each record?

Thanks!
Steph

 

[Charles Kenyon]

Only if you want a chart for each record. The thing is, Excel's charting
capability is much greater than anything in Word.

 

[Cindy M -WordMVP-]

Hi Steph,

As part of a mailmerge document I need to insert a pie
chart. The pie chart will be different for each merged
record. I know there is an "insert excel chart"
and "insert picture" option in Word, but I can't seem to
figure out how to connect that with the merged data.

I don't have much time at the moment, but...

This question is asked every couple of months. If you do a
Google search in this NG you should turn up discussions on
the point where I outline the three basic approaches that
can be used. Be warned: This is not something Word
knows how to do without a lot of help. None of the methods
is particularly "quick-and-easy".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
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

 

[Guest]

Hi Cindy.

Can you please indicate where your response to Steph's
question is. I could not locate this. Thanks.

 

[Cindy M -WordMVP-]

Can you please indicate where your response to Steph's

question is.

You replied to it. Please read again...

Cindy Meister