Pareto Chart Maker for a Column of Raw Data in Excel

QI Macros will summarize your data and draw a Pareto in one click

If you have a column of raw data, like the text or dates below, you will need to summarize them using a pivottable before you can draw a Pareto chart.

pareto chart data examples


Here's How to Make a Pareto Chart Using QI Macros Add-in for Excel

  1. Make sure your column has a heading in the first row
  2. Click on the cell to select the heading
  3. Click on QI Macros menu and select Pareto Chart:
  4. QI Macros will create a pivot table and then make a Pareto Chart in seconds:

pareto chart example

Learn More...