Excel Box And Whisker Horizontal. The next step is to replace the topmost and second-from-bottom the deep blue and orange areas in the image data series with lines or whiskers. Instead you can cajole a type of Excel chart into boxes and whiskers.
Then select and delete the horizontal axis and you can also edit the chart title and insert the legend as you need see screenshot. Step by step instructions on how to create a Box and Whisker Plot in Excel 2010Note. These five-number summary are Minimum Value First Quartile Value Median Value Third Quartile Value and Maximum Value.
A box and whisker plot shows the minimum value first quartile median third quartile and maximum value of a data set.
This chart is used to show a statistical five-set number summary of the data. The box itself is divided into two parts. Select the chart and use Paste Special to add the data as a new series. However this is not a case for Box-and-whisker charts.
