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 below, you will need to summarize it using a PivotTable before you can draw a Pareto chart in Excel. Fortunately, QI Macros add-in for Excel is smart enough to do this for you.

How to make a Pareto from a column of text

  1. Make sure your column has a heading in the first row. Then click on the cell to select the heading:

    2. example of text data

  2. Click on QI Macros menu and select "Pareto Chart":

    3. pareto on menu

  3. If you have more than 9 categories you will receive a prompt asking you about the number of bars you want:

    4. number of bars prompt

  4. QI Macros will create a pivot table and then make a Pareto chart in seconds:

    5. pareto from text

Learn More...

Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now