Can You Make a Box and Whisker Plot in Excel?

Yes. In Excel for Microsoft 365 on Windows, select your grouped data, then choose Insert > Insert Statistic Chart > Box and Whisker. Excel builds the chart from the values in each group; you can then adjust its quartile method, outlier display, labels, and other formatting.

What a box-and-whisker plot shows

A box-and-whisker plot, also called a box plot, summarizes the distribution of numerical values. Rather than displaying every value as a separate bar, it shows the median, the middle half of the data, and the spread toward the low and high ends. It is useful when you want to compare groups quickly, such as test scores across classes, delivery times by carrier, or monthly measurements from several machines.

The box runs from the first quartile (Q1) to the third quartile (Q3). Its height or length is the interquartile range, or IQR, which contains the middle 50 percent of the observations. A line inside the box marks the median. Whiskers show the extent of the non-outlier values under the chart’s selected convention, while individual marks beyond them can identify outliers.

Because the chart compresses many observations into a few features, it helps reveal differences in spread and skew that averages alone can hide. Two groups may have similar medians but very different variability. A box plot can make that difference visible without requiring a reader to scan a long column of numbers.

Arrange your data before inserting the chart

Put each group in its own column, with a descriptive header in the first row and numeric observations underneath. For example, columns titled Class A, Class B, and Class C can contain the scores for each class. The columns do not have to contain equal numbers of observations, although keeping the data organized and avoiding unintended blanks makes the chart easier to interpret.

Before creating the chart, check that the values are genuinely numeric and that the headers are clear. Text such as “n/a” inside a data column is not a measurement and may affect how Excel interprets the range. Decide how to handle missing observations rather than replacing them with zero: zero is a real value and can distort the distribution. If your data is arranged with groups in rows instead of columns, Excel may interpret the series differently; you can change the orientation after insertion.

Use one column per group when you want to compare groups side by side.
Include a single header row so the chart can use group names as labels.
Keep unrelated notes and totals outside the selected range.
Check that a pasted range does not contain accidental blank rows or text values.

Create the chart in Excel for Windows

In desktop Excel for Microsoft 365 on Windows, select the complete data range, including the headers. Then open Insert > Insert Statistic Chart > Box and Whisker. Excel inserts a chart with a box for each data series it recognizes. If the chart has the wrong number of boxes or uses row labels unexpectedly, select the chart and use Chart Design > Switch Row/Column to change how Excel groups the data.

Arrange each set of measurements in a separate column and add a header.
Select the headers and all observations you want included.
Choose Insert > Insert Statistic Chart > Box and Whisker.
Add a useful chart title and axis title, and review the group labels.
Right-click a box and choose Format Data Series to inspect the statistical display options.

For example, suppose Class A has scores in B2:B21 and Class B has scores in C2:C21, with the class names in B1 and C1. Selecting B1:C21 creates a two-group comparison. If you select only the numbers, Excel may still create a chart, but meaningful headers make its legend and categories clearer. The chart is linked to the selected worksheet data, so changing a source value generally updates the plotted distribution.

How to read the boxes, whiskers, and outliers

The median is the central line: half the observations fall below it and half above it, subject to how tied values are handled. The lower and upper edges of the box mark Q1 and Q3. A taller box indicates a larger IQR and therefore greater spread among the middle half of the observations. A median line that is not centered in the box can suggest that values are unevenly distributed around the median.

Excel’s box-and-whisker chart identifies outliers using the 1.5-IQR rule. Values below Q1 minus 1.5 times the IQR or above Q3 plus 1.5 times the IQR are treated as outliers and can appear as separate points. The whiskers reach the most extreme observations that are not classified as outliers, rather than necessarily reaching the absolute minimum and maximum. This is why a point beyond a whisker is not automatically an error; it may be a valid, unusually high or low observation.

Consider the ordered values 10, 12, 13, 14, 15, 16, 18, 20, 22, and 40. With an inclusive quartile method, the median is 15.5, Q1 is 13.25, and Q3 is 19.5, making the IQR 6.25. The upper fence is 28.875, so 40 is beyond it and may be plotted as an outlier; 22 is the highest value within the fence. The example illustrates the rule, but the exact quartiles displayed by Excel depend on the quartile calculation option selected.

Change quartile and point-display settings

To change the statistical choices, right-click a box and select Format Data Series. In the series options, Excel provides a choice between inclusive and exclusive median calculations for quartiles. It also offers controls for displaying inner points, outlier points, a mean marker, and a line connecting means. The available options and their labels can vary slightly with Excel version and platform.

Inclusive and exclusive quartile methods can produce different box boundaries, particularly in small samples. Neither setting makes the data itself different; it changes how the quartile positions are calculated. If a chart is being compared with a report or another software package, use the same quartile convention where possible and state the method when the result matters. Otherwise, two correctly made plots of the same small dataset may appear to disagree slightly.

Showing inner points can help readers see individual observations, but it may make a chart crowded when each group has many records. Outlier markers are often valuable for investigation, while mean markers can help when a reader specifically needs to compare means as well as medians. A mean is sensitive to extreme values, so it should not be confused with the median line.

Make the chart easier to understand

A box plot is only useful if readers know what they are comparing. Give the chart a specific title, such as “Delivery time by carrier,” and use descriptive category names rather than labels like Series 1. If units matter, include them in an axis title or the chart title, for example “Processing time (minutes).” Avoid relying on color alone to distinguish groups, especially when the chart may be printed in grayscale.

Excel’s chart design and formatting controls let you adjust colors, borders, legends, and labels. Use formatting to clarify rather than decorate: a restrained palette makes the median and outlier marks easier to pick out. If the group names are long, a horizontal layout or shorter labels may improve readability. Keep the vertical or horizontal scale consistent when comparing multiple charts; independently scaled axes can make modest differences look dramatic.

When a chart is intended for a report, check that the source data and chart are both included and that the title describes the population or time period accurately. A plot does not show sample size as clearly as a table or a dot plot, so consider adding the number of observations for each group in a caption or nearby table when sample sizes vary considerably.

Common problems and what to check

If Excel creates one box instead of several, first check whether the groups are arranged in the expected rows or columns. Use Chart Design > Switch Row/Column to reverse the interpretation. Also confirm that the selected range includes all group columns and their headers, but not unrelated summary rows or extra columns.

If a box or whisker looks unexpectedly different, inspect the source range for blanks, text-formatted numbers, duplicate values, or a mistakenly included total. Then check the quartile method and whether the chart is showing inner points or outliers. A single extreme value can stretch the scale and make the boxes appear compressed; that does not necessarily indicate a chart error. It may be an important feature of the data or a data-entry problem that needs investigation.

If the Box and Whisker command is not visible, confirm that you are using a desktop Excel release that supports statistical charts, such as Excel 2016 or later, including Microsoft 365. Excel for the web and older or restricted installations may not offer the same chart-creation controls. When the option is missing or the formatting choices are limited, open the workbook in the current desktop Excel app and look under the Insert tab. Mac ribbon wording and layout can differ, but supported desktop versions provide the box-and-whisker chart under the Insert chart options.

When a box plot is not the best choice

A box-and-whisker chart is particularly helpful for comparing distributions, but it does not show every detail. It can hide clusters, gaps, or multiple peaks within a group. If the sample is small, the individual measurements may be more informative than a summary box. A dot plot can show each observation, while a histogram can reveal the shape of one distribution in more detail. A column chart, by contrast, is designed to compare values such as totals or averages and does not communicate quartiles and spread in the same way.

Choose the chart based on the question. Use a box plot to compare medians, variability, and potential outliers across groups. Use a histogram to examine the shape of one numeric distribution, and consider a dot plot when you want to show all observations. For a large dataset, a box plot is a compact summary, but it should not replace checking the underlying values when an outlier or unusual pattern could affect a decision.

Frequently Asked Questions

Does Excel have a built-in box-and-whisker chart?
Yes. Supported desktop versions include a built-in Box and Whisker statistical chart. In Excel for Microsoft 365 on Windows, select the data and choose Insert > Insert Statistic Chart > Box and Whisker.

Can I make a box plot with different sample sizes?
Yes. Each group can have a different number of observations. Put the groups in separate columns and leave unused cells blank rather than filling them with zero. Review the result to make sure Excel has interpreted the groups as intended.

Why does Excel show a point outside the whisker?
Excel can mark observations beyond the 1.5-IQR fences as outliers. Such a point may be a valid extreme value, not necessarily a mistake. Check the source record and the context before deciding whether it should be excluded.

Can I show the mean on an Excel box plot?
Yes. Right-click a box, choose Format Data Series, and turn on the mean marker or mean line option if appropriate. The mean is different from the median, which is the line inside the box.

Can Excel create a box-and-whisker chart on a Mac?
Supported desktop Excel for Mac versions include statistical chart options, though the ribbon layout and wording can differ from Windows. Look on the Insert tab for the statistical chart choices. If the command is unavailable, check your Excel version or open the workbook in desktop Excel.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.