Thankyou for the reply ...

I have managed to do it another way as i needed it to look as close to the chart as possible, I have now amended my mail merge data with a new column and a nested if statement in excel puts the file paths in matching the conditions i have set,

I then used macropod's example of field code to include a picture in the word mail merge.

{ include picture {if true"{MERGEFILED pupil_mins_lost_imagepath}" \d }

This works as intended!

Thankyou both for your help