How To Make a Box and Whisker Plot in Excel in 3 Steps

Create a box and whisker chart
1. Select your data—either a single data series, or multiple data series. …
2. In Excel, click Insert > Insert Statistic Chart >Box and Whisker as shown in the following illustration.

Box and whisker plots are a great way to visualize the spread of your data in Microsoft Excel. They provide a way to quickly analyze and compare different datasets in an easily interpretable format. With the help of box and whisker plots, you can identify potential outliers, as well as get a better understanding of the variability of your data. In this blog post, we will go through the steps to create a box and whisker plot in Excel. We will discuss the basics of box and whisker plots, how to identify the components of the plot, and how to create the plot in Excel. After reading this post, you will have the tools and knowledge to easily make box and whisker plots in Excel for any dataset you come across.

When to use a box and whisker plot

Box and whisker plots are useful in many statistical applications. One data set can be graphed using this type of plot, but a box and whisker plot is especially useful when you have several related data sets that originate from different sources. For instance, a researcher might use this type of plot to graph the outcomes of a clinical trial. A box and whisker plot can be used to display various other kinds of data, such as:

What is a box and whisker plot?

A box and whisker plot is a graph that presents data in terms of five key numbers to demonstrate the skewness and locality of a data set. The smallest value, first quartile, median, third quartile, and largest value are represented by these five numbers. A box and whisker plot’s “box” is made up of the first and third quartiles, and the median is a straight line that lies roughly in the middle of the box. The lines that reach the smallest and largest values are known as the whiskers. Outliers of the data set are any data points that are outside of the whiskers.

How to make a box and whisker plot in Excel

The following are the steps for creating a box and whisker plot in Excel:

1. Organize all of your data

Place all the data you wish to plot into columns or rows to start. Although it is not required, you might think about sorting the data in ascending order to help you understand how Excel generates the box and whisker plot. You can consider an example data set below.

1112141415161517181719202124### 2. Choose the information you wish to include in the box and whisker plot.

You can choose one or more data series, depending on what you want to plot. By placing your cursor on the first cell and holding it down, you can manually select certain cells. To plot all the data, drag your mouse across it.

By clicking on any cell in the column and simultaneously pressing the “Ctrl” key and the spacebar, you can select the entire column. By clicking on any cell in the row and simultaneously pressing the “Shift” key and the spacebar, you can select the entire row. By choosing the first column or row, pressing and holding down the “Ctrl” key, and then clicking on the headers of the other columns or rows you want to select, you can also choose non-adjacent columns or rows.

3. Convert the data into a box and whisker plot

After selecting all of your data, you can create a box and whisker plot. Navigate to the “Insert” tab from the “Home” tab and select it. Locate the “Charts” section and select “Insert Statistic Chart” from the drop-down menu. ” Choose the option that says “Box and Whisker. This generates a box and whisker plot for the one or more data series you chose in step two.

Elements to consider when formatting a box and whisker plot

After creating a box and whisker plot, you can access the “Design” and “Format” tabs on the Excel ribbon. You can change the graphs’ styles, colors, and layout from the “Design” tab. The “Format” tab allows you to change the following components:

Chart title

When you create a box and whisker plot, the chart title is automatically displayed as “Chart Title.” You can alter this title to better reflect the information in your graph. Additionally, you can change the titles’ size, placement, and background color.

Legend

Excel automatically disables a box and whisker plots legend. By clicking on the corresponding toggle button, you can enable the legend. Additionally, there are options for moving the legends and overlaying them over your box-and-whisker plot in the “Legend” section. You can add text headers if your chosen cells don’t already have them under the “Series” sections. You can choose to show or hide the charts’ inner points, outlier points, mean markers, and mean line while in the “Series” sections.

Horizontal axis

To view the editing options, select “Horizontal Axis” from the drop-down menu. You can choose to change the boxes’ gap width. If your chart only has one or two boxes, it might be beneficial to reduce the gap width to make it easier to read. You can also add major and minor tick marks, change the label position, and change the number format from the “Horizontal Axis” tab.

Vertical axis

Additionally, you have a variety of options for vertical axis editing your box and whisker plots. To view your formatting options, select “Vertical Axis” from the drop-down menu. The chart’s numerical range can be increased or decreased by modifying the minimum and maximum bounds. Major and minor gridlines can also be enabled or disabled based on your preferences for readability.

FAQ

How do you make a box and whisker plot in Excel 2021?

There isn’t a built-in chart type in EXCEL for making box and whiskers plots. The Open-High-Low-Close chart in EXCEL, which is an interesting modification of the stock chart, can be used to create them. In the accompanying spreadsheet, a box and whiskers plot example is provided.

Why does my excel not have box and whisker plot?

There isn’t a built-in chart type in EXCEL for making box and whiskers plots. The Open-High-Low-Close chart in EXCEL, which is an interesting modification of the stock chart, can be used to create them. In the accompanying spreadsheet, a box and whiskers plot example is provided.

How do you make a box and whisker plot step by step?

There isn’t a built-in chart type in EXCEL for making box and whiskers plots. The Open-High-Low-Close chart in EXCEL, which is an interesting modification of the stock chart, can be used to create them. In the accompanying spreadsheet, a box and whiskers plot example is provided.

How do you make a box and whisker plot vertical in Excel?

There isn’t a built-in chart type in EXCEL for making box and whiskers plots. The Open-High-Low-Close chart in EXCEL, which is an interesting modification of the stock chart, can be used to create them. In the accompanying spreadsheet, a box and whiskers plot example is provided.