{"id":342518,"date":"2017-06-02T01:00:35","date_gmt":"2017-06-01T17:00:35","guid":{"rendered":"http:\/\/techcrunch.com\/?p=1498237"},"modified":"2017-06-02T01:00:35","modified_gmt":"2017-06-01T17:00:35","slug":"google-sheets-now-uses-machine-learning-to-help-you-visualize-your-data","status":"publish","type":"post","link":"https:\/\/people.utm.my\/asmawisham\/google-sheets-now-uses-machine-learning-to-help-you-visualize-your-data\/","title":{"rendered":"Google Sheets now uses machine learning to help you visualize your data"},"content":{"rendered":"

<\/p>\n

Google Sheets is getting smarter today<\/a>. After adding the machine learning-powered \u201cExplore<\/a>\u201d feature last year, which lets you ask natural language questions about your data, it\u2019s now expanding this feature to also automatically build charts for you. This means you can now simply ask Sheets to give you a \u201cbar chart for fidget spinner sales\u201d and it will automatically build one for you.<\/p>\n

All of this is backed by the same natural language understanding tech that already powered the \u201cExplore\u201d feature. It\u2019s worth noting that the previous version of \u201cExplore\u201d could already build graphs for you, but those focused on your complete data set. It didn\u2019t allow you to get graphs that answered specific questions.<\/p>\n

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.<\/p>\n

Other new features include an improved printing experience for when you really need to see your numbers on a piece of paper \u2014 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\u2026); and support for new keyboard shortcuts.<\/p>\n","protected":false},"excerpt":{"rendered":"

\"\" 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… Read More<\/a><\/p>\n

\n<\/img><\/a> <\/img><\/a> <\/img><\/a> <\/img><\/a> <\/img><\/a> <\/img><\/a>\n<\/div>\n

\"\"\/ <\/p>\n","protected":false},"author":5817,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[25],"tags":[59,66,26],"class_list":["post-342518","post","type-post","status-publish","format-standard","hentry","category-technology","tag-media","tag-techcrunch","tag-technology"],"_links":{"self":[{"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/posts\/342518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/users\/5817"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/comments?post=342518"}],"version-history":[{"count":0,"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/posts\/342518\/revisions"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/media?parent=342518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/categories?post=342518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.utm.my\/asmawisham\/wp-json\/wp\/v2\/tags?post=342518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}