You can fix this assuming you started with exactly 5 numbers by duplicating the values for the first and third quartile in the data set. Required fields are marked Comment Name Email Website Save my name, email, and website in this browser for the next time I comment.Īfter that you can change the background color for the plot area only. Now you have your beautiful looking Box and Whisker chart and you can quickly point out to your management where the outliers lie HELPFUL RESOURCE.

STEP 4: You can further customize the look and feel of your Excel Box and Whisker Plot, by going to Chart Tools Design Format STEP 5: In our example, let us go to Chart Tools Design and pick one of the alternate designs. Want to know how to create a Box and Whisker Excel Watch our video and step by step guide below with free downloadable Excel workbook to practice Watch on YouTube and give it a thumbs up DOWNLOAD EXCEL WORKBOOK STEP 1: Highlight your table and go to Insert Recommended Charts STEP 2: Select All Charts Box and Whisker OK STEP 3: Now you have your Box and Whisker Chart.

To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016 Read this tutorial to create a box and whisker diagram (box plot) using Excel 2013 or below. Below is a Box and Whisker diagram explaining this: Here is how the Box and Whisker plot Excel 2016 version looks like: In this example, I show you how easy it is to insert a Box and Whisker Excel 2016.

How to create a boxplot in excel 2016