Incorporating Graph into a mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mlipis - 29 Dec 2003 22:36 GMT

We're preparing statements of how much the company pays for benefits and how much each employee pays for benefits. We want to include a pie chart showing the proportion paid by the company vs. the proportion paid by the employee. The piechart must change from one record to the next because the values will be different for each employee

How can we incorporate a piechart into a mailmerge?????

Reply to this Message

Cindy M -WordMVP- - 30 Dec 2003 07:25 GMT

Hi =?Utf-8?B?bWxpcGlz?=,

> We're preparing statements of how much the company pays for benefits and how much each employee pays for benefits. We want to include a pie chart showing the proportion paid by the company vs. the proportion paid by the employee. The piechart must change from one record to the next because the values will be different for each employee.

Word does not provide any functionality for this. For a short discussion about what methods you can use, see

http://www.google.ch/groups?q=Cindy+Meister+Chart&hl=de&lr=&i
e=UTF-8&oe=UTF-8&selm=VA.000089f9.004eb867%40speedy&rnum=23

VBA automation can be used to "speed things up" for any of the three methods.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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

Reply to this Message

kaak - 30 Dec 2003 19:25 GMT

I solved this problem like this

I wrote a macro who generates the charts as a gif
ans save them in a directory.
Then you can include the gif in the merge.

Jeroen

------------------------------------------------

Reply to this Message

Rate this thread: