The Office Web Components for SharePoint, among other things, allow you to connect SharePoint list data to common Excel components which use ActiveX technology to provide a rich user interface in IE. If a user has Office 2003 installed they can also interact with the component.
Because of IE security and activex requirements, users should have the SharePoint site in their IE Trusted Sites zone for this to work.
In this article I'm going to demonstrate how to chart the results of a question in a survey list.
After you have installed the Office Web Parts you should be able to follow these steps:
- Open ad Web Part page and add the Office PivotChart component from the Virtual Server Gallery
- Click on the "Connect to an external data source" link in the web part.
- Add a new data connection & select Data retrieval services
- Select Windows SharePoint Services lists
- Type in the URL to your site (browsing the sites lists requires more than anonymous access so you will not be able to use wssdemo.com for your use) and then select the list you wish to retrieve data from.
- Select the columns you with to retrieve
- The next couple of screen will let you specify sort and filter conditions
- This next step is most important. It is selecting the location to store the data connection information. This must be a location that is accessible to users who will view the web part. A logical location for this on a SharePoint site is a document library which is what I have used in this demo (assuming that your data connection doesn't store a Username/Password, this is why integrated security is so good).
- Finish the wizard