Parallel Box Plot in Excel: Create and Read One

To make a parallel box plot in Excel, put each group’s numeric observations in a separate column, select the data and headers, then choose Insert > Insert Statistic Chart > Box and Whisker. Excel places one box for each column in the same chart, making it easy to compare medians, spreads and outliers across groups.

What a parallel box plot shows

A parallel box plot, also called a side-by-side box plot or grouped box plot, displays the distributions of two or more data groups on a shared scale. Each box summarizes one group rather than showing every value as a separate chart. The shared axis matters: all boxes can be compared against the same units and range.

The box runs from the first quartile (Q1) to the third quartile (Q3), so it covers the middle half of the observations. A line inside the box marks the median. The distance from Q1 to Q3 is the interquartile range, or IQR. In Excel’s standard box-and-whisker chart, whiskers reach the lowest and highest values within 1.5 times the IQR from the box; values beyond that range appear as individual outlier points when outliers are displayed.

For example, a researcher might compare delivery times for three shipping methods, or a teacher might compare test scores across four classes. The plot can reveal whether one group typically has higher values, whether its results vary more, and whether unusual observations deserve investigation. It does not, by itself, explain why the groups differ or establish that a difference is statistically meaningful.

Arrange the data before charting

Use one column per group and put a clear group name in the first row. Put each observation below its heading. For example, columns labelled Method A, Method B and Method C could contain delivery times in days. Each row is one measured delivery; row numbers do not need to represent matched cases unless your study design says they do.

Groups do not have to contain the same number of observations. Put each group’s values under its own heading and leave unused cells blank. Do not fill short columns with zeros: a zero is a real numeric observation and can distort the chart. Check that measurements use the same units and that the cells contain numbers, not numbers stored as text. Remove labels, notes and subtotal rows from the selected data range.

Before charting, consider whether the groups are genuinely comparable. Comparing ages in years with distances in kilometres on one axis is not meaningful. Likewise, a group with only a few observations may produce a box that looks precise even though its summary is based on limited data. Keep the sample size in mind, and consider adding it to the chart or its caption.

Create the chart in Excel for Microsoft 365

Arrange the data in columns, with a heading above each group.
Select the full range, including the headings and numeric observations.
On the Windows ribbon, choose Insert > Insert Statistic Chart > Box and Whisker. In some ribbon layouts, the statistical chart choices appear under Insert > Charts.
Excel inserts a chart with one box for each data series. Add a descriptive chart title and axis title using the chart elements controls if the chart needs more context.
Check that the group names appear along the category axis. If Excel has treated rows as series instead of columns, select the chart and use Chart Design > Switch Row/Column.

On Excel for Mac, select the data and use the Insert tab to find the statistical chart options and Box and Whisker; the ribbon placement can differ from Windows. Excel for the web may not offer the same chart creation and formatting controls in every account or release. If the option is missing, open the workbook in the Microsoft 365 desktop app rather than substituting a different chart type without checking what it shows.

After insertion, resize the chart so category labels and outlier points are visible. A very short chart can make small differences in medians difficult to see, while an excessively wide vertical axis can flatten the boxes. Use a clear title that identifies the outcome and groups, such as Delivery time by shipping method, rather than a generic title such as Box and Whisker.

Format quartiles, points and markers

To adjust the chart, right-click one of the boxes and choose Format Data Series. The pane provides options for the box-and-whisker series, including the quartile calculation and display of points and markers. The exact options can vary with Excel version and chart selection. Make changes deliberately, because options can alter what readers see without changing the underlying observations.

Quartile calculation: Excel offers inclusive and exclusive median approaches. They can yield different quartile boundaries, especially in small samples. Use one approach consistently when comparing charts, and state the method if the choice is important to your audience.
Show outlier points: Turn this on to display observations beyond the whisker limits as individual points. An outlier is not automatically an error; check the original record and the context before excluding it.
Show inner points: This displays individual observations within the whiskers. It can help readers see sample density and repeated values, but a large dataset may become visually crowded.
Show mean markers or mean line: These options add the average as a marker, or connect means across groups. The mean and median answer different questions, so label the mean clearly and avoid implying that a connecting line represents a continuous trend when groups are categories.

Keep visual styling restrained. Use a consistent fill for boxes unless colour carries a specific, explained meaning. Avoid assigning a separate colour to every group simply for decoration; extra colours can make a comparison harder to scan. If the chart is printed in grayscale or viewed by people with colour-vision differences, make sure labels and positions still distinguish the groups.

How to interpret boxes and whiskers

Compare the median lines first to see which groups have higher or lower typical values. Then compare box heights: a taller box means a larger IQR and greater spread among the middle half of that group’s observations. A short box means those central values are more tightly clustered, but it does not mean every observation is close together.

Next, inspect whiskers and plotted points. Long whiskers suggest a wider range outside the central half, while isolated points may indicate unusual cases or data issues. A group can have the same median as another group but a much wider box, indicating similar central values with different variability. Conversely, boxes may overlap even when medians differ; overlap in a box plot is not a formal significance test.

Consider a comparison of commute times for three routes. Route A might have the lowest median and a compact box, making it look both faster and more consistent. Route B might have a similar median but a longer upper whisker and several high outliers, suggesting occasional delays. Route C might have a higher median but a narrow box, indicating that its longer commute is relatively predictable. Those are descriptive interpretations, not proof of the causes of delay.

Always read the axis units and scale. A truncated vertical axis can exaggerate small differences; a very broad axis can conceal them. If the groups have very different sample sizes, show sample counts nearby or provide them in a caption. A box plot summarizes distributions, but it does not show every detail, such as multimodal clusters or the exact frequency of repeated values.

Common problems and practical fixes

Only one box appears: Check that each group is in its own column and that the selected range includes every column. Use Chart Design > Switch Row/Column if Excel has interpreted the orientation incorrectly.
Group names are missing: Include the header row in the selection. If the chart already exists, check whether Excel used the first row as series names rather than treating it as data.
A box looks unexpectedly distorted: Look for a value entered in the wrong units, a decimal-place error, or a legitimate extreme observation. Confirm the source data before changing the scale or removing a point.
Zeros appear at the bottom: Check for placeholder zeros used where observations were unavailable. Replace them with genuinely blank cells if no measurement exists; do not replace a meaningful measured zero.
Quartiles differ from another program: Statistical software can use different quartile conventions, particularly for small samples. Compare the selected convention and sample handling before concluding that Excel is wrong.
The chart is too crowded: Reduce unnecessary gridlines, widen the plot area, or turn off inner points for very large datasets. If there are many groups, split them into related charts while keeping the same axis scale.

Box plot versus other Excel charts

A box plot is useful when the distribution and spread matter, especially across several groups. A column chart of averages is simpler when the main message is a group mean, but it hides variation unless you add appropriate error bars. A histogram shows the shape of one distribution in more detail, while a scatter plot can reveal relationships between two numeric variables or show every observation directly.

For small datasets, a dot plot or strip plot can make individual values easier to inspect than a box plot. Excel does not provide every specialized chart type as a built-in option, so creating one may require a carefully constructed scatter chart or another tool. Avoid choosing a box plot solely because it is available: use it when readers need a compact comparison of medians, quartiles and potential extremes.

For a more complete report, pair the box plot with a short table containing group sample sizes and, where relevant, means or standard deviations. Those measures complement rather than replace the plot. If the goal is to test a hypothesis, choose an appropriate statistical method based on the study design and assumptions; the chart is a visualization, not a test.

Frequently Asked Questions

Can Excel make a box plot with multiple groups?
Yes. Put each group in a separate column, include the headings, select the data and insert a Box and Whisker chart. Excel creates a side-by-side box for each series.

How do I add a box-and-whisker chart in Excel?
Select the grouped data, then choose Insert > Insert Statistic Chart > Box and Whisker on Windows. If you cannot find that command, confirm that you are using a desktop version that supports the chart type.

What do the dots outside an Excel box plot mean?
When outlier points are displayed, dots beyond the whiskers mark observations outside Excel’s whisker limits. They are flags for review, not automatic evidence of incorrect data.

Why are my Excel box plot quartiles different from another chart?
Different tools or settings can use different quartile definitions. Excel’s inclusive and exclusive median options can also produce different boundaries, particularly with small samples.

Can I make a box plot when groups have different sample sizes?
Yes. Put each group’s available observations in its column and leave unused cells blank. Do not enter zeros to make the columns the same length, because zeros will be plotted as data.

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.