Pareto Chart template

I've been gone a while working on a new template.  This one is will allow you to import or enter data into an excel spreadsheet and create a pareto chart.  I also wrote an article about how/when to use a pareto chart

Simply enter (or import) data into columns A and B.  A should be your data to group by and B should be the values.  No need to sum the data prior to importing it.  The tool will do that for you.  Please check it out.  Let me know if you find it useful.

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.