SharePoint chart using excel services
Feb 10, 2012

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.

Prakash Software Solutions PVT LTD. Offer wide range of services to their clients all over the globe. We successfully delivered projects i.e. software development, cloud computing solutions, SharePoint development solutions, mobile app development and Microsoft technology solution to our Sweden, Denmark, Netherlands, France, Norway, Germany, Spain, Italy, Switzerland, Belgium, Luxembourg, Ireland, United Kingdom, United States, Canada, Brazil, Peru, UAE, Dubai, Saudi Arabia, Kuwait, Qatar, Bahrain, Singapore, New Zealand and Australia Clients.


Leave a Reply

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


Related Posts

“Cannot complete this action” error while saving site as template

Today while trying to save a site as template (through “Site Settings” >…

May 18, 2012

“There is not enough space on the disk” error while exporting SharePoint site

Today while trying to export a large sub-site using Export-SPWeb command through powershell, we got…

May 16, 2012

Full trust proxy in SharePoint sandbox solution

You know that sandbox solution in SharePoint 2010 has certain limitation like: It…

Oct 20, 2012

Copyright © Prakash Software Solutions Pvt. Ltd. All Rights Reserved.