How To Show Chart From Excel Sheet To SharePoint Web Part Using Excel Web Access Web Part

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.

  1. Go to Insert > Add a Web part.
  2. 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.

Ebook Download
View all
Learn
View all