How to Draw Pareto Charts Using QI Macros

Pareto Chart Basics and Advanced Features

QI Macros Pareto charts contain all of the required elements plus some unique time saving features:

  • Cumulative line chart with percentages. Starts from top right corner of first bar.
  • Bars do not touch. Bars > 20% are colored.
  • Choose the # of bars you want - the remaining categories are summarized into an "Other" bar to the far right.
  • Create multiple Pareto charts at once.
  • Draw a Pareto chart from raw text data without needing to sort and subtotal first.
  • Draw a Pareto chart directly from a PivotTable.
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

Learn More...