Pareto Chart Advanced Features in QI Macros

Save time and headaches with these unique functions.

anatomy of a pareto chart

Here's How to Create a Pareto Chart in Excel Using QI Macros

1. Select Your Data

pareto data example

2. Click on Pareto Chart

pareto chart on qimacros menu

3. Input # of Bars

define number of bars on pareto chart

 

QI Macros Does the Rest

pareto chart

How to Create Multiple Pareto Charts With One Click

1. Select Your Data

sample data to create multiple paretos

Data should share the same categories (col A)

2. Click on Pareto Chart

pareto chart on qimacros menu

3. Input # of Bars

define number of bars on pareto chart

 

QI Macros Does the Rest

create more than one pareto

How to Create Pareto Charts on Raw Text Data Not Yet Summarized

1.Select column heading

unsummarized text data

Make sure the column has a heading. Click on the heading (i.e. B1).

2. Click on Pareto Chart

pareto chart on qimacros menu

3. Input # of Bars

define number of bars on pareto chart

 

QI Macros Does the Rest

pareto from text data

Create Paretos Directly From a Pivot Table

1. Select Labels and Data

pivot table example

Use the Ctrl key to select non-adjacent columns. Don't select the total.

2. Click on Pareto Chart

pareto chart on qimacros menu

3. Input # of Bars

define number of bars on pareto chart

 

QI Macros Does the Rest

nested paretos


Watch How to Draw Pareto Charts using QI Macros