Google announced an update to Google Sheets, its spreadsheets application. Users can now add data labels to display exact values of bars or points. When the user uses line or scatter charts, they can change the shapes of data points, including stars, triangles, pentagons, etc.
When you’re working with spreadsheets, it’s important to turn your raw data into a story. With today’s updates to Google Sheets on the web, you’ll find even more ways to visualize and analyze your data,” says product manager Dan Gundrum. “Charts can make even the largest data sets digestible, so we’ve made a few improvements to help you highlight what’s most important.”
There are also new tools for analyzing spreadsheet data, including the ability to preview formula results as you type so you can more easily spot errors.
You can filter rows and columns by conditions such as “greater than” or “text contains” so you’ll only see the numbers, dates, and text you need. You can also add calculated fieldds to “pivot tables when you want to apply formulas to pivot table data.”
Finally, you can use the GETPIVOTDATA function to more easily get data from your pivot table.
“The more the merrier when it comes to collaborating in Sheets, but sometimes you need to take extra steps to preserve your hard work from accidental edits. With Sheets, you’ve been able to restrict editing to a specific set of users and a specific range, but now you can also warn folks who try to edit certain cells. This way you can collaborate with others, and remind everyone (even yourself) to edit with care.”
The new features are available for Sheets on the web.