Box and Whisker Plot Diagram in Excel
Use a Box & Whisker Plot to Analyze Variation in Data
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