This tutorial shows you how to create and interpret box plots in Excel, a practical skill for summarizing distributions, spotting outliers, and comparing groups; it covers the easiest path using Excel's built-in Box & Whisker chart (Excel 2016/2019/365) and also provides clear . This tutorial shows you how to create and interpret box plots in Excel, a practical skill for summarizing distributions, spotting outliers, and comparing groups; it covers the easiest path using Excel's built-in Box & Whisker chart (Excel 2016/2019/365) and also provides clear . On the Insert tab, in the Illustrations group, select Chart. In the Insert Chart window, on the All Charts tab, select Box & Whisker. If you don't see these tabs, select anywhere in the box and whisker chart to add the. Let's say we have the information for Oakmont Ridge Golf Club shown in the B4:C14 cells below. Steps to make a box and whisker plot in Excel: ➤ Select the entire dataset, including both “ Subject ” and “ Score ” columns. Watch Video1 to see the steps for making a simple box plot chart. " Think of it like sorting a collection of items into different buckets and then counting how many items are in each one. A chart does the sorting for you, showing which ranges. A box plot is a method of displaying data that helps visualize statistical qualities like the spread and variability of the data.