It has been long since I wrote something. The last two months have been crazy with the academic stuff going on.. Finally got some time to create a new template.
Consultants love pareto charts. They use it in many of their presentations telling which 20% of the data we need to concentrate on.. It could be suppliers, distributors, customer segments etc.
Or take another case. A group of consultants would have shown your boss a pareto charts and the boss would ask you to generate it on a monthly basis. To make this process easier, I was thinking why not automate the entire process in such a way that you just enter your data and it spits out a graph well formatted so that you can put it directly to your slides.. (may be change the colors..my color preferences does not seem to be that great..)
Attached is a template which can help you in automating this entire process. As always..I have tested it for multiple scenarios.. but there might still be some errors. Please do let me know if you find any issues and I will try my level best to fix it.
The template file can be downloaded from the following location:
Pareto Charts