Making Pareto chart using MS Excel is very simple, but you need to understand the concept and know few steps. I can assure that you will find it very easy and you will be using it very soon in your daily work life. So lets start, in step 1 just create the list of causes or defects with their frequency in an excel table.