I have a Word document with three embedded Excel charts. I would like to have the data in one of the charts update to reflect what is changed in one of the other charts. Naturally, if this was just an Excel workbook, I could use =Sheet2!A4. I suspect I could use the name of the other chart, but I don't know how to obtain that. When I edit the data of a chart, the name of the file is simply "Chart in Microsoft Office Word."

I know that I could link the document to a single Excel workbook for all my chart needs, but I am trying to keep this all in one Word document.

This is in Office 2007.