How to Insert a Box Plot in Excel

What this does

A box and whisker plot (box plot) summarises a distribution with five numbers: minimum, first quartile, median, third quartile and maximum. The box spans the interquartile range, the line inside it is the median, the whiskers reach the furthest points within 1.5×IQR, and anything beyond that is drawn as an individual outlier dot. Excel 2016 and later ship it as a native chart type, so you no longer need the old stacked-bar workaround. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “insert a box plot in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a visual that makes the number obvious at a glance into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

A2:A41 holds 40 support-ticket resolution times in hours. Select A1:A41 and choose Insert ▸ Insert Statistic Chart ▸ Box and Whisker. If the box runs from 3 to 9 with a median line at 5, half of all tickets closed between 3 and 9 hours; a dot at 46 hours is flagged as an outlier rather than being averaged away. A box plot is the fastest honest way to compare several groups at once: it shows level, spread and outliers together, so a difference in averages is never presented without the variation behind it. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “insert a box plot in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.

Common mistakes

• Building it from summary statistics instead of raw values — the chart needs the individual observations to compute quartiles itself.
• Comparing groups of very different sample sizes without saying so; a box drawn from 6 points looks as authoritative as one drawn from 600.
• Leaving the default Exclusive median when the rest of the analysis uses QUARTILE.INC, which shifts the box edges.
• Reading the whisker ends as the true minimum and maximum — they stop at 1.5×IQR, and points beyond are plotted separately.

Frequently asked questions