SharePoint chart using excel services

Sometimes there is a need to display chart embedded in excel sheet. SharePoint provides REST API for this. Here are the steps to display excel chart.

       

1.      Upload your excel file into the document library say “Shared Documents”.

2.      Add a content editor web part to the page where you want to display the chart.

3.      Now edit the HTML source of content editor web part and put below content



<img src="/_vti_bin/ExcelRest.aspx/Shared Documents/Book1.xlsx/Model/Charts('Chart 1')" alt=""/>​



Note: please verify the service by typing the url in browser something like

http://<your server>/_vti_bin/ExcelRest.aspx/Shared Documents/Book1.xlsx/Model/Charts('Chart 1')



“Chart 1” is the name of chart. You can set the name of the chart as follows:

a.       Open excel sheet.

b.      Click on the chart.

c.       Go to Layout menu. You will see the Chart Name box at the top right ribbon.



4.      Save the content editor web part. This should render your chart. For details about the REST API please follow Sample URL For Excel Services REST API