MicroCharts in Excel

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.

How to use a Sharepoint list as a datasource for Microsoft Reporting Services

Step 1:

Create Sharepoint List that contains the data you would like to report against.
 Step 2: Once in SSRS:
     1. Create a new datasource
          a. Name – Name of datasource
          b. Type – XML
          c. Connection String – Home page of the Sharepoint site where the list exists.
               NOTE: After the name of the site remove the “default” and replace it with   <</_vti_bin/Lists.asmx>>
               http://<server>/<path>/_vti_bin/Lists.asmx

          d. Use Windows Authentication