Box Chart 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. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “box chart 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 chart 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. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “box chart excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

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