How to Create a Dashboard in Excel 2007

1. Log on to your computer and open Microsoft Excel 2007. Open the spreadsheet you want to upload.
2. Click on the Office button and choose 'Publish' from the list. Choose 'Excel Services' from the list and choose 'Distribute the document to other people'.
3. Enter the URL of your website, followed by the name of the file, in the 'File name' box For instance, if you are saving a document called spreadsheet1 to the site xyzcorp.com/reports, you would type 'xyzcorp.com/reports/spreadsheet1.xlsx' in the 'File name' box.
4. Click 'OK' and choose 'Save'. In the 'Document type' box choose 'Reports'.
5. Go to the site where you want to add the spreadsheet and choose 'Site actions'. Choose 'Edit Page' and then 'Modify shared web part'.
6. Click 'Workbook' and then choose 'Select a Link'. Navigate to the workbook you want to add to the dashboard and click 'OK'.