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.
To Create a Box and Whisker Plot using the QI Macros
- Just click and drag over your data to select it
- Then click on the QI Macros menu and Box Whisker Plot
- The QI Macros will ask if you want the data grouped by rows or columns.
- 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 4 Columns
- Box and Whisker Plot in Excel Video
- Box and Whisker Plot Elements Explained
- Compare the QI Macros Box Whisker Plot to our Competitors