A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Inserting pie chart into mail merge document



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2004, 02:39 PM
vicki
external usenet poster
 
Posts: n/a
Default Inserting pie chart into mail merge document

I'm trying to get a pie chart in a mail merge document to
change with each record in the datasource (an excel
file). I've placed the merge fields for the two figures I
wish represented in the pie chart in a table. I've then
successfully added the pie chart, but always shows the
data from the first record. Is there anyway to set up the
main document so that the chart changes according to the
data for each record?
  #2  
Old May 19th, 2004, 05:54 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Inserting pie chart into mail merge document

Hi Vicki,

This is not something mail merge can do for you, without
quite a bit of help. Either manually or with VBA code. Which
version of Office do you have?

I'm trying to get a pie chart in a mail merge document to
change with each record in the datasource (an excel
file). I've placed the merge fields for the two figures I
wish represented in the pie chart in a table. I've then
successfully added the pie chart, but always shows the
data from the first record. Is there anyway to set up the
main document so that the chart changes according to the
data for each record?


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 :-)

  #3  
Old May 20th, 2004, 02:07 PM
external usenet poster
 
Posts: n/a
Default Inserting pie chart into mail merge document

We're working in 2002 SP2 for both Word and Excel.

-----Original Message-----
Hi Vicki,

This is not something mail merge can do for you, without
quite a bit of help. Either manually or with VBA code.

Which
version of Office do you have?

I'm trying to get a pie chart in a mail merge document

to
change with each record in the datasource (an excel
file). I've placed the merge fields for the two

figures I
wish represented in the pie chart in a table. I've

then
successfully added the pie chart, but always shows the
data from the first record. Is there anyway to set up

the
main document so that the chart changes according to

the
data for each record?


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 :-)

.

  #4  
Old May 20th, 2004, 04:44 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Inserting pie chart into mail merge document

We're working in 2002 SP2 for both Word and Excel.

OK. I'll outline the three (or four) basic approaches that
can be used. One of them requires macro code; the other
three are really only do-able using macros, but could be
done manually:

1. Create a separate pie chart for each record in Excel. Add
a merge field to the data source that contains the
corresponding NAME for each chart sheet. Use this merge
field in a LINK field to link the chart across for the
merge. Merge to a new document, Ctrl+A, then F9 to update
the LINK fields.

2. The approach you tried already, linking a table in Word
to an MS Graph chart. But then you have to manually "view"
each record and print that out. Executing the mail merge
won't work because the bookmark that links the table into
the chart is lost.

3. Similar to (2), but you create the charts AFTER the mail
merge.

4. In Word 2002/2003 there's a VBA-thing that would let you
create the charts on-the-fly, using either a table in the
document, or data from an outside source.

Of these, I think only (2) would be acceptable to do
manually. Whether you'd actually want to do it would depend
on how many records you'd have to cycle through.

If you're not in a hurry, I'm planning to work up (4) for a
book. I just don't know when I'll get to it (over the
weekend, I hope!)

-----Original Message-----
Hi Vicki,

This is not something mail merge can do for you, without
quite a bit of help. Either manually or with VBA code.

Which
version of Office do you have?

I'm trying to get a pie chart in a mail merge document

to
change with each record in the datasource (an excel
file). I've placed the merge fields for the two

figures I
wish represented in the pie chart in a table. I've

then
successfully added the pie chart, but always shows the
data from the first record. Is there anyway to set up

the
main document so that the chart changes according to

the
data for each record?


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
:-)

  #5  
Old May 21st, 2004, 12:53 AM
Vicki
external usenet poster
 
Posts: n/a
Default Inserting pie chart into mail merge document

Thanks for the info! We have about 1300 records to merge
so I don't think we'll opt for the manual procedure. I am
interested in the 4th option, so please pass it on when
complete.
-----Original Message-----
We're working in 2002 SP2 for both Word and Excel.

OK. I'll outline the three (or four) basic approaches

that
can be used. One of them requires macro code; the other
three are really only do-able using macros, but could be
done manually:

1. Create a separate pie chart for each record in Excel.

Add
a merge field to the data source that contains the
corresponding NAME for each chart sheet. Use this merge
field in a LINK field to link the chart across for the
merge. Merge to a new document, Ctrl+A, then F9 to update
the LINK fields.

2. The approach you tried already, linking a table in

Word
to an MS Graph chart. But then you have to

manually "view"
each record and print that out. Executing the mail merge
won't work because the bookmark that links the table into
the chart is lost.

3. Similar to (2), but you create the charts AFTER the

mail
merge.

4. In Word 2002/2003 there's a VBA-thing that would let

you
create the charts on-the-fly, using either a table in the
document, or data from an outside source.

Of these, I think only (2) would be acceptable to do
manually. Whether you'd actually want to do it would

depend
on how many records you'd have to cycle through.

If you're not in a hurry, I'm planning to work up (4) for

a
book. I just don't know when I'll get to it (over the
weekend, I hope!)

-----Original Message-----
Hi Vicki,

This is not something mail merge can do for you,

without
quite a bit of help. Either manually or with VBA code.

Which
version of Office do you have?

I'm trying to get a pie chart in a mail merge

document
to
change with each record in the datasource (an excel
file). I've placed the merge fields for the two

figures I
wish represented in the pie chart in a table. I've

then
successfully added the pie chart, but always shows

the
data from the first record. Is there anyway to set

up
the
main document so that the chart changes according to

the
data for each record?


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
:-)

.

  #6  
Old June 16th, 2004, 05:38 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Inserting pie chart into mail merge document

Hi Vicki,

We have about 1300 records to merge
so I don't think we'll opt for the manual procedure. I am
interested in the 4th option, so please pass it on when
complete.

Uploaded to my website today.

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.