Weekly Sales Excel Dashboard
The following Excel dashboard highlights the month in focus with a light blue bar depending on the month shown in the drop down. You can see from the main dashboard chart that September is in focus so the bar shifts to light blue in September and all of the other charts in the dashboard change to reflect that month. I have created an article which outlines this feature at Change Bar Colour. The dashboard also has a traffic light setup below the main chart in the dashboard.
For a listing of all Excel Dashboards on the Smallman.com visit this link. There are more Excel files than you will be able to view!!
The following is the Excel dashboard which has been saved as an Excel 97-03 workbook. It should be quite easily adapted to include your information in the dashboard.