How to use SharePoint 2010 Chart web part with Excel Services

In this post, I will show how to use SharePoint 2010 chart web part with excel services to display various charts. Firstly we need to configure excel services on the SharePoint server.

To use excel services with chart web part, we need URL of the excel document and range of spreadsheet. Once we have these things, edit the page and insert chart web part to it. Click on Data & Appearance and then Connect Chart to Data.

Choose Excel services then screen with display and fill the excel workbook path and range of spreadsheet.

Excel web service URL should be already filled.

Excel workbook path: SiteURL/Shared%20Documents/Sales.xlsx

Range: Sheet1!$A$1:$B$6

Then click next.

Keep the default setting for remaining pages and then click finish.

Final output will be