Bulk Pie Charts - then merge into Word

[SausageRoll]

Hi all

I've got a query that I'm hoping someone will be able to help with. I think it's quite complicated so I'll try and explain as best I can...

I have a set of data that shows remuneration info for a group of employees. My overall goal is to create a merged Word document for each employee, with a merged pie chart as part of the document.

The data will look like this...

The first hurdle I need to jump is to automate the creation of a pie chart for each row of data. I want a pie chart for each employee, looking like this...

Once those pie charts have been created, I then need to work out how to include them in a merge across to Word. I have googled all sorts of solutions to this, but none seem to be quite what I'm looking for. Some explain how to create the individual pie charts by clicking on a row in the data (but I don't know how I can then transfer that over to a Word document), some mention creating each pie chart as an image, and linking to this in the merge, but I'm not sure how this would be done.

Does anyone have any ideas? Any help would be greatly appreciated!

Thanks