Re: Updating Charts in a PPTX template

We don't have a usermodel API to work with charts in PPTX. You took
the right approach because direct manipulation with low-level xml
beans is the only way to do that.

On Thu, Dec 1, 2011 at 8:50 AM, Kerwin <kerwin747 <at> gmail.com> wrote:
> Hi All,
>
> I have a PPTX template with multiple charts as placeholders that need to be
> updated with data.
> I could not find documentation on how to update a given chart in a PPTX
> file directly. I have written some code below to be able to do this. Could
> you please let me know if this is the best way to update multiple charts in
> a PPTX file?.
> I essentially read the chart.xml and then read the related embedded Excel
> package. I am successful in reading the chart.xml but cannot read the
> embedded excel XML accurately as I could not find methods to differentiate
> the series and values using getsheetdata(). If I use XSSF I am able to
> update the excel but when I click on the sheet and return to the chart the
> additional series added is removed. Please suggest any better way to
> update the chart.
>

There can be many reasons why the added series is disappearing. Most
likely you don't update all the required xml bits.

Open the template with chart placeholders in PowerPoint and update the
data.  Then unzip the updated file  and compare it with the source
template and with a file updated by your code. This way you can figure
out what you missed .