Excel Dashboard

Hi - I require an Excel 2010 Dashboard creating (must also work on Excel Mac 2011). This is a fairly blank canvas - I have attached an Excel file you can use as a template, it has a few worksheets which I will eventually populate with data, data includes dsProgrammeStatus, dsRisks, dsIssues, dsChangeControl. The master Worksheet which should hold the dashboard is called Dashboard. Quite simplay I require the Dashboard page to be an extremely clean, easy to read, impressive dashboard linked to the "ds" prefixed worksheets and include (from the top): - A dynamic table displaying the Programme Status (Programme Name, Status), the status should be coloured accordingly depending on the RAG value - To the right of the table there needs to be a pie chart showing the number of Programmes in each RAG status - Below the above - A Risks matrix. The attached example already has something in place. - To the right of the matrix a dynamic table with the top 10 Risks should be shown (the top 10 is based on Severity score). Note - The fact that the Matrix has different column widths shouldn't effect the table next to it or below. - A dynamic Issues table, top 10 - Next to which a Issue horizontal bar showing Issue Age. x axis less than one week, less than one month, more than 1 month, more than 2 months, more than 6 months. Y axis: number of issues - Finally a Change Control vertical bar chart showing the number of changes per Programme A strong use of colour should be used where necessary. The ds worksheets will be populated by the client when necessary and all of the charts, tables etc. should then automatically update. Please forward me a working example in order to be chosen - a quick turnaround is required (2 days max). If you can supply a semi working example straight away you will probably be awarded the project :) Thanks