Skip to main content

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

google sheets graph update googlesheet01
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…
All of the internet now belongs to Google’s AI
ChatGPT versus Google on smartphones.

Google's latest update to its privacy policy will make it so that the company has free range to scrape the web for any content that can benefit building and improving its AI tools.

“Google uses information to improve our services and to develop new products, features, and technologies that benefit our users and the public,” the new Google policy says. “For example, we use publicly available information to help train Google’s AI models and build products and features like Google Translate, Bard, and Cloud AI capabilities.”

Read more
5 amazing AI features in Photoshop you can use now
A modern couple in a medieval scene that includes a flying Santa, crowns, and a flamingo gives an example of Photoshop AI.

Photoshop is one of the most versatile and powerful photo and image editing tools available, and Adobe is adding amazing new AI features to make it even better.

AI is also coming to Illustrator and Adobe Express. I took a look at how Adobe is expanding possibilities with AI and the results are impressive and easy.
AI image generation
Photoshop beta has AI image generation capabilities. Digital Trends

Read more
You can make the Apple Vision Pro even more expensive with a luxury leather headband
BandWerk's Vision Pro headset in Orange.

A new Apple product means one thing: accessories. Despite the fact that Apple's Vision Pro headset isn't coming out until early next year, we're already seeing third-party accessories for tricking it out.

The first batch comes from iPhone case maker BandWerk, who announced five luxury leather headbands for the upcoming headset. As if the $3,500 base price of the Vision Pro wasn't enough, you'll need another $160 for one of BandWerk's headbands -- though, I suppose that's a minor cost considering how much the headset is on its own.

Read more