You will see a default chart Web Part similar to the one shown below. Step 3: Select ‘Business Data’ from Categories and ‘Chart Web Part’ from Web Parts and click on the ‘Add’ button: Click on ‘Insert’ and select a ‘Web Part’ as shown here: Step 2: You will see the ‘Editing Tools’ on the ribbon. Step 1: Browse to the site, and click on ‘Edit’: The Sales data in the workbook is as shown below: To achieve this task, the Excel workbook must be stored in the Shared document library of the SharePoint 2010 portal as below: Now this data is to be represented in a chart format without any hassles. Once they submit their worksheet to the office, the IT personal generates a consolidated worksheet where state wise sales data is stored. We can simply consider a scenario where various marketing personals are maintaining worksheets to record the sales information in it. Reading Data from Excel Workbook to Generate Charts using Excel Service In this article, we are going to discuss the mechanism of fetching data in SharePoint 2010 from Excel Spreadsheet using Excel Services. The Excel service is a part of SPS 2010 and built upon ASP.NET and SharePoint Foundation. One important feature of SPS 2010 is that if you have Excel worksheets in the document library, then using Excel Services, data from a specific range of the worksheet can be used to generate charts. In SPS2010, we have a set of services using which we can manage various operations needed for intra-organization automation like managing document library where Excel Workbooks, Word Documents, PDF’s etc can be stored. SharePoint (SPS) 2010 is a competent technology for managing contents like documents, spreadsheets etc. If SharePoint 2010 is used for such scenarios, then such complex solutions like these can be easily designed by developers or even the non-developer IT-staff in the organization, within no time. To achieve this, developers usually write a huge amount of complex code in Web Applications using concepts like ADO.NET or VSTO programming. Intra-organization portal users often need access to some form of Sales, Production or Revenue generation graphs or charts by directly querying Data Stores (persistent database like SQL Server) or even a spreadsheet like MS Excel.

Excel get data from sharepoint list