How to Make a Box and Whisker Plot in Excel?

Get FREE Advanced Excel Exercises with Solutions!

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.

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

Box and Whisker Plot and Itâ€™s 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.

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.

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

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.

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.

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.

ðŸ”¼Â In a moment, Excel inserts a Box and Whisker PlotÂ as shown in the image below.

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: The format data series dialog box contains the options below; follow the descriptions to modify the plot according to your desire.

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.

Related Articles

<< Go Back to Box and Whisker Plot in ExcelÂ |Â Excel ChartsÂ |Â Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF