Problem Solving with the Box Plots

I was working with a client recently to solve problems with rework and scrap. One of the improvement teams manufactures a diecast cylinder about 3-inches long. The internal diameter varied from the top to the bottom. They took three sample measurements of internal diameter: top, middle and bottom. They asked me how I would illustrate the problem using QI Macros.

My immediate thought: Box and Whisker Plot. So, I selected their data in Excel and created a Box & Whisker Plot using QI Macros add-in:

example of box whisker plot data

Box and Whisker Plot created by QI Macros

box plot example with target line

I added a target line of .25 to the box whisker plot using QI Macros Chart Tools menu:

add a target line to a box plot

Analysis of the Box and Whisker Plot

This chart served as the problem statement for the improvement team. From this it was clear that:

  • Die 1 was running too large
  • Die 2 too low
  • Die 3 was closest to the target

The engineers immediately set to work figuring out how to resolve the issues and move the product onto target.  They had to go back to the plant to test their countermeasures, but I could tell from their discussions that the problem would soon be solved.

How could a Box and Whisker Plot illustrate your quality problem?

Why Choose QI Macros to Create Box Plots and More?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

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



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support