CONNECT WITH US
Gaming

Gaming

Google Sheets is finally catching up to Excel with support for more chart types

Android Authority — Games logo

Published on

Add as a preferred source on Google
Google Sheets is finally catching up to Excel with support for more chart types

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.



Source link
Related Topics:Gaming

Disclaimer

We strive to uphold the highest ethical standards in all of our reporting and coverage. We TheMorningPulse.fyi want to be transparent with our readers about any potential conflicts of interest that may arise in our work. It's possible that some of the investors we feature may have connections to other businesses, including competitors or companies we write about. However, we want to assure our readers that this will not have any impact on the integrity or impartiality of our reporting. We are committed to delivering accurate, unbiased news and information to our audience, and we will continue to uphold our ethics and principles in all of our work. Thank you for your trust and support.