How to Make a Box and Whisker Plot in Excel (with Easy Steps)

Excel’s Box and Whisker Plot demonstrate the distribution of Quartiles, Median, and Outliers of the assigned dataset. Users often need to make a Box and Whisker Plot in Excel to display their data.

Let’s say we have a dataset holding obtained numbers of students in multiple subjects. And we want to create a Box and Whisker Plot.

Dataset-How to Make a Box and Whisker Plot in Excel

This article demonstrates the step-by-step process to insert a Box and Whisker Plot.


Download Excel Workbook


Box and Whisker Plot and Its Components

Excel provides the Box and Whisker Plot in its Insert tab > Charts section. The Box and Whisker Plot has two main components: Box and Whisker.

Box: A rectangular box displays the distribution of sample data containing Quartiles, and Median.

Whisker: Vertical lines extended from the Box are known as Whisker. Lower and upper extreme points are referred to as Min and Max values, respectively.

Box and Whisker Plot components

Other sub-components of a Box and Whisker Plot are:

Minimum Value: apart from outliers, the lowest data value within the sample.

Maximum Value: apart from outliers, the highest data value within the sample.

Median: the midpoint value within the sample.

First Quartile (Q1): median value of the lower half of the sample.

Third Quartile (Q3): median value of the upper half of the sample.


Step-by-Step Procedures to Make a Box and Whisker Plot in Excel

Making a Box and Whisker Plot in Excel requires multiple variants of a single entry. Setting up the dataset, inserting the Box and Whisker Plot, and modifying the Box and Whisker Plot are the steps to create a proper Box and Whisker Plot in Excel.


Step 1: Setting up Data to Insert a Box and Whisker Plot

🔼 Prepare a dataset containing multiple entries for a single record. The following screenshot depicts the sample data to insert a Box and Whisker Plot.

Data


Step 2: Inserting Box and Whisker Plot in Excel

🔼 After setting up the data, highlight the entire data or range, then go to Insert > Insert Statistic Chart > Click Box and Whisker.

Inserting Box and Whisker Plot-How to Make a Box and Whisker Plot in Excel

🔺 In a moment, Excel inserts a Box and Whisker Plot as shown in the image below.

Box and Whisker Plot


Step 3: Modifying Box and Whisker Plot for Better Representation

🔼 Double click on any inserted Box and Whisker icon within the plot, and the Format Data Series dialog box appears. Mark desired options to modify your Box and Whisker Plot.

Format Data Series

Format Data Series: The format data series dialog box contains the options below; follow the descriptions to modify the plot according to your desire.

Options


Conclusion

In this article, we describe the step-by-step process to create a Box and Whisker Plot. We hope this article helps you to make stunning Box and Whisker Plots with your data. Comment if you have any inquiries or have anything to add.

Have a quick visit to our amazing website and check out our recent articles on Excel. Happy Excelling.

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo