In some box plots, the minimums and maximums outside the first and third quartiles are depicted with lines, which are often called whiskers. While Excel 2013 doesn't have a chart template for box plot, you can create box plots by doing the following steps:
This example teaches you how to create a box and whisker plot in Excel. A box and whisker plot shows the minimum value, first quartile, median, third quartile and maximum value of a data set.
This tutorial shows how to create Box and Whisker Charts (Box Plots), including the specialized data layout needed, and the detailed combination of chart series and chart types required.