Box and Whisker Plot Diagram in Excel

Use a Box & Whisker Plot to Analyze Variation

Box and Whisker Plots show variation and central tendency of data due to time, parts, and production tools. They are like simple histograms.

  • The box represents the distance between the 1st and 3rd quartiles--the InterQuartile Range (IQR=Q3-Q1).
  • The whiskers are 1.5*IQR or the highest / lowest point within the range.
  • Outlier points are those that are greater than 1.5*IQR.from Q1 or Q3.
box and whisker plot generated in Excel by QI Macros

Box and Whisker Plots Can be Difficult to Make in Excel

However, the QI Macros Box and Whisker Plot Generator for Excel Makes it Easy.

box and whisker plot maker for Excel

To Create a Box and Whisker Plot in Excel using QI Macros

  1. Just click and drag over your data in an Excel worksheet to select it.
  2. Then click on the QI Macros menu and then Box Whisker Plot

    box and whisker plot worksheet in excel

  3. QI Macros will ask if you want the box whiskers plot data grouped by rows or columns.
  4. box whisker plots choices

  5. QI Macros will perform the calculations and create a box whisker plot for each data group.

Box Whisker Plot by 18 Rows

box whisker plot maker example

Box Whisker Plot by 4 Columns

box whisker diagram generator in excel

Learn More...

To create a Box Whisker Plot in Excel using the QI Macros...
Try It Now!

Excelerate Your Projects Download Free QI Macros Trial Buy QI Macros for Excel Now