Hi Community, I'm really stuck on a challenge I'm facing at work. I'm a teacher in a school. After a series of end-of-term exams, management wants pupils to receive a bespoke report showing how they did individually. This is easy enough to knock together in Word-Excel-Mailmerge--> Letters. However, they also want a box&whisker plot per exam, individual to that pupil. It would ideally be something like this:

Student name: Student number

Subject 1: score: rank : [box & whisker plot to show relative position].
Subject 2: score: rank : [box & whisker plot to show relative position].
Subject 3: score: rank : [box & whisker plot to show relative position].

Can VBA help me achieve this on a mailmerge --> Letter?

Thank you for your consideration. In hope!!

Joe