Customizing Box-and-whisker Chart in Excel Double-Clickingĭouble-clicking on any item pops up the side panel where you can find more options for the selected element. Let's now take a closer look at customization options. Click the Box and Whisker chart to create your chart.Ĭlicking the icon inserts the default version of the chart. Include the data label to selection so that it can be recognized automatically by Excel, and it will be easier to modify and visualize the data.Īctivate the Insert tab in the Ribbon and click on the Insert Statistics Chart icon to see the chart types under category. Legend: The legend is an indicator that helps distinguish data series from one another.Horizontal Axis: The axis that includes the categories of the data, also known as the x-axis.Vertical Axis: The axis representing the measured values, also known as the y-axis.We recommend keeping it informative and concise. Plot Area: This is where the graphic representation takes place.

Box-and-whisker Chart BasicsĪ box-and-whisker chart consists of 5 sections: Third (Upper) quartile (Q3 / 75 th percentile): the median of the upper half of the dataset. Median (Q2 / 50th percentile): the middle value of the dataset.įirst (Lower) quartile (Q1 / 25 th percentile): the median of the lower half of the dataset. In this guide, we’re going to show you how to create a box-and-whisker chart in Excel.Ī box-and-whisker chart displays data based on a five-number summary: Originally named boxplot chart, this visualization gets its name from a box that represents the lower and upper quartiles, and lines extending from the box (whisker). A box-and-whisker chart is a visualization of groups of numerical data and their quartiles in the data set.

How to make boxplot in excel 2016