What is Pareto Chart?
Wilfredo Pareto is the father of the Pareto chart. Pareto chart is used for analyzing the impact of poor quality process, so that we can focus step wise on how to improve the quality. It is an advanced type of chart in Excelwhich is the combination of two charts i.e. Line Chart and Column Chart.
Before preparing the Pareto Chart we should understand about the Line chart and Column Chart individually, so that we would be able to understand the role of every chart.
Line Chart: – Use this chart type to show the trends over time (years, month, and days) or categories.
Column Chart: – Use this chart type to visually compare values across a few categories.
Where can we use Pareto chart?
You can use a Pareto chart to analyze every problem.
1.You can use Pareto chart for transport business.
2.Use to find out the problem in working area.
3.You can use in business analyses.
How to make a Pareto chart?
Let’s take an example and understand, how can we prepare a Pareto chart
I have School Complaint’s data in the range A3:B13. In which column A contains the type of complaints, and column B contains the no. Of complaints.
To create the Pareto chart we have to do Pareto analysis, follow below mentioned steps:-
Conclusion:- In the snapshot you can see how the Pareto chart performs to analyze the problems. The chart is showing that 80% complaints come from the Broken Benches, Fans not working, and Bad Atmosphere, high donation, school buses not clean, and unfriendly staff.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us @ email@example.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.