View Single Post
 
Old 03-13-2019, 02:10 AM
retro retro is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2019
Posts: 4
retro is on a distinguished road
Default Word mail merge with unique charts

Hi there,
I'm trying to create a mail merge where each document contains a bar graph based off a value, seems a really simple task but I don't think its achievable.

I did find one helpful post (https://www.msofficeforums.com/mail-...cel-graph.html) where user macropod briefly explained to use field codes, the demo works but information is lacking online.

I currently generate these letters using a PHP script outputing them as PDF files but it would make life so much easier if i could convert this as a mail merge, the only thing stopping me is the chart.

My current chart setup is based on
"Name"
"Number of Minutes Lost"

Some students have values of 15 minutes lost, 189 minutes lost all the way up to 3989 minutes lost



The green bar is average for the year

Any advice would be greatly apreciated!

Last edited by retro; 03-13-2019 at 03:05 AM. Reason: image example upload
Reply With Quote