By using SharePoint excel services we can show excel
worksheets, graphs and charts in the SharePoint site. We can create the charts
and graphs by using excel power pivot. To create a chart in excel workbook, take
an excel workbook with sample data to create a chart.
Select Insert tab on the top, select Power Pivot button on
the top left as shown below.
We can see a window asking to create a Pivot Table. Click on OK button.
Name the Pivot table.
Select the fields to create power pivot report and drag the
fields in to Sum values column and Rows column to create a report.
Once done with the report, Select Insert tab and click on
the charts to insert the pie chart in excel sheet.
After creating the chart, Name the Chart. Here it is “Chart
1”
Save the excel sheet and upload it to SharePoint library.
Add Excel Web Access web part in the SharePoint page to show
the chart.
Click on the link “Click here to open the tool pane” to
specify the worksheet and chart details to the web part.
Add Excel worksheet in Workbook and Chart Name in Named Item
in the Workbook display settings of the Excel Web Access web part.
Click on “Apply” button. We can see the Chart in SharePoint
page once done with applying the settings. Click on “OK” button to save the settings.
Click on Save Page to save the page.
We have the options to change the view by changing the drop
down option on the right side.
