Box Plot Multiple Columns in Excel: Setup and Tips

To create a box plot from multiple columns in Excel for Microsoft 365 on Windows, put each group of numeric observations in its own column, add a heading above each column, select the data, then choose Insert > Insert Statistic Chart > Box and Whisker. Excel creates a box for each column, so you can compare several groups in one chart.

What a multiple-column box plot shows

A box plot, also called a box-and-whisker chart, summarizes the distribution of values in a group. When you provide several columns, Excel treats them as separate groups or series and displays a box for each one. This makes the chart useful for comparing the spread and typical values of groups such as departments, product lines, test classes, or measurements taken at different times.

Each box represents the middle half of a group’s values, from the first quartile to the third quartile. The line inside the box marks the median. The difference between the quartiles is the interquartile range, often shortened to IQR. Whiskers extend to the most extreme values within the chart’s outlier limits, and values beyond those limits can appear as individual points. Depending on the chart settings, Excel can also show individual observations and the mean.

A box plot is a summary, not a display of every observation by default. Two groups can have the same median but very different spreads, or similar boxes but different numbers of outliers. Looking at the boxes alongside the sample sizes and, where appropriate, the underlying data gives a more complete comparison.

Arrange the data in columns first

Use one column for each group and one row for each observation. Put a descriptive heading in the top cell of each column. For example, a worksheet comparing three training methods could look like this:

Column A: Method A, with scores below the heading.
Column B: Method B, with scores below the heading.
Column C: Method C, with scores below the heading.

Keep the headings in the same row and the observations beneath them. Avoid merged cells, subtotals, extra notes inside the selected range, and text mixed into the measurements. A single rectangular range with clear headers is easiest for Excel to interpret. If you have a separate ID or date column, do not include it unless it is itself a numeric group you intend to chart.

Groups do not have to contain the same number of observations. If one column has fewer values, leave the remaining cells blank rather than filling them with zero or a placeholder. A zero is a real measurement and will affect the distribution; a blank means there is no observation in that cell. Check the selected range before inserting the chart so that every group heading and all intended numeric values are included.

Create the box plot in Excel

Arrange the data as described above, with one group per column and a header row.
Select the complete data range, including the headings. For example, select A1:C21 if the headings are in row 1 and the observations occupy rows 2 through 21.
On the ribbon, choose Insert > Insert Statistic Chart > Box and Whisker. Excel inserts a chart with one box for each data column.
Give the chart a clear title, and add axis titles or a legend if they help explain the comparison. Chart Design and Format tabs appear when the chart is selected.
Check that the boxes have the expected group names and that the values appear plausible before sharing or interpreting the result.

If Excel places the groups in the wrong direction, select the chart and choose Chart Design > Switch Row/Column. That command changes whether Excel treats rows or columns as separate series. With the usual one-group-per-column layout, you generally want a separate box for each column. If the chart has only one box, or many boxes representing individual rows, inspect the selected range and use Switch Row/Column as needed.

On Excel for Mac, the chart type is also available through the Insert tab’s statistical chart controls in supported desktop versions. Ribbon labels and placement can vary slightly by release. Excel for the web may not offer the same chart-creation or formatting controls; if you cannot find Box and Whisker, open the workbook in the desktop version of Excel.

Read the boxes and whiskers correctly

The median is the central line in each box, while the box runs from the first to the third quartile. A taller box in a vertical chart indicates a wider middle 50 percent of values. The whiskers show the spread beyond the box according to the chart’s outlier rule, and separate points beyond the whiskers are flagged as outliers by that rule. An outlier point is not automatically an error; it may be a valid unusual result that deserves investigation.

Excel lets you choose how it calculates quartiles. In the Format Data Series pane, the Quartile Calculation setting offers Inclusive Median and Exclusive Median. These methods can produce different quartile boundaries, especially with small samples, so the boxes may differ from another program’s chart or from a manually calculated summary. If a report, class, or analysis standard specifies a quartile convention, use that convention and state it when you present the chart.

Do not infer that one group is better solely because its median is higher or lower. The meaning depends on the measure: a larger response time may be undesirable, while a larger test score may be desirable. Also consider the amount of overlap, the spread, the sample sizes, and the process that generated the observations. A box plot describes the data; by itself it does not establish why groups differ or whether a difference is statistically meaningful.

Customize outliers, means, and points

To adjust a box plot, right-click a box and choose Format Data Series. The pane includes options for how the chart displays the data. Available options include showing inner points, showing outlier points, showing mean markers, and showing a mean line. A mean marker can help readers compare the average with the median; a noticeable difference between them can indicate skew or the influence of extreme values.

Use point displays with a purpose. Showing every observation can make a small dataset more transparent, but a large dataset may become visually crowded. Showing outliers alone keeps attention on unusually distant points while preserving a compact summary. Use a readable chart title, meaningful category names, and a consistent scale when comparing charts. Avoid relying only on color to distinguish groups, since labels and clear contrast also help readers who print in grayscale or have color-vision differences.

Handle blanks, unequal groups, and unusual values

Unequal sample sizes are common and do not prevent Excel from drawing a box for every column. However, a box based on a small group may be less stable than one based on a much larger group. Consider displaying the sample size in a nearby table or in the chart labels when the difference in group sizes matters to interpretation. Do not add artificial values just to make the columns the same length.

Before charting, check that entries intended as measurements are numeric. Numbers stored as text, error values, or stray words can lead to missing or unexpected results. Also distinguish a genuine zero from a missing measurement. If missing values are coded as text such as NA, remove or handle those entries in a clean charting range rather than allowing them to be treated as observations. Keep the original source data intact and make a separate tidy range if cleaning is needed.

Investigate surprising outliers rather than deleting them automatically. Check for data-entry mistakes, unit mismatches, duplicate records, and legitimate exceptional cases. If you exclude a value from a chart, document the reason and apply the same rule consistently across groups. A chart that hides inconvenient observations can give a misleading impression even if its formatting is correct.

Fix common multiple-column chart problems

Only one box appears: Confirm that the selected range includes more than one group column and that the observations are numeric. Try Chart Design > Switch Row/Column if Excel interpreted the layout differently.
Group names are missing or wrong: Include the header row in the selected range. If necessary, edit the chart’s data selection so the headers are used as series names.
A box or whisker looks unexpectedly compressed: Check for a very large value, a unit mismatch, or a genuine outlier that stretches the scale. Review the source values before changing the axis scale.
Zeros appear where values are missing: Replace placeholder zeros with genuinely blank cells in the charting range, if those positions represent missing observations.
The chart does not match another tool: Compare the quartile calculation settings and outlier rules. Different conventions can produce different quartiles, whiskers, and flagged points from the same data.

When adjusting the vertical axis, preserve a scale that allows fair comparison. A truncated axis can exaggerate small differences in medians or box heights. If the chart includes groups with very different ranges, explain any scale choice and consider whether separate panels would communicate the data more honestly.

When to use another chart

A box plot is a strong choice when the question concerns medians, spread, and unusual values across several groups. It is less suitable when readers need to see a trend over time for every individual observation, or when the sample is so small that a compact quartile summary conceals the actual data. A dot plot or a simple scatter chart can make individual values easier to inspect; a line chart is often clearer for ordered time measurements.

Excel’s Box and Whisker chart is preferable to manually drawing boxes with shapes because the chart updates from its source data and offers built-in quartile and point-display settings. A hand-built chart may still be useful when you need a specialized design or a convention Excel does not provide, but it requires extra calculations and careful maintenance. For routine comparisons, start with the built-in chart and verify that its settings match the question you are asking.

Frequently Asked Questions

Can I make one box plot chart from three or more Excel columns?
Yes. Put each group in its own column, select all the columns and their headings, then insert a Box and Whisker chart. Excel displays a box for each group.

Can columns have different numbers of values?
Yes. Leave unused cells blank in the shorter columns. Do not enter zeros unless zero is an actual observation, because zeros change the group’s distribution.

Why does Excel show one box for each row instead of each column?
Excel may have interpreted rows as the groups. Select the chart and use Chart Design > Switch Row/Column, then check that the labels and boxes correspond to the intended groups.

How do I show the average on a box plot?
Right-click a box, choose Format Data Series, and turn on Show mean markers. You can also show a mean line. The median remains the line inside the box; it is not the same as the mean.

Why are my quartiles different from another chart?
Quartile conventions differ. In Format Data Series, check whether Excel is set to Inclusive Median or Exclusive Median, then compare that choice with the method used by the other chart or analysis.

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.