Google Sheets adds native box and whisker charts

Google Sheets now natively supports box and whisker charts. Selecting a range of numeric values automatically computes the minimum, quartiles, median, maximum, mean and outliers without helper formulas. Charts imported from Excel keep their data references, calculations and formatting.

• Sheets auto-calculates min, quartiles, median, max, mean and outliers
• No helper formulas are required to build the chart
• Excel-imported box plots retain data references and formatting