Box Plot in Excel: Create, Format, and Read the Chart

Yes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Box and Whisker. Excel creates a box plot—also called a box-and-whisker chart—that summarizes the distribution of one or more groups so you can compare medians, spread, and potential outliers.

What an Excel box plot shows

A box plot compresses a group of numbers into a visual summary. The box runs from the first quartile (Q1) to the third quartile (Q3), so it contains the middle half of the observations. A line inside the box marks the median, or middle value. The distance between Q1 and Q3 is the interquartile range (IQR), a measure of the spread of that middle half.

In Excel’s chart, the whiskers extend to the most extreme values that are not treated as outliers under the chart’s rule. Values beyond 1.5 times the IQR from a quartile are shown as individual outlier points when outlier points are enabled. They are not necessarily errors: an unusual measurement may be genuine and worth investigating. The chart can also show individual observations, a mean marker, or a mean line, depending on its settings.

These elements help answer different questions. A higher median suggests a group’s typical value is higher; a taller box means its central observations are more spread out; and isolated points flag values that deserve a closer look. A box plot does not show every value by default, so it is a summary rather than a replacement for checking the underlying data.

Arrange data before inserting the chart

Put each group in its own column, with a descriptive heading in the first row. For example, a delivery-time comparison could use the headings “Standard,” “Express,” and “Pickup,” with each order’s time listed below the appropriate heading. One column is enough to plot a single group. For comparisons, use one column per group and keep all measurements in the same units.

Groups do not need to contain the same number of observations. If one group has fewer entries, leave the remaining cells empty; do not fill them with zeros, because zero is a real data value and can distort the distribution. Keep labels out of the measurement cells, and check for numbers stored as text, stray notes, and accidental totals. A total or average included among the observations becomes part of the chart’s data and can produce a misleading result.

Use one observation per cell and one group per column.
Include a header for each group so the chart can label its categories.
Keep missing values blank rather than substituting zero.
Review units and data entry before charting; for instance, do not mix minutes and seconds without converting them first.

Sorting the values is not required. Excel calculates the summary from the data rather than drawing a box based on the order of the rows.

Create a box-and-whisker chart

Select the headings and numeric cells you want to chart. If the columns are next to each other, drag across the full range, including the headers. For nonadjacent ranges, it is usually simpler to move or copy the data into a compact table first.
Open the Insert tab on the ribbon.
Choose Insert Statistic Chart in the Charts area, then select Box and Whisker.
Check the category labels and chart orientation. If Excel has treated rows and columns the wrong way around, select the chart and use Chart Design > Switch Row/Column, when that command is available.
Give the chart a useful title and resize or move it as needed. A title such as “Delivery time by service” explains the comparison more clearly than a generic label.

The exact ribbon arrangement can vary with window size, so the chart command may appear as an icon or within a chart drop-down. In current Excel for Mac, select the data and look on the Insert tab for the statistical chart options and Box and Whisker. Excel for the web may not offer the same chart-creation controls in every account or release; if the option is missing, open the workbook in the desktop app.

Format the chart and choose what to display

To change the statistical details, right-click a box in the chart and choose Format Data Series. In the formatting pane, look under Series Options. Excel provides controls for showing inner points, outlier points, mean markers, and a mean line. The available controls may vary slightly with the Excel version and chart selection.

Showing inner points can reveal how observations are distributed, but a large sample may make the chart crowded. Outlier markers are useful when unusual measurements matter, while a mean marker can help readers compare the mean with the median. A noticeable gap between mean and median can indicate skew or influential values; neither statistic alone explains why the distribution looks that way.

Excel also offers a Quartile Calculation choice: Inclusive median or Exclusive median. These are different conventions for calculating quartiles, particularly relevant for small samples. If you are comparing charts, use the same convention for every group and state the choice when the method matters to your audience. You can also add axis titles through the chart elements controls and format the value axis so its scale and units are easy to understand.

How to interpret the result carefully

Imagine comparing the time customers wait in three service queues. If the second queue has a higher median, its typical wait is longer. If its box is wider, the middle half of waits varies more. If one queue has a long upper whisker or several high outlier points, it may have occasional long delays even if its median is competitive. These observations suggest questions for further analysis; they do not establish what caused the differences.

Look at the whole pattern rather than ranking groups on one feature. Two boxes can overlap while their medians differ, and overlap alone is not a formal test of whether groups differ significantly. A box plot also hides details such as multiple clusters or gaps between values. With a small sample, a single observation can move the quartiles substantially, so display individual points or report the sample size where possible.

Be cautious when groups have very different sample sizes. A box plot shows spread and summary values, but the boxes themselves do not communicate how many observations went into each group. Add sample counts to labels or a nearby table if that context affects the conclusion. Likewise, consider whether the groups are measured on comparable scales and under comparable conditions before interpreting the visual difference.

Common problems and practical fixes

The chart option is missing: Confirm that you are using a desktop Excel version with box-and-whisker chart support. In Excel for the web, switch to the desktop app if the statistical chart command is unavailable.
Excel makes one group from the whole table: Check that each group is in a separate column and that headers are included. Use Chart Design > Switch Row/Column to test the other orientation.
A group looks implausibly wide or has extreme points: Inspect the source range for totals, zeros used in place of blanks, text converted to numbers incorrectly, unit mismatches, or genuine unusual readings.
Labels are generic or missing: Include clear column headings when selecting data. If needed, correct the chart’s source range or use the chart’s data-selection controls to include the header row.
Quartiles do not match another report: Compare the quartile convention and calculation method. Different software, or an inclusive versus exclusive setting, can produce different quartiles, especially for small datasets.

When a chart looks wrong, verify the source data and selected range before changing formatting. Styling can make a chart easier to read, but it cannot repair a mistaken category layout or incorrect observations.

When to use a different chart

A box plot is especially useful when comparing distributions across several groups and when medians, variability, and potential outliers are more important than showing every value. A histogram is often more informative when you want to see the shape of one distribution, such as whether it is skewed or has multiple peaks. A dot plot or scatter-style display can make individual observations easier to inspect, particularly with a modest number of values.

For a small dataset, a box plot may hide more than it reveals: the summary can be dominated by a few observations, and readers may want to see the actual points. For a large dataset, showing every inner point can create clutter. Choose the display that matches the question, and consider pairing the box plot with a count or a table of summary statistics rather than expecting one chart to answer everything.

Frequently Asked Questions

Can I make a box plot in Excel with one data column?
Yes. Select the column of numbers, optionally including its heading, and insert a Box and Whisker chart. The result summarizes that one group; additional columns let you compare multiple groups.

Does Excel show the average on a box plot?
It can. Right-click the data series, choose Format Data Series, and enable the mean marker or mean line under Series Options. The median is a separate feature and remains the line inside the box.

Do I need to sort the data first?
No. Excel calculates the quartiles and other chart elements from the selected numeric observations. Sorting may help you inspect the data, but it is not a requirement for creating the chart.

Why does my Excel box plot differ from another program?
Quartile conventions can differ, and Excel lets you choose inclusive or exclusive median calculations. Check the calculation setting, sample values, and treatment of missing or unusual observations before comparing the charts.

Can I create a box plot in Excel online?
Support and available chart commands can vary in Excel for the web. If you cannot find Box and Whisker under the Insert chart options, open the workbook in desktop Excel, create the chart there, and then save the workbook.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.