- Change the file extension to ZIP
- Look inside the ZIP file with Windows Explorer or another suitable tool as described in other blog posts.
- Inside the "word" subfolder there is a folder named "charts". It contains XML data with all the chart headings, numbers and labels. Copy it.
- Paste a copy of the folder where you want your source files. Import the chart XML files into any CAT tool or XML editor. It's a good idea to configure a filter to exclude and protect the references to the original Excel files with the data. (Though I am curious whether deliberately spoiling these data can protect against the unwanted update that one person worried about in the comments. I'll have to try that.)
- When the translations are completed, paste the XML files back inside the charts folder in the file structure.
- Rename the extension back to what it was at the start (DOCX in this case). You're done. No refresh necessary (unlike with embedded Excel or PowerPoint objects).
A memoQ filter configuration for these XML files can now be found on Kilgray's Language Terminal.