Pareto Chart in Excel

Use a Pareto Chart to Focus Improvement Efforts

The pareto chart combines a sorted bar graph with a cumulative line graph. The bars are placed from left to right in descending order. The cumulative line graph shows the percent contribution of all preceding bars. Often, two or three "big bars" represent most of the problem (80/20 rule).

QI Macros Creates a Pareto Chart in Three Easy Steps

draw pareto chart in excel

  1. Point - select your data in Excel
  2. Click – on the QI Macros menu and choose the Pareto Chart
  3. Analyze and Improve –the QI Macros will do the math and draw the Pareto chart for you. Any bar that represents more than 20% of the total will be shaded.

QI Macros Pareto Chart Example

pareto chart excel

Advantages of Using QI Macros to Create a Pareto Chart vs Doing It Yourself in Excel

Excel Pareto Chart

Creating a pareto chart in Excel requires some wizardry

  1. the creation of formulas for the cumulative line graph;
  2. the creation of the line-column chart;
  3. adjustment of the scale of both axes;
  4. changing the color of the chart.

When you are done you will have a "pareto chart" that looks like the one below:


 

 

 

pareto chart drawn in excel is missing cumulative percentages

Excel's plot area is gray; the bars have spaces between them; cumulative line starts in the middle of the first bar instead of bottom left corner. And you can't read the cumulative percentages off of the line.

QI Macros™ Pareto Chart

It's easy to create a pareto chart in Excel using the QI Macros:

  1. Just click and drag over your data to select it
  2. then click on the QI Macros menu and Pareto

pareto chart data in excel

The QI Macros will perform all of the calculations and Excel formatting and will draw the pareto chart for you. pareto chart excel

Bars touch; bars over 20% are highlighted with color; axes are scaled correctly; cumulative percentages are shown on the line graph.



I really like the QI Macros. The Pareto chart is worth the purchase price of the whole deal.

— Mike Dean, Ellwood Texas Forge

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

Learn More...

To create a Pareto Chart in Excel using the QI Macros...
Try It Now!

How We Can Help Download Free QI Macros Trial Buy QI Macros for Excel Now