Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with charts.
I'm creating a mail merge in Word, using a large Excel data source. The
file contains multiple names, with various associated data. I want to create an individualized chart for each name, using data associated with their name in the Excel data source file. One customized chart per name, merged into the Word document. Can this be done. I cannot figure out how to merge data into a chart.--- or is there a better way? Please help if you can.. |
#3
|
|||
|
|||
Tushar Mehta wrote: In fact, the only solution I can think of is rather complicated. It would involve creating a mail merge document with the chart showing some arbitrary data. Once the merged document is ready, a macro would then go through the document and update the charts to contain the correct data for each individual. At this point one could print the document, separate the pages, and distribute them to the appropriate individuals. And then having to use a macro, I'd dispense with the whole mail merge thing, and directly make each Word document from a Word template, using Excel VBA to put the appropriate information into the appropriate spaces in the document, create the chart with the correct information and move it into Word, and save the document. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ |
#4
|
|||
|
|||
Hi Jon,
I thought of dispensing with Word mail merge altogether but that would require duplicating its capability and I did not want to reinvent *that* wheel. {grin} -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... Tushar Mehta wrote: In fact, the only solution I can think of is rather complicated. It would involve creating a mail merge document with the chart showing some arbitrary data. Once the merged document is ready, a macro would then go through the document and update the charts to contain the correct data for each individual. At this point one could print the document, separate the pages, and distribute them to the appropriate individuals. And then having to use a macro, I'd dispense with the whole mail merge thing, and directly make each Word document from a Word template, using Excel VBA to put the appropriate information into the appropriate spaces in the document, create the chart with the correct information and move it into Word, and save the document. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ |
#5
|
|||
|
|||
"Jon Peltier" wrote: Tushar Mehta wrote: In fact, the only solution I can think of is rather complicated. It would involve creating a mail merge document with the chart showing some arbitrary data. Once the merged document is ready, a macro would then go through the document and update the charts to contain the correct data for each individual. At this point one could print the document, separate the pages, and distribute them to the appropriate individuals. And then having to use a macro, I'd dispense with the whole mail merge thing, and directly make each Word document from a Word template, using Excel VBA to put the appropriate information into the appropriate spaces in the document, create the chart with the correct information and move it into Word, and save the document. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ok.... if it is going to be a lengthy process... where can I find out how to use macros? |
#6
|
|||
|
|||
Yeah, but it'd be a round wheel this time, without corners.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tushar Mehta wrote: Hi Jon, I thought of dispensing with Word mail merge altogether but that would require duplicating its capability and I did not want to reinvent *that* wheel. {grin} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Change Fonts In Multiple Charts in a Workbook? | Charts and Charting in Excel | |||
Charts won't update | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel |