Skip to main content

Now you can ask Google Sheets to make a graph for you

google sheets graph update googlesheet01
Google
Google’s latest update for its Sheets spreadsheet tool makes it easier to give it commands through the use of natural language. New commands can include asking it to make a chart or graph, thereby presenting you with a visualization of data without the need to click through a bunch of menus to make it a reality.

Sheets already supports the ability to ask a dataset a question, but Google’s latest additions make it even easier to visualize this. Inputting commands such as “bar chart of X” (thanks Verge) will output the dataset you’re interested in, but in a much more visual form. You can then use it alone or quickly insert it into the document so that others can benefit from its summation of information.

Alongside the language improvements of Sheets, Google’s new update also helps synchronize data between tables in Sheets, Google Docs, and Slides. Hitting the ‘update’ button within any document will refresh the dataset in the others, keeping them all sychronized and letting you jump between different files without having to manually copy over information.

That could also aid collaboration, with multiple people working on different documents all having access to the latest data.

For those who want to print off the spreadsheets they’re working on, the interface for doing so has been overhauled. You can now tweak the margins and change the scale and alignment of various aspects of the document. There is also the ability to clone rows and columns as part of the print process.

Charts have seen improvements with a new sidebar, too. This adds the ability to create 3D charts and graphs, which along with the new language commands could open up a whole new way to order your datasets.

Of course if these updates don’t excite you too much or you’d rather not use Google Sheets altogether, we do have a handy list of alternatives you can try out.

Editors' Recommendations

Jon Martindale
Jon Martindale is the Evergreen Coordinator for Computing, overseeing a team of writers addressing all the latest how to…
This Google Chrome feature may save you from malware
Google Chrome app on s8 screen.

There are probably hundreds of thousands of Google Chrome extensions out there, and with so many options to choose from, it can be hard to know whether the plugin you want to install is hiding malware nasties.

That could become a thing of the past, though, as Google is testing a feature that will warn you if an extension you installed has been removed from its Chrome Web Store.

Read more
You can now ‘expand’ images in Photoshop using AI
Adobe's Generative Expand feature in Photoshop.

Adobe is updating its Photoshop app with a new AI-powered feature that will allow you to easily make an image larger and add context to the image based on its original subject.

The feature, called Generative Expand, is now available to Photoshop beta users. You'll be able to expand images in any direction and generate an additional scene for the space with a combination of traditional app tools and AI. It uses Photoshop's crop tool in conjunction with a text field for a prompt to create the details for the image you want to add.

Read more
Google Bard can now speak, but can it drown out ChatGPT?
Google Bard on a green and black background.

In the world of artificial intelligence (AI) chatbots, OpenAI’s ChatGPT is undoubtedly the best known. But Google Bard is hot on its heels, and the bot has just been granted a new ability: the power of speech.

The change was detailed in a Google blog post, which described the update as “Bard’s biggest expansion to date.” It grants Bard not just speech, but the ability to converse in over 40 languages, use images as prompts, and more.

Read more