How to add a Live Chart to your SharePoint Page

The Excel Web Access web part, available for the Office 365 E3 and E6 plans is used to display live Excel charts on a SharePoint Wiki Page or a web part page.
You can display all or just a part of an Excel sheet in this web part.
Watch our SharePoint Expert Demonstrate this key feature!
Please visit our website at mydock365.com/ to learn more about how Dock for SharePoint can improve your team's collaboration and communication.

[@DiegoSilva-ui7dy]

Thank you. very professional. Help me a lot . regards Diego

[@mcdonan5144]

Thank you!

[@frebhb]

Do you have an update that says how to do this with the new version of SharePoint? MS's site still has instructions that match yours, but I don't have classic view.

[@WaliSayed]

How can I create a live chart using a view? I want to show it on the first page.

[@Run4itForever]

So can the Excel sheet link back to a sharepoint list and thus be live data?

[@Dock365]

Hi! Yes, of course, you can do that. First of all, add all your data inside a table on your excel sheet. Now in SharePoint Online, select the below options to link the Excel list to the SharePoint list: Select New > List > Create a new list name > Then, select the excel sheet list to be linked, by clicking on the upload option or by selecting the excel sheet from the document library > now the excel sheet list will be displayed > Next, you can set the column types as needed > Click Create option. Definitely, all your data on the excel sheet list will be linked to your SharePoint list. Finally, your excel sheet data will be live on your SharePoint list.

[@Run4itForever]

@@Dock365 I have created a connection between my Excel file and the SP list, but the web part doesn't automatically update when the list is updated. Rather, I have to open up the Excel file, refresh the data, save the file back to my SP library, then refresh the page the web part is on.

[@Dock365]

@@Run4itForever Hi, you have to configure Refresh control for the data fetching. This is a common scenario. After that, you can display the data using the Excel Web Access web part.