Update an Excel chart on an InfoPath form

In this InfoPath demo video you will see how you can display a chart from an Excel workbook on an InfoPath form and then enter data on the InfoPath form and dynamically update the Excel chart on the form.

In recipe 20, you'll learn how you can display and update a chart that is stored in an Excel workbook in a SharePoint document library from within an InfoPath form.

Here I'm in SharePoint 2010 where I've got this Excel workbook that contains a simple chart with these two values. What I would like to do is embed this chart on an InfoPath form and then dynamically update the data for the chart.

I've already published an InfoPath form template to this SharePoint form library. So if I click Add document to add a new form and then enter some data and click Update Chart, I should see the chart appear with the data that I entered.

I can change the data and update the chart again. And then you should see the updated chart appear. And you could continue changing the data like this.

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced
in any way without an expressed written consent. The techniques
demonstrated in this article may be used within any Microsoft InfoPath project.
This article is provided without any warranties. Copyright for this article is
non-transferrable and remains with the author.