How to plot Pareto chart using Excel Sheet with Common Example.

We all know that Pareto is very important Quality Control tool.
It is used for the prioritisation for the selection of Vital few elements among many.
Pareto is a combo chart of bar and Line. Bar shows individual contribution of each element in descending order and line shows cumulative percentage of all elements.
It is based on 80-20 Rule.
After plotting Pareto, we could focus on vital few element for improvement.
Let us see how to plot Pareto by using excel sheet with common example.

[@arunprakash6318]

very clear. thank u so much mam. Now very clear with drawing pareto using excel.

[@sravanpavan1696]

how to make cummulative line to intersect the corner of the first bar

[@vickygs8125]

Thank you 😊

[@arunprakash6318]

Can u please show us an example for comparison of pareto in cycle time reduction...

[@shashankkaple6541]

For cycle time reduction, we have to use ECRS technique

[@ansumanmishra4722]

Hi mam is it necessary to give no gap between the bars?

[@shashankkaple6541]

+ANSUMAN MISHRA it's not necessary.. we are doing because it is tradition.. some people think that it gives visual difference between two parameter.

[@shashankkaple6541]

It is not mandatory...we are doing as traditionally it was followed.

[@vishnuraj7797]

Good, but unable to see excel

[@nileshpujari246]

Good.... but The video is not clear.

[@shashankkaple6541]

it depend on internet connection. I find HD version

[@shashankkaple6541]

please see Hindi version