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.