Can Word use variable data in charts?

1

1_Martin

I have a fairly complex mail merge where the Excel file contains data to be
turned into a variable bar graph. Is Word 2007 able to do this? Thanks in
advance.
 
D

Doug Robbins - Word MVP

See the Mailmerge to a Chart item on fellow MVP Cindy Meister's website at:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Personally however, I use a "roll-your-own" VBA substitute for mailmerge
that uses a template containing docvariable fields in place of a main
document with mergefields and contains a chart linked from the Excel
spreadsheet. The individual documents are created by vba code that iterates
through rows of the Excel data source, setting values of the variables in
the document and updating the Excel chart with the data for each record in
turn.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top