Charts-Data Labels_Shapes

Google is updating its Google Sheets spreadsheet app on the web today with a few new features and improvements. First up, the updated app now includes new customization options for charts including the ability to add data labels as well as shapes to denote data points including stars, triangles, and pentagons.

Some of the other new features arriving today include a preview for formula results in real-time when typing, the ability to filter rows and columns by “greater than” and “text contains”, and an option to add calculated fields “to pivot tables when you want to apply formulas to pivot table data.”

Google adds that you’ll also now be able to “Use the GETPIVOTDATA function to more easily retrieve data from your pivot table.”

Lastly, Google has a new option to present a customized warning message to collaborators that attempt to edit something they shouldn’t (pictured below):

Heads Up.pngYou can check out the updated Google Sheets web app now.

FTC: We use income earning auto affiliate links. More.


Check out 9to5Google on YouTube for more news:

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel

About the Author