How to Display Charts in SharePoint using Excel Web Access Web Part?

Requirement: Display Excel Chart in SharePoint Online web part page.

Show Excel Charts & Graphs in SharePoint Online

Excel Web Access web part in SharePoint Online can be used to display charts. To display the Excel sheet with charts in SharePoint: Create an Excel sheet with Chart data, select the chart and data area in your spreadsheet, and give it a name. E.g., “ChartData”.

Excel named label

Upload the spreadsheet to any document library on your SharePoint site. Now, add a web part page to display the Excel sheet. Here is how:

  1. Go to your SharePoint Online Site in the browser >> Site Contents >> Pages Library.
  2. Create a new Web Part Page and insert a web part.
  3. Under the “Business Data” category, select the “Excel Web Access” web part and Click on “Add”.add excel chart to sharepoint online
  4. Now, edit the web part properties of the Excel web access >> Browse and select the spreadsheet from your document library. Enter the “Named Item” you created in the spreadsheet. You can adjust the height and width of the web part according to your requirement.Excel Web Access Webpart In SharePoint
  5. Finally, the spreadsheet with charts will be displayed on your SharePoint page.

You should see the chart from the Excel workbook!

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

Your email address will not be published. Required fields are marked *