80 20 RuleNeed a Pareto diagram to separate the vital few from the trivial many?

  • Types of defects
  • Customer complaints types
  • Kinds of injuries in a plant
  • Reasons for returned goods
  • Downtime reasons
  • Types of infections in a hospital
  • Reasons for late deliveries


Watch a Video Highlighting How to Make a Frequency Pareto Diagram

Join the thousands separating the "vital few" from the "trivial many" using SPC for Excel

Buy SPC for Excel Download Free Trial

Pareto Diagrams and SPC for Excel

Our SPC software, SPC for Excel,  easily creates Pareto diagrams - a great visual way to separate the vital few from the trivial many.  There are three Pareto options:

  • Frequency - totals the frequency of occurrence by category (e.g., number of returns by product)
  • Defect - totals reasons for defects (e.g., reasons for customer returns)
  • Variables - totals frequency for categories for different levels of a variable (e.g, defects by shift) 
  • Two-Level - creates a two-level Pareto diagram (variable -defect)

Pareto Diagram Features

  • New data easily added
  • Data can be in rows or columns
  • Turn cumulative line on or off
  • Add dates of data collection
  • Option to create other category for frequencies below a certain value
  • Format changes maintained when Pareto diagram is updated
  • Option to color the vital few 
  • Option to set the gap between the bars

Have Questions? Contact Us

SPC for Excel

SPC Knowledge Base

subscribe button

Sign up for our FREE monthly publication featuring SPC techniques and other statistical topics.

Customer Stories

Click here to see what our customers say about SPC for Excel!

SPC Around the World

SPC for Excel is used in 80 countries internationally.  Click here for a list of those countries.


Connect with Us