Google Sheets Can Now Make Charts on Request Using Machine Learning

Google Sheets Can Now Make Charts on Request Using Machine Learning


  • The updates are already available on Android and iOS
  • Explore feature was added to the app last year
  • Update adds support for spreadsheet shortcuts to the Web version

Google Sheets is already a useful productivity tool but the search giant has now updated it to add some more machine learning features. While users could already ask questions from Sheets to get data-related responses using Explore feature, machine learning now allows the app to create charts demanded by the users.

With the latest update, if users cannot see a chart that they need for their project or presentation, they can simply ask the app to create it for them. “Instead of manually building charts, ask Explore to do it by typing in ‘histogram of 2017 customer ratings’ or ‘bar chart for ice cream sales’. Less time spent building charts means more time acting on new insights,” the search giant said in its blog post.

google sheet story2 Google Sheets Story 2

Notably, users could already ask Google Sheets queries like “what is the distribution of products sold?” or “what are average sales on Sundays?” to get responses from the Explore feature, which was added last year.

Further, the giant has made it easier to keep your tables updated as users can now copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync their data.

Apart from these updates, Google has also added the support for spreadsheet shortcuts to the web version of the app. The latest update is already available on both Android and iOS and can be downloaded through Google Play store or the App Store respectively.


Zoho Chartistic Lets You Easily Create Graphs and Charts

Zoho Chartistic Lets You Easily Create Graphs and Charts
Zoho Chartistic is free via the App Store
It lets you make graphs and pie charts
The app is very easy to use
Numbers and data are a part of everyone’s lives whether they release it or not. From simple things such as a sheet for daily expenses, to more complex things like a scorecard, charts and graphs definitely make numbers a lot less intimidating. We find it much easier to visualise data when looking at images as opposed to trying to remember numbers.

Zoho Chartistic is a free iPhone app that lets you make charts and we used it to find out whether it works for our charting needs.

The USP of Zoho Chartistic is making it easy to create charts, and the app is certainly easy enough to use. Hit the + button to create a new chart, and the app asks you to choose one out of five types of charts. Each of these are represented by icons only, which is a good thing considering this app is for people new to making charts.

Once you select a chart, the app creates a chart with some random data. This is again a nice thing because you don’t have to figure out how to create a chart. Quickly we figured out that swiping downwards lets you edit values manually, and dragging any of the nodes lets you adjust values on the chart itself. Swiping sideways opens the settings menu where you can adjust a bunch of details such as whether or not you want to see the grid and borders.

zoho chartistic expenses Zoho Chartistic

The charts we made using this app looked quite good but the app’s interface could use some improvements. While flipping between different chart modes we discovered a bug that took half the chart off the screen; the only fix was to force quit the app. We encountered another freeze when changing multiple options in the settings menu. We tested the app on an iPhone 7, so the bugs are not due to slow or old hardware, but likely down to the fact that it’s a new app and not all bugs have been ironed out yet.

The settings and editing screens don’t look anywhere near as neat and polished as the charts themselves, but they get the job done. We’d have liked to have finer control over which colour to use for which bar or pie, but this feels like a design decision to keep the app simple. Tapping a button flips all the colours on your bar or pie chart, so eventually you are likely to find a colour scheme you like.
One neat feature of this app is clip arts. You can download clip art through the app itself and use it to help people visualise data. We created one showing the globe and a man on it, to highlight humanity’s adverse effect on the environment.

Once you’re done with a chart you have to hit the Save button to prevent it from disappearing. This is another issue the app needs to address – automatic, cloud saving has become the norm with most modern applications, and having to hit save before quitting feels archaic. All apps should automatically save your progress no matter which stage you’re in. The app froze once while we were fiddling with settings and after force quitting, we lost the chart we’d worked on for 15 minutes. This is the kind of experience the developers should work to avoid.

zoho chartistic drought Zoho Chartistic

Once you’ve saved a chart, you can open it again anytime and continue editing. The app uses the standard iOS share sheet to help you send charts to friends or post it online.

If making charts and graphs isn’t something you’d normally do, Zoho Chartistic offers a fun way to make these. The app has a few issues that need to be ironed out but for the most part it is beginner-friendly and helps you turn boring, raw data into fun visuals.

Zoho Chartistic is a free download via the App Store.

For the latest coverage from the Consumer Electronics Show in Las Vegas, visit our CES 2017 hub.
Tags: Zoho, Zoho Chartistic, Charts, Graphs, iPhone, iOS, Apple, App Store


Twitter Charts Solo Path as Salesforce Rules Out Takeover

Twitter Charts Solo Path as Salesforce Rules Out TakeoverHIGHLIGHTS

  • Salesforce said on Friday that it would not make a bid
  • Twitter CEO Jack Dorsey may now have to chart an independent course
  • Dorsey is likely to face intense scrutiny over his continued role as CEO

Twitter Inc faces an uncertain future after Inc , the last of the companies believed to be interested in buying the troubled social network, said on Friday that it would not make a bid.

Twitter and Chief Executive Officer Jack Dorsey may now have to chart an independent course in the face of stagnant user growth, heavy losses and mounting competition from the likes of Facebook’s Instagram and Snap Inc’s Snapchat.

Dorsey is likely to face intense scrutiny over his continued role as CEO of both Twitter and the payment company Square , especially if the company’s next quarterly report in late October is as weak as some analysts expect.

Twitter grew rapidly for years after it was founded in 2006, and has assumed a unique and influential position in the global media ecosystem. But the company has been plagued by management turmoil since its earliest days and has long been criticized for a lack of product innovation and, more recently, lack of user growth.

Twitter last month hired bankers to field acquisition offers and companies including Alphabet and Disney expressed interest, according to sources familiar with the process. Google and Disney decided not to proceed, the sources said, leaving Salesforce, a provider of cloud computing software for businesses, as the last reported bidder.(Also see: Twitter Seeks New Path After Potential Bidders Said to Back Off)

But Salesforce investors reacted poorly to the idea, sending the company’s stock down when its interest in Twitter first emerged. Salesforce Chief Executive Marc Benioff said on Friday he had ruled out a bid.

“In this case we’ve walked away. It wasn’t the right fit for us,” Benioff told the Financial Times in an interview, saying there were many reasons the fit was not right, including price and the culture of the company.

A spokeswoman for Salesforce confirmed the comments. Twitter declined to comment.

Twitter’s shares closed 5 percent lower Friday at $16.88, while those of Salesforce rose 5 percent to $74.27.

Twitter had planned to wrap up any sale discussions by the time it reports earnings at the end of October, sources told Reuters earlier this week.

It is still possible that other bidders could emerge, according to people familiar with the matter. One source said the company may consider possible strategic investments rather than a buyout.

With a market cap of about $12 billion and losses running at about $400 million a year, Twitter was likely judged too expensive by prospective buyers.

(Also see: Twitter to Reportedly Conclude Sale Deliberations This Month)

Growth stalls
As an independent company, Twitter will likely need to address its unusual leadership situation, analysts said. Dorsey has split his time between Twitter and Square since he returned as Twitter’s permanent CEO about a year ago.

Investors are likely to pressure the company to appoint a “full-time” chief executive, said SunTrust Robinson Humphrey analyst Robert Peck.

“The most common question we receive from investors is given the struggling turnaround, doesn’t the company need a full-time CEO?” Peck said.

Dorsey sent a memo to employees earlier this month calling the company “the people’s news network,” and rallying them to “deliver a better Twitter faster.”

Twitter enjoyed a period of explosive growth in both users and revenues after its founding a decade ago, but growth has stalled over the past several years.

The company missed Wall Street’s sales expectations in both the first and second quarters of 2016, according to Thomson Reuters StarMine, and has yet to produce a net profit in 11 quarters as a public company. It will report third quarter results October 27, which SunTrust analyst Peck said he expects to be weak with data showing monthly active users flat or down.

To be sure, Twitter has become a focal point in the US presidential election. Many stories have unfolded on its service and comments made by the candidates have made big news themselves. No media company has a mobile product with as much reach as Twitter, BTIG analyst Rich Greenfield said.

Twitter has recently signed deals with a number of media companies and sports organizations to stream major events such as the presidential debates and Thursday Night National Football League games.

© Thomson Reuters 2016

Tags: Twitter, Salesforce, Social, Apps, Jack Dorsey

Pokemon Go Clones, Fake Apps Dominate Charts on iOS App Store

Pokemon Go Clones, Fake Apps Dominate Charts on iOS App Store


  • Pokemon Go is a new game for Android and iOS.
  • It is available in US, Australia, Japan, and New Zealand.
  • iOS users in other regions are downloading clone apps.

If you have an Android phone, there’s a good chance you’ve read our piece on how to download Pokemon Go. If you have an iPhone or an iPad unless you have an App Store account in US, Japan, Australia, or New Zealand, there’s no way to play Pokemon Go.

There is always an opportunity for clones and fake apps where the demand is high and supply low. Pokemon Go is no exception. We checked the top free apps charts on various App Store regions and it appears that several clones are rising up the ranks.

(Also see: Why Nintendo Making Mobile Games Is Great News for Everyone)

Pokemon Go appears to have caught on Android phones in India, judging only on how many people in India have shared their experiences via comments on Gadgets 360 and emails. In the meanwhile, several iPhone users seem to be downloading a fake app called Go Catch Em All. It’s among the top 10 free iOS apps on the Indian App Store. We’re not sure how Apple even approved this game as it uses a screenshot from Pokemon Go. That said, if you’re among those playing Pokemon Go in India, be sure to read our handy guide.

Most reviews of the game say that the game forces them to post a review to progress and that it looks nothing like what the screenshots suggest. This fake game is the most popular free app in Singapore, Germany, United Kingdom, among many other regions.

(Also see: Swing Copters the Latest to Get Lost in a Sea of Clones in App Stores)

China is one of the biggest markets for Apple and the iPhone is very popular there. The top free app in China is called City Elf Go. While it was released in March 2016, a few months before Pokemon Go, the concept – capturing elves in various locations – seems similar, even though this game doesn’t appear to have an augmented reality mode.

Several other clones such as Pocket Go Poke Evolution and Poke Poke Go are among top-ranked free apps across the world.

This shows that Nintendo, and the studio that developed this Pokemon – Niantic – didn’t anticipate just how popular this game would be. Come on Nintendo, just release it across the world already.

Tags: Android, Apps, Games, Gaming, How to download Pokemon Go, How to play Pokemon Go, Install Pokemon Go,Niantic, Nintendo, OnePlus 3, Pokemon, Pokemon Android, Pokemon APK download, Pokemon Go, Pokemon Go Android,Pokemon Go apk, Pokemon Go apk download, Pokemon Go free download, Pokemon Go Release Date,Pokemon Go Review, The Pokemon Company