The Chart web part is shipped with SharePoint Server 2010 – Enterprise. It can be used to visualize your data with a variety of types of charts (bar graphs, pie charts, etc). This video shows how you can use this web part to visualize data in an excel spreadsheet through Excel Services.

This video shows how you can publish spreadsheets using Excel Services which comes as part of Microsoft Office SharePoint Server – Enterprise. Then a Dashboard is created using the figures in the published Excel Spreadsheet and filter web parts are implemented to filter information on the Dashboard page.