

When defining a box plot, here's how Towards Data Science explains it:Ī boxplot is a standardized way of displaying the distribution of data based on a five number summary ("minimum", first quartile (Q1), median, third quartile (Q3), and "maximum").įor viewing a box and whisker plot, the box shows the first quartile to the third quartile with a line through the center at the median. For the data range, we need two cells with values that add up to 100. In this example, we have selected the first pie chart (called Pie) in the 2-D Pie section. Click on the Pie Chart button in the Charts group and then select a chart from the drop down menu.

This type of chart works well for showing statistical data such as school grades or scores, before and after process changes, or similar situations for numerical data comparisons.įor more help on when to use which type of Excel chart type, check out our helpful guide. Select the Insert tab in the toolbar at the top of the screen.

A box and whisker plot, or box plot, is a chart that's used to display a five-number summary of data.
