Overview
In this article, we will discuss how we can display a chart from Excel sheet to our SharePoint site as a web part.
We have received one requirement from one of our clients. They have already prepared some charts or reports in Excel sheet. Now, they want to display those Excel sheet charts to the SharePoint page.
They also want to refresh the chart as the data is changed. We have achieved this requirement using Excel Web Access Web part which is an OOTB web part of SharePoint.
Now, let’s start how to configure an Excel Web Access web part.
Step 1
Prepare an Excel sheet in a manner that every chart has a unique name.
Ex: The below Excel sheet has a bar chart. We can set its chart name in a Name Box of the sheet. If you observe, its name is “159T”. Make sure this name is used in the web part configuration step.
Step 2
Upload an Excel sheet to your SharePoint Online Library. Please refer the below screenshot.
Step 3
Now, add a Web Excel web part to your page.
- Go to Insert > Add a Web part.
- From Business Data, select Excel Web Access.
![]()
Step 4
Configure the web part. Click on “Click here to open the tool pane”.
Step 5
It will open a web part configuration setting page. In Workbook Display, select uploaded Excel file using Browse option.
Named Item: Type a name which we have set in Step 1 which is “159T”.
Click OK.
Step 6
Web part is added successfully.
If we observe its screen, we can see Toolbar of the web part on the screen.
View
It shows all graphs available in that sheet. But by default, it loads a web part that we have set in the configuration setting.
Edit in Excel
It will redirect us to the Excel sheet for editing.
We can also hide this toolbar.
To hide a toolbar, edit web part > Title Bar > type of Toolbar > None.
The below image shows an Excel Web Access Web part.
Conclusion
This is how we can create an OOTB Excel Web Access Web part.
Hope you like this article.