In this demo the kalmstrom.com CEO Peter Kalmstrom shows how to embed a
live Excel graph on a SharePoint site. It is done with the help of Excel Web Services, which is included in the SharePoint 2010 Enterprise license and also in the more advanced Office 365 licenses.
As example Peter has chosen a model that shows how much revenues in dollars change when sales increase ‒ or decrease ‒ with certain percentages, and he starts by creating that model in Excel 2010.
When the model table is finished Peter also makes a graph of the data, to show the changes in a clearer way.
Save to SharePoint
In the next step Peter saves his model table and graph to the company’s SharePoint site, so that people who don’t use Excel also can see it.
Display on SharePoint homepage
Maybe you even want to display it to all employees on the intranet homepage?
Peter shows how to do that also.