How to Read a Box Plot in Excel: A Practical Guide

To read a box plot in Excel, locate the median line inside the box, use the box edges to identify the first and third quartiles, and compare the whiskers and any separate points to judge spread and possible outliers. In Excel, first create a Box & Whisker chart from a column of numeric observations for each group; then check the chart’s quartile setting before comparing groups.

What You’ll Need

Excel for Microsoft 365 on Windows. Box & Whisker charts are also available in Excel 2016 and later desktop editions, although ribbon labels can differ slightly.
A worksheet with numeric observations arranged in columns. Use one column per group you want to compare, with a clear heading in the first row.
Enough observations to make a distribution meaningful. A box plot can be drawn from a small set, but quartiles and outlier patterns are more informative when each group has multiple data points.

Step-by-Step

Arrange and check the data. Put each group in its own column, such as North, South, and West, with the group name in the top cell and one observation per row underneath. For example, a column could contain delivery times in days for one region, while the next column contains times for another. Keep values numeric and measured in the same units. Remove accidental totals, blank labels within the data, and text entries such as n/a; Excel cannot treat those as numeric observations. If the groups have different sample sizes, they can still be compared, but note the difference because it affects how much evidence each box represents.
Select the data range. Drag across the headings and observations, including the headings so Excel can use them as category labels. If your columns are separated, select one continuous range first or copy the columns together to a clean area. Avoid selecting unrelated cells, totals, or explanatory notes. If Excel interprets the rows as groups rather than columns, the chart may look reversed; you can correct the series orientation after inserting it.
Insert the chart. On Windows, choose Insert > Insert Statistic Chart > Box & Whisker. Excel creates a chart in the worksheet. In some versions, the menu is shown as Insert > Insert Statistic Chart followed by the Box & Whisker icon. On Excel for Mac, use the Insert tab and choose the Box & Whisker chart from the statistical chart options; wording and placement can vary by release. If the option is missing, check that you are using a supported desktop version rather than an older edition.
Confirm which columns make up the groups. Each box should represent one column of observations. If you see one box for every row or the category names are wrong, select the chart and go to Chart Design > Switch Row/Column. Use the option that makes each intended group appear as one box. You can also use Chart Design > Select Data to inspect or adjust the chart’s data range.
Read the box from bottom to top. The lower edge of a box marks the first quartile, or Q1: approximately one-quarter of the observations are at or below this value. The line inside the box marks the median, or Q2: about half the observations fall below it and half above it. The upper edge marks the third quartile, or Q3: approximately three-quarters of the observations are at or below it. For a vertical chart, these values are read against the vertical value axis; for a horizontal chart, read them against the horizontal axis.
Interpret the height of the box. The box covers the middle 50 percent of the observations. Its length is the interquartile range, often shortened to IQR, which is Q3 minus Q1. A taller box on a vertical chart means greater spread among the middle half of that group; it does not mean the group has a higher average. A short box means those central observations are more tightly clustered. The box can be compared between groups only when the chart uses a shared value scale and the measurements use the same units.
Read the whiskers and separate points. In Excel’s standard Box & Whisker chart, whiskers extend to the most extreme observed values that are not classified as outliers. Excel identifies potential 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 may appear as individual points beyond the whiskers. The whisker ends are therefore not necessarily the minimum and maximum of the full data. If outlier points are hidden in the chart settings, they will not be visible even though the data still contain them.
Check the quartile calculation setting. Right-click a box and select Format Data Series. Under Series Options, look for the quartile calculation choices, commonly Inclusive median and Exclusive median. These methods can calculate quartiles differently, especially for small samples. Keep the same method across groups and report which method you used if the exact quartiles matter. For a large dataset, the choice may have little visible effect; for a small dataset, it can change the box edges or which values look unusual.
Review optional chart markers. In Format Data Series, Excel may offer settings to show outlier points, inner points, mean markers, or a mean line. The median is the line within the box; a mean marker, when enabled, is a separate symbol and represents the arithmetic average. Do not confuse the two. Showing inner points can help reveal the individual observations, but overlapping markers may make a large dataset difficult to read. Use a descriptive chart title and add axis titles when readers need to know the measure and its units.
Make a careful comparison. Compare medians to discuss typical values, box lengths to discuss variation in the middle half, whisker lengths to assess the spread beyond the box, and outlier points to flag observations that deserve checking. For example, if Region A has a higher median delivery time than Region B, its typical delivery is slower in this sample. If A also has a much taller box, its middle half is less consistent. A box plot summarizes distributions; it does not explain why they differ or establish that one group caused a change.

Common Mistakes

Calling the box the full range. The box represents the central 50 percent, not every value. The whiskers and any outlier markers provide additional information about the tails. A point beyond a whisker is still part of the data unless you deliberately exclude it.

Assuming the whiskers always show the minimum and maximum. In Excel’s standard box plot, whiskers usually end at the most distant non-outlier values. A separate point may be the actual minimum or maximum. If your reporting rules require whiskers to show the full range, verify that this chart type and its settings meet the requirement before presenting it.

Mixing up the median and mean. The median is the line in the box. The mean appears only when its marker or line is enabled, and the two can differ substantially in a skewed distribution. State which summary you are discussing instead of referring vaguely to the average.

Comparing boxes on different scales or units. A box plot comparison is misleading if one group is measured in hours and another in minutes, or if the displayed axes use different ranges. Convert the measurements consistently and check the axis before drawing conclusions.

Treating an outlier as an error automatically. An outlier is a value unusual relative to the distribution under the chart’s rule, not proof of a mistake. Check the source record and measurement process. Keep valid observations unless you have a documented reason to correct or exclude them.

Ignoring small sample sizes. Quartiles from a small group can move noticeably when a single observation changes. A box plot may still be useful, but show the sample size or the individual values when readers need to understand how much data support the summary.

Tips

Use consistent units, meaningful column headings, and a clear title such as Delivery time by region (days). A reader should not have to infer what the axis measures.
Keep the quartile method consistent when making side-by-side comparisons. If you change from inclusive to exclusive median, the box boundaries can shift, so do not compare charts made with different settings as if they used identical calculations.
Turn on inner points when the number of observations is modest and seeing the actual distribution will help. Leave them off when they overlap so densely that the boxes become hard to read.
Use a common value axis for all groups in a comparison. Starting the axis at a value other than zero is not automatically wrong for a box plot, but a narrow range can make small differences look dramatic. Label the scale clearly and explain any unusual axis limits.
Keep a copy of the underlying data and record any exclusions or corrections. A chart alone does not preserve enough detail to audit an unusual value later.

Troubleshooting

The Box & Whisker option is missing. Confirm that you are using Excel 2016 or later, including Microsoft 365 desktop Excel. Older versions may not include this built-in statistical chart. Update Office if your organization allows it, or create the chart in a supported version. Excel for the web may have different chart creation and formatting options; if a command is unavailable there, open the workbook in the desktop app.

Excel makes one box instead of one per group. Check that the groups are in separate columns and that the selected range includes all intended columns. Select the chart, choose Chart Design > Switch Row/Column, and see whether the grouping becomes correct. If not, open Chart Design > Select Data and correct the range or rebuild the chart from a clean, contiguous table.

Headings appear as data or categories are called Series 1. Select the range again with the heading row included. Make sure each group name is in the first row of its column and that there is not an empty row between the heading and observations. Excel may need to be told whether the first row contains headings when it interprets the range.

The chart is empty or some values disappear. Check that observations are stored as numbers, not text. Text-formatted numbers, error values, and entries such as a dash may not be plotted as expected. Convert valid numeric text to numbers and decide how to handle missing or invalid records rather than replacing them with zero, which would alter the distribution.

Quartiles do not match another tool or a hand calculation. Compare the tools’ quartile definitions and confirm Excel’s inclusive or exclusive setting. Different methods can produce different quartile values for the same small dataset. Also verify that both calculations use exactly the same observations and that blanks or text values have not been treated differently.

Outliers are not visible. Right-click a box, open Format Data Series, and check whether Show outlier points is enabled. If it is enabled but no points appear, the data may have no values beyond the chart’s outlier fences. Check for hidden points, a compressed axis, or a chart range that omits the suspected observations.

Frequently Asked Questions

What does the line inside an Excel box plot mean?
The line marks the median, the middle value of the ordered observations. It divides the data into two halves; it is not necessarily the mean or average.

What do the ends of the box represent?
They mark the first and third quartiles, Q1 and Q3. The box contains the middle half of the observations, and its length is the interquartile range.

Why are there dots beyond the whiskers?
Excel shows these as potential outliers under the 1.5-IQR rule. They are observations beyond the whisker ends, not automatically errors. Check their source and context before deciding how to handle them.

Do Excel box plots show the mean?
Not necessarily. The median is normally shown as a line in the box. To display the mean, open Format Data Series and enable the mean marker or mean line if that option is available in your Excel version.

Can I compare groups with different numbers of observations?
Yes, but interpret the summaries with care. The boxes can be compared, while unequal sample sizes mean the groups are supported by different amounts of data. Consider displaying sample sizes or individual points, especially when one group is small.

Should the median be centered inside the box?
No. A median closer to one box edge can indicate that observations are more spread out on one side of the median than the other. It can suggest skew, but the box plot alone does not show every detail of the distribution.

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.