What changed: Google Sheets now natively supports box and whisker charts. Selecting a range of raw numeric values makes Sheets calculate the minimum, first quartile, median, third quartile, maximum, mean, and outliers automatically, with no helper formulas needed. Users can choose inclusive or exclusive quartile calculation and show or hide inner points, outliers, mean markers, and mean lines. Box and whisker charts imported from Microsoft Excel are now preserved with their data references, calculations, and formatting intact, and charts created in Sheets export back to Excel as editable box and whisker charts.
Who is affected
All Google Workspace customers and users with personal Google accounts.
What it means for your business
For businesses using Google Sheets, this means distribution analysis can be done by simply selecting raw numeric data and picking a box and whisker chart, without writing helper formulas, and Excel-imported charts of this type now open correctly instead of being dropped.
What to do
Select the raw numeric data range you analyze in Sheets and try the box and whisker chart type; adjust inclusive/exclusive quartile calculation and the visibility of inner points, outliers, and mean markers/lines as needed.
When it takes effect
Starts October 22, 2026 for Rapid Release domains and November 6, 2026 for Scheduled Release domains; both follow a gradual rollout of up to 15 days for feature visibility.
Source: https://workspaceupdates.googleblog.com/2026/10/create-box-and-whisker-charts-in-google-sheets.html
