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.

box whisker plot in excel

To Create a Box and Whisker Plot using the QI Macros

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

    box whisker plot diagram in excel

  3. The QI Macros will ask if you want the data grouped by rows or columns.
  4. box whisker diagram prompt

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

Box Whisker Plot by 18 Rows

box whisker plot by row

Box Whisker Plot by 4 Columns

box whisker diagram in excel by column

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