I've had plenty to read these last couple of weeks. I use Google Reader to receive my daily/weekly dose of reading and I found this fascinating (presently expired) challenge in Chandoo's Blog.
Chandoo has generously provided us with a well-laid out table which I wanted to keep in the dashboard. Option buttons at the end of the rows will allow the user their pick of the product and once clicked, it will shade the row selected and update two charts with the necessary values.
The first chart will plot quantity sold and per unit revenue for each month, while the second will portray the total revenue earned each month for the product and the percentage change in revenue from the previous month. The file contains no macro.
After some playing around, the dashboard is prepared as shown in the picture below.