Using Excel’s AutoRepublishing to Create SharePoint Charts & Dashboards

I have found a good article on how to use Office Excel's feature for publishing Chart in SharePoint @ EndUserSharePoint.

Multiple Pie Charts in a WSS Dashboard

I have found a good article on how to show multiple Pie Charts in a Dashboard.
Click here to see more...

Create a Pivot Table from a SharePoint List and Display it in SharePoint

Pivot Tables are a powerful capability of Excel, however MOSS now provides the capability to create a pivot table from data in a SharePoint list. This example will show you how to use a SharePoint list to create a pivot table and then display it back in SharePoint using the Excel Web Access web part.