How Do You Draw a Pareto Chart in Excel?

QI Macros for Excel draws eye-catching Pareto charts in seconds.

Quick Links:

What is a Pareto chart?

Why use QI Macros to create Pareto charts?

Special features of QI Macros Pareto chart maker.

I really like the QI Macros. The Pareto chart alone is worth the purchase price.

- Mike Dean, Ellwood Texas Forge


What is a Pareto Chart and what is it used for?

A Pareto chart is named after Vilfredo Pareto, an Italian economist and mathematician. Pareto first observed what we've come to know as the Pareto Principle (also known as the 80-20 rule). The principle states that a small percentage of any situations's causes directly lead to a large percentage of the results.

Pareto charts demonstrate this principle by combining a sorted bar graph with a line chart that shows cumulative percentages. Pareto charts help to pinpoint where you should focus your efforts for maximum benefit (i.e. on the big bars to the left that represent the largest percentage of the problem).

What makes an authentic Pareto chart?

  • Cumulative line graph with %'s
  • No space between bars
  • An "Other" bar

pareto chart created in Excel using QI Macros

QI Macros Pareto charts contain ALL of these critical elements.


Why use QI Macros to create Pareto charts?

save time

Save Time

You don't need to learn a separate application. QI Macros works right in Excel.

pareto diagram

Draw Charts in Seconds

QI Macros is point and click simple. Just select your data and then select Pareto chart from the tab we install on Excel's menu.

look like an expert

Look Like an Expert

Be ready to answer - "How did you do that?" QI Macros is one of the few software solutions that draws an authentic Pareto diagram. Beware of bar charts impersonating Paretos!

I have purchased your QI Macros and now amaze my friends and co-workers with the ease and speed of my Pareto charts and other stats.

— Bob Miller, Training Manager, SETECH, Inc


Special features that make QI Macros Pareto charts unique

  • Bars greater than 20% of the total are shaded.
  • Choose the # of bars you want. The rest of the categories are summarized into an "Other" bar on the far right.
  • Create multiple Pareto charts at once.
  • Draw a Pareto chart from raw text without needing to sort and subtotal your data.

Learn More...


More Reasons to Choose QI Macros Over Excel or Other Pareto Chart Software

affordable

Affordable

  • Only $279 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free