Create Pareto Chart in Excel!!!

Watch the video - How to create Pareto in Excel!

Before we start first we should understand what Pareto Chart is.

Pareto Chart is based on the Pareto principle (also known as the 80/20 rule), which is a well-known concept in project management.

According to this principle, 80% of the problems are due to 20% of the issues.
If we control these 20% of the issues, our 80% of the problems will be reduced/removed. .

How To Create Dynamic Charts/Graphs!!!

Watch the Video - How to create Dynamic chart in Excel.

 

Let say we have the data table as above and we have created a chart below: