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 in Excel created by QI Macros Add-in

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?

affordable

Affordable

  • Only $249 - less with quantity discounts
  • No annual 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

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free

QI Macros Pareto Chart Bonus Features

Shaded and "Other" Bar

Bars over 20% are highlighted.

highlight areas of focus

"Other Bar" groups small 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 or date 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...