Here we discuss the meaning and how to create Box and Whisker plot in excel with examples. Box And Whisker Plot In Excel 15.3 How To Create Box To find the first Quartile value below is the formula. So apply excels built-in function MIN function for all the year as shown in the below image.įor this, we need another built-in function QUARTILE.INC. These five numbers are essential to creating Box and Whisker Plot in Excel.įive numbers of statistics are Minimum Value, First Quartile Value, Median Value, Third Quartile Value, and Maximum Value.
This chart is used to show a statistical five-set number summary of the data. So in todays article, we will show you about Box and Whisker Plot in Excel.īox and Whisker plot is an exploratory chart used to show the distribution of the data. This is not the most popular chart in nature but the very effective chart in general. Right-clicking on the box and choosing Format Data Series., you will be able to decide via the menu to the right whether outliers, data points, etc are to be displayed.Īmidst all the sophisticated softwares majority of the people still, use Excel for their visualization. In the long list of charts in the tab All Charts, click on Box Whisker and OK. Box And Whisker Plot In Excel 15.3 How To Create BoxĪnyway, because the whiskers are defined by the user (and not by convention), it is important, when creating the boxplot, to mention what they represent in the legend of the chart.
