The whiskers indicate variability outside the upper and lower quartiles.
In recent versions of Excel, you might create a box and whisker chart using theInsert Chart tool.
Enter the data you want to use to create a box and whisker chart intocolumns and rowson the worksheet.
This can be a singledata seriesor multiple data series.
grab the datayou want to use to make the chart.
Select theAll Chartstab in the Insert Chart dialog box.
SelectBox and Whiskerand chooseOK.
A basic box and whisker plot chart appears on the worksheet.
Create a basic box plot chart in Exceland then add the whiskers.
opt for top box on the chart and then selectAdd Chart Elementon theChart Designtab.
SelectError Barsand chooseMore Error Bar Optionsto open theFormat Error Barsmenu.
SelectCustomand chooseSpecify Valuein theError Amount Sectionto open theCustom Error Barsdialog box .
grab the bottom box on the chart and selectAdd Chart Elementon theChart Designtab.
SelectCustomand chooseSpecify Valuein theError Amount Section.
TheCustom Error Barsdialog box will open.
Delete the contents of thePositive Error Valuebox.
choose the bottom values on the worksheet and selectOKto close theCustom Error Barswindow.
SelectChart Titleand enter the title you want to appear for the chart.
Right-click one of the boxes on the chart and chooseFormat Data Seriesto open theFormat Data Seriespane.
Increase or decrease theGap Widthto control the spacing of the gap between the boxes.
SelectShow Inner Pointsto display the data points between the two whisker lines.
Also in the Format Data Series pane, selectShow Outlier Pointsto display outliers below or above the whisker lines.
SelectShow Mean Markersto display the mean marker of the data series.
SelectShow Mean Lineto display the line connecting the means of the boxes in the data series.
Modify factors such as the chart layout, style, or colors using the same methods described above.
