Home > Charts > Advanced > Box Plot How to Build an Excel Box Plot ChartSee how to make a Box Plot, or box and whisker chart, in Microsoft Excel, to show the distribution of the numbers in your data set. Watch Video1 to see the steps for making a simple box plot chart. There are written steps too, and a sample file to download. Video2 shows how to add an average line in the chart, and Video3 shows a different box plot chart example. Author: Debra Dalgleish 
Box Plot Chart OverviewMost people are familiar with a line chart, where you show data over a period of time. First, we'll take a quick look at a line chart, then we'll see how a box plot chart would show the data in a different way. For both types of chart, the same data will be used:
Line Chart  Monthly DataFirst, in the line chart below, you can:
Box Plot Chart  QuartilesInstead of showing data over time, a box and whisker chart shows the data in numerical order, divided into 4 equal sections (quartiles). This diagram shows the different parts of the box plot chart, and you'll see how to create this, in the video and written steps, further down on this page. Store Sales Box PlotHere is a horizontal box plot chart for the three stores' sales data. This chart lets you compare:
What Does This Box Plot Show?At a quick glance, this chart show the following nformation:
See Steps and More ExamplesExcel 2013 doesn't have a Box Plot chart type, but you can build your own Box and Whisker plot, by following the examples below.
In these examples, you'll discover how to:
Video: Build Your Own Box PlotTo see the steps for creating a simple box plot chart (box and whisker plot), watch this short video. The written instructions are below the video. Note: To see the video transcript, go to the Box Plot Chart Video page. Video Timeline

Ex 3) Video: Wait Times Box PlotThis box plot example is based on wait times at airport security checkpoints. There are written notes on my Contextures Blog: Airport Security Times in Excel Box Plot Get the Sample ChartRegon Sales: You can download the sample file that was used in the East/West Region Sales example video  Simple Box Plot Chart. The zipped file is in xlsx format, and does not contain macros. 
More Tutorials 
Last updated: August 7, 2023 2:57 PM