Easy Pareto Chart in Excel

Easy Pareto Chart in Excel


This Pareto chart is easy and looks great. Save your time and get this template.



A Pareto chart is a special type of bar chart where the values being plotted are arranged in descending order. The graph is accompanied by a line graph which shows the cumulative totals of each category left to right. The chart is named after Vilfredo Pareto and its use in quality assurance was popularized by Joseph M. Juran and Kaoru Ishikawa.

The Pareto chart is one of the seven basic tools of quality control which include the histogram Pareto chart check sheet control chart cause-and-effect diagram flowchart and scatter diagram. See glossary of quality management. These charts can be generated in MS office or Open office tools without difficulties. It is possible to use one of the software tools or one of free “online quality chart generators” as well.

Typically on the left vertical axis is frequency of occurrence but it can alternatively represent cost or other important unit of measure. The right vertical axis is the cumulative percentage of the total number of occurrences total cost or total of the particular unit of measure. The purpose is to highlight the most important among a typically large set of factors. In quality control the Pareto chart often represents the most common sources of defects the highest occurring type of defect or the most frequent reasons for customer complaints etc.

Information extracted from Wikipedia


What do I get?

  • Download Your File: First, as soon as your payment is confirmed, you will receive a download link via email where you can download your template right away.
  • Online Tools: You also get access to Construction Office Online and our powerful tools designed to help you advance in your business. Your membership includes access to helpful videos and announcements of the latest templates.
  • Community Forum: Our community forum is growing because of people just like us. This powerful tool enables you to get questions answered quickly, give input on new ideas or templates, and get feedback by other users doing business just like you. By the way – If your ideas are published in a new template or even to update an existing template, you get the template for free!

NOTE: Make sure ConstructionOfficeOnline.com is listed as a safe sender with your anti-spam settings.


Here are some features you might appreciate about this template:

  • Many of the calculations are automated
  • Simple to use (the hard work of setup is already done)
  • Saves time and Looks Great
  • Use this template over and over.
  • Easy to customize for your specific needs


These templates are in Word and Excel format for Microsoft Office for PC or Mac.  Some of these templates come with PDF versions.  These are for printing and entering information by hand.  All PDF template files accompany actual Word or Excel templates you can configure.

You will need one of the following software applications to use this template:

NOTE: Some features, formulas, and or function may not work outside of Microsoft Excel and may need adjustments.