Google Sheets Gets Analytics, Visualization Features
Designed to enable users to do more with their data, the new features give users more options for visualizing and analyzing data in their spreadsheets.Google is giving users of its Sheets software more options for visualizing and analyzing data in their spreadsheets. Among the new tools Google announced Monday for analyzing spreadsheet data was one that allows users to preview formula results instantly, as users type the formula. Dan Gundrum, Google product manager, described the feature as unique to Sheets and said that it is designed to help users catch basic formula errors more easily than was previously possible. Monday's update also allows Sheets users to filter rows and columns using qualifiers like "greater than" or "text contains" to filter out data that a user might not want to view in response to a query. The feature allows users to get only the dates, text and numbers they specifically need, Gundrum said. In addition, Sheets users will now be able to add a calculated field to their pivot table that performs calculations based on the other data in the pivot field, he said. A GETPIVOTDATA function, meanwhile, enabled easier data retrieval from the pivot table, Google said.
In addition to the analytics tools, Google has also tweaked the data visualization support in Sheets. One example is a new "data labels" feature in Sheets that lets users display the exact value of points or bars in a spreadsheet. Another new feature lets users change the shape of their data points when using line or scatter graphs to display data graphically, Google said.