What changed
Sheets now natively supports box and whisker charts, a statistical chart type that shows how a dataset is distributed. You select a range of raw numeric values. Sheets then calculates the minimum, first quartile, median, third quartile, maximum, mean and outliers, with no helper formulas needed. You can choose inclusive or exclusive quartile calculation. You can also show or hide inner points, outliers, mean markers and mean lines.
That ends a long-standing workaround. Older tutorials, such as one from Apipheny, built a box plot in Sheets in three steps:
- Compute the minimum, quartiles and maximum with separate formulas.
- Select those cells.
- Insert a chart and switch it to a candlestick type.
That approach was always an imitation. Now the chart does the calculating itself.
The Excel half of the update
This is a narrow fix, not a broad compatibility overhaul. Before the update, importing an Excel file containing a box and whisker chart into Sheets dropped the chart entirely. Now these charts are preserved on import with their data references, calculations and formatting intact. Charts created in Sheets export back to Excel as editable box and whisker charts.
Android Authority framed the release as Sheets finally catching up to Excel. Box plots have been a built-in Excel chart type for years. Microsoft's support page describes them as an Excel statistic chart reached through Insert > Insert Statistic Chart > Box and Whisker. It lists the same family of options Google now offers:
- Show inner points
- Show outlier points
- Show mean markers
- Show mean line
- Inclusive or exclusive quartile calculation
For mixed Excel and Sheets teams, matching controls should make charts easier to carry across. That is my inference from the feature lists. Google's announcement doesn't claim the two apps' charts will look identical.
Rollout and availability
Google's schedule gives the following:
- There is no admin control for this feature.
- Rapid Release domains: a gradual rollout of up to 15 days for feature visibility, starting October 22, 2026. I am reading the 15-day window and the start dates from the same Google Workspace Updates post.
- Scheduled Release domains: the same up-to-15-day gradual rollout, starting November 6, 2026.
- Availability: all Google Workspace customers and users with personal Google accounts.
Note that November 6 is when the Scheduled Release rollout starts. Windows Report's wording suggests it finishes then, which doesn't match Google's own post. Don't plan around the earlier reading. If your domain is on Scheduled Release, expect the chart to appear somewhere between November 6 and about three weeks later. Since there is no admin switch, an administrator can't turn it on early.
Using it well
Google's announcement points users to the standard Help Center guidance on adding and editing charts. It doesn't give a dedicated menu path for the new box-plot controls, so I won't invent one. The general route to a chart is to select your data and use Insert > Chart. I haven't tested where the box-and-whisker options sit in the chart editor.
Some practical cautions:
- Choose the quartile method deliberately. Inclusive and exclusive calculations can give different quartile values on the same data. Pick the one your team or field uses, and use it consistently on both sides of an Excel-to-Sheets handoff.
- Treat outliers as prompts to investigate. A flagged point is a statistical signal, not proof the data is wrong. Google's announcement doesn't state the rule Sheets uses to classify outliers. One common convention, described in NIST's engineering handbook, is to draw fences at 1.5 times the interquartile range beyond the quartiles. I can't confirm Sheets follows it, so check before you rely on it.
- Test your own files. Google promises preservation of data references, calculations and formatting for box-and-whisker charts. It makes no promise about every chart type or workbook feature. It also doesn't state any Excel version requirement or any device-specific behavior.
Why it matters
Box plots suit comparing groups. NIST's handbook says they are an excellent tool for showing location and variation shifts between different groups of data. They are common in lab results, performance benchmarking and survey analysis. Excel shops that share files with Google-first colleagues have had one fewer chart that vanishes in transit.
The honest caveat is scope. This closes one gap for one chart type. Anyone relying on advanced Excel charts should still verify a round trip before sending a deadline-critical workbook.
References
- Google Sheets Gets Smarter With New Charts and Excel Support Windows Report · 2026-10-23T08:11:06+00:00
- How To Make A Box & Whisker Plot in Google Sheets - Apipheny apipheny.io
- Create a box and whisker chart | Microsoft Support support.microsoft.com