What is a Pareto Chart?

Paretos combine a sorted bar graph with a cumulative line graph.

Pareto charts are used in Six Sigma and other process improvement methodologies to determine where to focus your efforts. Pareto analysis is based on the principle that one or two "big bars" represent the bulk of any problem (the 80/20 rule).

Here's an example of a Pareto chart created using QI Macros Add-in for Excel

pareto chart created in Excel using QI Macros

Creating a Pareto Chart in Excel is
Complicated and Time Consuming!

Here are Some of the Steps:

  1. Sort the data in descending order,
  2. Calculate the cumulative percentage,
  3. Create a column chart of the sorted data.
  4. Create a line graph of the cumulative % on a second Y Axis.
  5. Lots of formatting: format axes, data series, data points, grid lines, etc.

Why Struggle? Save Time by
Creating a Pareto Using QI Macros

QI Macros adds a new item to Excel's menu:

qimacros on excels menu

To Create a Pareto Chart:

  1. Just select your data
  2. Click on QI Macros menu and choose Pareto
  3. QI Macros will do the math and draw the chart for you.

Sample Pareto in Excel
excel pareto chart

Watch QI Macros Create a Pareto
create a pareto chart using QI Macros add-in for Excel

I really like the QI Macros. The Pareto chart alone is worth the purchase price.

- Mike Dean, Ellwood Texas Forge

Why Choose QI Macros Over Excel or Other Pareto Chart Software?



  • Only $249 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free

QI Macros Pareto Chart Bonus Features

Shaded and "Other" Bar

Bars over 20% are highlighted.

pareto highlights areas to focus on

"Other Bar" groups small categories

pareto other bar groups misc categories
Multiple Paretos at Once

Create a separate Pareto chart for each column of data.

create more than one pareto at a time


Draw Pareto from Raw Data

Data not subtotaled? No problem.

raw pareto chart data

QI Macros counts each phrase and draws a Pareto chart in one step.

I have purchased your QI Macros and now amaze my friends and co-workers with the ease and speed of my Pareto charts and other stats.

— Bob Miller, Training Manager, SETECH, Inc

Learn More...