Register Interest
IP EXPOCyber SecurityDeveloperAI and AnalyticsIoTBlockchain

Google Sheets now uses machine learning to help you visualize your data

Monday 19 June 2017

Google Sheets is getting smarter today. 

Google Sheets is getting smarter today. After adding the machine learning-powered “Explore” feature last year, which lets you ask natural language questions about your data, it’s now expanding this feature to also automatically build charts for you. This means you can now simply ask Sheets to give you a “bar chart for fidget spinner sales” and it will automatically build one for you.


All of this is backed by the same natural language understanding tech that already powered the “Explore” feature. It’s worth noting that the previous version of “Explore” could already build graphs for you, but those focused on your complete data set. It didn’t allow you to get graphs that answered specific questions.

With this new version, Google also is making it easier to keep in sync data from Sheets that you use in Docs or Slides. You could already update charts you copy into Docs and Slides with just a click, but now you also can do the same with tables.

Other new features include an improved printing experience for when you really need to see your numbers on a piece of paper — and when that paper needs to have exactly the right margins and alignment; a new chart-editing experience; a number of new statistical functions like CHISQ.INV.RT, which returns the inverse of the right-tailed probability of the chi-squared distribution (I have no idea what that means…); and support for new keyboard shortcuts.

Digital Transformation Europe EXPO 9-10 October 2019

Register Interest

IP EXPO takes place on 9-10 October 2019 at ExCeL London. This unmissable event is your one stop shop for digital transformation and covers every vertical you need to consider for successful implementation. Including network and hardware, cybersecurity, developer community, AI and analytics, IoT and Blockchain.