Credit: Edgar Cervantes / Android Authority
TL;DR
- Google Sheets is rolling out support for box and whisker charts.
- If you select a range of numeric values, Sheets will calculate the minimum, first quartile, median, third quartile, maximum, mean, and outliers automatically without helper formulas.
- Box and whisker charts imported from Excel are now preserved, with data references, calculations, and formatting intact.
Box and whisker charts are useful for displaying the distribution of data within a population. While they have long been a staple for Microsoft Excel, that hasn’t been the case for Google Sheets. However, Google is fixing that problem with a new update.
Google Sheets is finally gaining native support for box and whisker charts. When you want to create one, you’ll just have to select a range of raw numeric values. Google says Sheets will automatically calculate the minimum, first quartile, median, third quartile, maximum, mean, and outliers for you. And best of all, you won’t need to use any helper formulas to accomplish this.