I ran across this post the other day. It's an old post but a cool concept for anyone creating dashboards in Excel. You can actually use some of the concepts in Microsoft Reporting Services as well.
http://chandoo.org/wp/2008/09/05/microcharting-excel-howto/
These guys have a lot of great ideas. I just stumbled across them for micro charting but many great Excel charting solutions.
You can go here to read a little more about microcharts and how to use them.
Click here to download a template I created based on one of the charts. As it exists today it will allow for 50 lines of data. To add more lines follow the steps below.