Add Live Chart to SharePoint with Excel Web Access Web
Part
A SharePoint Online Exercise by Peter Kalmström
The
Excel Web Access web part, which is available for the Office
365 E3 and E6 subscriptions, is used to display live Excel
charts on a wiki or web part page.
You can display all or just a part of an Excel sheet in
this web part.
In the demo below, Peter Kalmström, CEO and Systems Designer
of kalmstrom.com Business Solutions, shows how to use the
Excel Web Access web part.
Add an Excel Web Access web part with Excel content
to SharePoint
In Excel, create a pivot table that contains the
data you wish to show in SharePoint.
Create
a chart from the new pivot table.
Save the spreadsheet to a document library in the
SharePoint site where you wish to add the chart.
Add an Excel Web Access web part to the SharePoint
page.
Connect the web part to the spreadsheet in the SharePoint
library.
You can continue updating the Excel file either in Excel
Online or in the client version of Excel. If you just change
the chart, it will be updated in SharePoint when you save
the file.
If you change the data in the Excel table, you must refresh
the chart under the Analyze or Data tab. Under the Data
tab you can also click on the Connections button and then
Properties and check the box for 'Refresh data when opening
the file'.