I’ve been lurking over at OpenXMLDeveloper.org, answering questions. A fairly involved question came up recently, which is: If you have an embedded chart in a word-processing document, how do you update the data behind the chart? As it turns out, you have to update the data in two different places. You have to update the data in the embedded spreadsheet, and you have to update cached values in the word-processing document.
I’ve written a post on OpenXMLDeveloper.org that contains example to update the data and update the cached values. In addition, I recorded the following screencast, which walks through the process: