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
- Make sure your column has a heading in the first row
- Click on the cell to select the heading
- Click on QI Macros menu and select Pareto Chart:
- QI Macros will create a pivot table and then make a Pareto Chart in seconds: