In case it might be useful, here's a very handy template in Excel on Office.Microsoft.com. (I didn't know they had this, and could have done with it a while back.)
From 404techsupport.com: Using Microsoft Templates to perform Pareto Analysis easily in Excel
From 404techsupport.com: Using Microsoft Templates to perform Pareto Analysis easily in Excel
Quote
...
This post is as much about using templates in Excel as it is about Pareto charts. They just make a good example because they are more complicated than the typical charts used in Excel. Fortunately, Microsoft Office has a template online that can easily be used.
On Office.Microsoft.com, Templates can be found that have been created by Microsoft or others that accomplish frequently used tasks. You can find the Pareto Analysis template at http://office.microsoft.com/en-us/templates/pareto-analysis-TC030001551.aspx
...
