I am creating 20 individualized reports for students, using Word 2007. One page of the report is a bar chart that reports the student's individual scores on four different tests, alongside the respective bars that indicates the class average for that test. I know how to the class averages for each of the four tests.

Here's my quesition: how do I mail-merge the student's individual scores from each of the four tests onto the respective bar? Thus, I want to produce 20 different reports, with the bar chart showing four different scores that are customized for each particular student's report.

I already know how to mail-merge data from Excel onto a Word document. But I do not know how to merge data onto a specific bar in a bar chart.

Thanks for your help!
Dr. Rosebush