Create box and whisker charts in Google Sheets

Google Sheets now natively supports box and whisker charts, a statistical chart type that shows how a dataset is distributed. Select a range of raw numeric values and Sheets calculates the minimum, first quartile, median, third quartile, maximum, mean, and outliers for you, with no helper formulas needed. You can choose inclusive or exclusive quartile calculation and show or hide inner points, outliers, mean markers, and mean lines.

Box and whisker support also comes with enhanced Microsoft Excel import compatibility. Previously, importing Excel files containing box and whisker charts into Sheets would drop the chart entirely. Now, these charts are preserved on import with their data references, calculations, and formatting intact, and charts created in Sheets export back to Excel as editable box and whisker charts.

User creating a box and whisker chart in Google Sheets

Getting started

• Admins: There is no admin control for this feature.
• End users: Visit the Help Center to learn more about adding and editing a chart in Google Sheets.

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 22, 2026 
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 6, 2026

Availability

• Available to all Google Workspace customers and users with personal Google accounts

Resources

• Google Docs Editors Help: Add & edit a chart or graph