Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of the causes. It will significantly improves the affected area and you will see good results.
For Example: 80% of the revenue gets generated by 20% of the clients
While doing research Mr. Pareto found that 20% of land in Italy was occupied by 80% of the population. He carried out this survey to other areas and got same results
This rule is also well known as 80/20 rule across the globe and is mostly being used to find the causes which is impacting business or producing defective products/services
Hence Pareto chart is a graphical representation of Pareto Principle
Pareto Chart studies the frequency distribution and advise you the most impacted/affected areas. So you should use Pareto Chart when:
Here are few steps to collect data before you start preparing your Pareto Chart in Excel:
Here I collated the Complaints data from one of the Courier Company survey and will create Pareto Chart for them. Lets follow the steps now:
So here your Pareto chart is ready. This will help you to showcase the major pain areas or impacted areas in visual display
Now if you want to make this chart more appealing and visual. Then you can do this by learning tricks about formatting charts.
Hope you liked this article. Please comment below for any questions and for your feedback about this tutorial.
Follow us by Subscribe Us option for new updates
VBA to Browse Outlook Folder Outlook is most commonly used emailing application used in the world. Many people spend their entire day on Outlook applications to read and respond to emails. To automate certain rule-based…
How to Hide Ribbon &Formula bar in excel? While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and…
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…
This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.
How to Find Duplicate Files In excel using VBA? Yesterday I was working on my computer and cleaning the drives to make some more space. I was surprised to see so many files saved at…
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.
I really liked this article. Well drafted. Thanks for the help 🙂