Buy Now

Box and Whisker
Plot Maker
Excel Template

Create a 5-number summary in seconds for up to two datasets with our Box and Whisker Plot Maker Excel Template. Easily identify trends and distribution with our simple to use formulas and chart. 
Unlock Access
Video Poster Image

What's Inside the Box and Whisker Plot Template?

Details | 2 Sheets 

Supported Versions | Excel 2007, 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | Operations, Data Analysis

Tags | 5 Number Summary, Mean, Median, Average, Quartile

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Box and Whisker

Excel Template

Enter your inputs into up to two data sets. Your Box and Whisker Plot will automatically calculate and graph, showing you the 5 number summary.

Society loves talking about averages. We understand why, but any statistician will tell you how misleading averages can be without overall context of distribution and outliers. That’s where our Box and Whisker Plot Excel Calculator comes in handy. It automates your Box and Whisker Plot charting and creates a five number summary for your inputs to help you understand outliers, dispersion and skewness in your data.

A five-number summary is useful for understanding the distribution of your data set. It contains five numbers, hence the name; the minimum, the first quartile (25%), the median, the third quartile (75%) and the maximum. 

These points will be charted on the Box and Whisker Plot. The lines outside the box display the range below the first quartile or above the third quartile. The minimum and maximum points help you understand if there are outliers within your dataset. 

Before we dive into the brief instructions on how to utilize this template, you may also want to check out our Stratification Data and Panel Analysis templates. These spreadsheets are designed to quickly calculate your numbers and show relationships between sets of data via tables and graphs. 

There is only one sheet in this template so we’ll start there, appropriately named Box and Whisker Plot. There are two tables for you to input your Data Sets. Simply, plug in your data to one of the tables or both if you are working with multiple data sets. 

Your data will be automatically chartered above, using different colored symbols to represent different points in your five number summary. To the right of the chart is a five number summary from your dataset.

Our Box and Whisker Plot Excel Template

One of my favorite ways to use this spreadsheet is for analyzing fantasy football data. A couple of amazing games can skew a player's data to make them appear more productive than they actually are especially because of  how small a sample size is (16 games). 

Go beyond the average and see the truth behind the distribution with this easy to use Box and Whisker Plot generator.  

More Data Analysis Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW