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.

Get more solutions from InfoPath 2010 Cookbook 5 which is available on Amazon.com
Watch next video: Get data from an Excel workbook attached to an InfoPath form

InfoPath demo video transcript:

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.

Related InfoPath Demo Videos:

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 of S.Y.M. Wong-A-Ton. 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, S.Y.M. Wong-A-Ton.

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services