How to create a Box and Whisker chart
The Box and Whisker chart allows you to plot distributions in statistics, it also displays local minimum, first quartile, median, mean, third quartile and outliers.
Microsoft designed the Box and Whisker chart to follow the Tukey industry standard. A value is considered an outlier if it is equal to or more than 1.5 length of the box from one of the ends of the box.
How to build
- Select data.
- Go to tab "Insert" on the ribbon.
- Click "Insert Statistic Chart" button.
- Click "Box & Whisker chart" button.
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
