Box and Whisker Plot Creator in Excel

Excel has a built-in box and whisker plot creator: in Excel for Microsoft 365 on Windows, arrange each group’s numeric observations in a separate column, select the data, then choose Insert > Insert Statistic Chart > Box and Whisker. Excel creates a chart you can format to show medians, quartiles, individual observations, means, and potential outliers.

What Excel’s Box and Whisker Chart Shows

A box and whisker plot, also called a box plot, summarizes the distribution of values in one or more groups. It is useful when you want to compare spread and typical values without displaying every observation as a separate bar. For example, a teacher could compare exam scores across classes, or a quality team could compare measurements from several production lines.

The box represents the middle half of the observations, from the first quartile (Q1, the 25th percentile) to the third quartile (Q3, the 75th percentile). A line inside the box marks the median, or 50th percentile. The distance from Q1 to Q3 is the interquartile range, often abbreviated IQR. A wider box indicates greater spread among the central half of the data.

Whiskers extend beyond the box to show values outside the central half. In the conventional Tukey interpretation, they reach the most extreme values within 1.5 IQR of the quartiles; points beyond that range are plotted separately as potential outliers. An outlier marker flags a value for investigation, not proof that the value is wrong. Check the source data and context before excluding anything.

Arrange the Data Before Inserting the Chart

Excel needs observations grouped consistently so it can identify the series. Put a group name in the first row of each column and that group’s numeric measurements below it. For instance, columns labelled North, South, and West could each contain a region’s delivery times. Each measured delivery should occupy its own cell in the corresponding column.

Use one column per group when the groups have different numbers of observations. Leave unused cells blank rather than filling them with zero, because zero is a real value and changes the distribution.
Keep headings short and descriptive. Excel uses them as category labels, which makes the finished chart easier to read.
Check that measurements are numeric values, not numbers stored as text. Remove notes, units, and explanatory text from the measurement cells; put units in a chart title or axis title instead.
Make sure each group uses the same measurement scale and units. Comparing minutes in one column with seconds in another produces a misleading plot.

For example, if Class A has 18 scores and Class B has 22, put the two class names in A1 and B1, then enter each class’s scores down its own column. The columns do not need to have the same number of filled cells. If your source data is instead a long list with a group column and a value column, first reorganize it into one column per group or use a PivotTable-based workflow to summarize the groups. The chart expects the data layout to make the intended series clear.

Create the Chart in Excel for Microsoft 365

Select the cells containing the group headings and observations. Including the headings helps Excel label the chart correctly. Avoid selecting unrelated totals or notes.
On the ribbon, select Insert > Insert Statistic Chart > Box and Whisker. Excel inserts the chart into the worksheet.
Check the category labels and series. If the groups appear in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. The exact result depends on how the source data is arranged, so confirm the labels rather than assuming Excel interpreted it correctly.
Give the chart a meaningful title. Select the chart title and replace the placeholder with a description such as Delivery Times by Region (minutes). For a chart that needs more context, use Chart Design > Add Chart Element to add axis titles or a legend.

After insertion, resize or move the chart as needed. If you add more observations later, check whether the chart’s source range includes the new cells. For data that will grow regularly, turning the source range into an Excel table with Insert > Table can make the data easier to manage; still verify the chart range after adding rows, because chart behavior can depend on how the range was originally selected.

Format Quartiles, Whiskers, and Data Points

To change the statistical display, right-click a box in the chart and choose Format Data Series. The Format Data Series pane includes options for the box plot, such as the quartile calculation and whether to display individual points, outliers, or means. The wording and pane layout can vary slightly between Excel releases, but the controls are associated with the data series rather than the chart title or plot area.

Quartile calculation: Excel offers Inclusive median and Exclusive median methods. These methods can produce different quartile boundaries, especially for small samples. Use the method required by your course, organization, or analysis standard, and state it when the choice matters.
Show outlier points: Turn this on to display observations outside the whisker rule as separate markers. These points may reveal unusual cases that a summary alone would hide.
Show inner points: Displaying the observations can help readers see sample size and clustering, but a large dataset may become visually crowded.
Show mean markers or mean line: The mean is different from the median and can be pulled toward extreme values. Showing both can help explain skew, but label the display clearly so readers do not confuse them.

Use a simple color scheme and readable labels. If several groups are being compared, consistent box colors make the chart easier to scan; avoid relying on color alone to communicate meaning. A box plot does not automatically explain the sample size, collection period, or measurement units, so add that information in the title, axis labels, or a note near the chart when it affects interpretation.

How to Interpret a Box Plot Carefully

Start by comparing the medians: a higher median means the middle observation is higher, not that every value in that group is higher. Next compare the box heights to assess the spread of the middle 50 percent. A group with a taller box has more variation in its central observations. Then inspect whiskers and any displayed points for asymmetry or unusual values.

Consider a comparison of two teams’ task-completion times. Team A could have a median of 30 minutes and a compact box, while Team B has a median of 32 minutes and a much taller box. The medians are close, but Team B’s central results are less consistent. If Team A also has one isolated high point, that does not erase the difference in typical spread; it is a prompt to check whether the case reflects a data error, a special circumstance, or genuine variation.

A box plot does not show every detail of a distribution. Two groups can have similar medians and quartiles while differing in clustering, gaps, or sample size. If those details matter, show inner points or pair the plot with a dot plot, histogram, or a table of sample counts. Also remember that overlapping boxes do not, by themselves, establish whether a difference is statistically significant. A box plot is descriptive, not a significance test.

Common Problems and Practical Fixes

The chart shows one box instead of one per group: Check that each group is in its own column and that the selection includes all group headings. Try Chart Design > Switch Row/Column if the layout is reversed.
Group names are missing or treated as values: Confirm that the headings are included in the selection and sit in the first row. If Excel has interpreted the data incorrectly, adjust the selected source range or switch rows and columns.
The box plot has unexpected quartiles: Check whether the chart is set to Inclusive median or Exclusive median. Different quartile conventions can legitimately give different results, particularly with small datasets.
There are no visible outliers: The data may have none under the chart’s rule, or outlier points may not be enabled. Check the series formatting options before concluding that every value is typical.
Zeros or blanks distort the display: A zero is included as a measurement; a blank is not the same thing. Inspect the source range for placeholder zeros, formulas returning zero, or numbers stored as text.
The chart is unavailable: Confirm that you are using a desktop Excel version with the Box and Whisker chart type. Excel for the web may offer different chart creation or formatting options; if the command is missing or limited, open the workbook in the desktop app.

Excel Compared with Other Ways to Make a Box Plot

Excel’s built-in chart is a practical choice when your data already lives in a workbook and you need a quick comparison that colleagues can edit. It combines chart creation and presentation controls without requiring a separate add-in. Its main limitation is that the result is a summary graphic: it does not replace statistical software when you need specialized distribution methods, formal inference, or extensive reproducible analysis.

For a very small dataset, you could calculate quartiles and draw a box plot manually with shapes, but that approach takes longer and can become inaccurate when values change. A histogram or dot plot may be a better alternative when the distribution’s shape or individual observations are central to the question. Statistical software can offer more control over quartile conventions, confidence intervals, and analysis workflows, but it may require additional training or licensing. Choose the method that matches the question and the audience, not just the one with the most options.

Frequently Asked Questions

Does Excel have a built-in box and whisker plot creator?
Yes. In Excel for Microsoft 365 on Windows, select the grouped data and choose Insert > Insert Statistic Chart > Box and Whisker. The chart can then be formatted through its series options.

How do I make a box and whisker plot in Excel with multiple groups?
Put each group’s observations in a separate column, add a heading above each column, select the complete range, and insert a Box and Whisker chart. Check that Excel displays one category for each intended group.

What do the dots outside the whiskers mean?
They are potential outliers under the chart’s whisker rule. They may be valid extreme observations, unusual cases, or data-entry errors, so investigate them before deciding how to handle them.

Why do my quartiles differ from another calculator?
Different tools can use different quartile conventions, and Excel lets you choose Inclusive median or Exclusive median. Compare the selected method and sample size before treating the difference as an error.

Can Excel make a box plot from raw data in one column?
One column can create a plot for a single group. For a comparison, organize each group in a separate column with its own heading, or restructure a long group-and-value list before charting.

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.