Thanks for the reply Paul,

The Excel file has the graph as the first sheet, with the data that it comes from on the second. There are a couple of text boxes and lines placed over the top of the graph but it would probably be ok without them, I could alter the template to remove them if necessary.

There's something that could probably be used to identify the Excel files in cell A1 of the data sheet, it's a constant [surname] [forename] [admission number]. Nothing in the report to match it at the moment but I could easily set it up to have the same thing on the first line and use white text to hide it.

Currently the Excel and Word documents are kept in completely different locations but that's open to be changed if it makes things easier - the next set of reports aren't due for a couple of weeks so I can just set it to create both documents in the same folder when that comes round.

Unfortunately I don't have much experience with macros/vba beyond using other peoples' code and trying to work out what it's doing (that's why I was hoping a mail merge could do it!), guess 2 weeks gives me some time to look at it though