How to make a Pareto Chart

Looking to learn how to make a Pareto Chart? You’ve come to the right place.

  1. First you must collect your data.
    • Data collection form
      • Choose categories.
    • If taking a sample, how much do you need?
  2. Organize your data
    • Sum categories
    • Arrange in Columns
    • Sort in order highest to lowest
  3. Make a bar graph
    1. Highest total to the left
    2. In descending order
  4. Create Cumulative percentage line
    1. Calculate the cumulative percentage of each category.
    2. Add a secondary axis for percentage.
    3. Graph a line chart on top


Also, don’t miss out on these resources.

  • How to Make a Pareto Chart in Excel
  • Download an Excel Pareto Chart template.
  • Learn how to do Pareto Analysis
  • Learn more about Pareto Charts
0 comments… add one

Leave a Comment