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.

 

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:

Learn More...

• Watch Video of Creating a Pareto Chart using the QI Macros
• Pareto Chart Template for Excel
• Three Pareto Chart Mistakes to Avoid