Google Workspace Changes

Break out a single value within a pie chart in Google Sheets

Google Sheets now allows users to highlight a specific slice of a pie or donut chart by 'pulling it out,' providing more control over chart aesthetics and better visibility for the most important data points.

Break out a single value within a pie chart in Google Sheets

You can now “pull out” and highlight a slice from a pie or donut chart in Google Sheets. This feature gives you more ways to control the look of your charts and better display the most important data in Sheets.

Data Connector for Zendesk is now available as an add-on for Google Sheets.

Google has introduced a new data connector add-on for Google Sheets that enables users to import and analyze data from Zendesk. This tool allows organizations to configure query configurations, search for Zendesk tickets, list metrics, and refresh query results directly within a spreadsheet using the Zendesk API.

Google launches a 'Getting Started with Google Sheets' course on Coursera.

Google has introduced a 'Getting Started with Google Sheets' course on Coursera, designed for new users, onboarded employees, and students to learn how to organize information and analyze data. The course is free for all users, with an optional paid tier for access to additional content, projects, quizzes, and a course certificate.

Directly click on chart elements to move and delete them in Google Sheets

Google Sheets has introduced new features allowing users to easily customize charts by clicking directly on data labels, chart titles, or legends to drag and reposition them, or delete them using the delete or backspace keys. Additionally, the update includes keyboard navigation support (using Tab, Enter, Escape, and Arrow keys) and screen reader verbalization for chart elements to improve accessibility.

Goal Seek add-on now available for Google Sheets

The Goal Seek add-on for Google Sheets is now available for download and installation from the G Suite Marketplace. This tool allows users to calculate the required value of a cell to achieve a desired value in another cell, which is particularly useful for conducting break-even analysis or sensitivity calculations.

Retirement of the Sheets v3 API

Google is retiring the Sheets v3 API and requiring users to migrate their apps to the Sheets v4 API to ensure continued functionality. After several extensions, the final turndown date for all components of the v3 API is August 2, 2021.

Accessibility settings are now easier to access on Sheets

It’s now easier to discover accessibility features like screen reader support, braille support, and screen magnifier support in Sheets. This change will make these settings more readily available by placing the Accessibility settings in the Tools menu.

New integration allows direct import of SAP ERP content into Google Sheets.

In an upcoming SAP release, employees will be able to import ERP content directly into Google Sheets, removing the need to manually export data to CSV files and upload them to Drive, allowing for faster analysis using tools like intelligent pivot tables and macros.

Expanded Braille support for Google Sheets on Windows computers via JAWS and NVDA screen readers.

Google Sheets is expanding its accessibility features by adding Braille support for Windows computers using the latest versions of JAWS and NVDA screen readers. Users with Braille displays can now read and edit cell contents and navigate between cells. This update complements existing Braille support on Chrome OS (via ChromeVox) and Mac (via VoiceOver), ensuring a more inclusive experience across different operating systems and browsers.

Enhanced control over chart data labels, including totals for stacked charts and customizable placement.

Google Sheets is introducing new features to improve how charts represent data. Users can now add total data labels to stacked charts to display the sum of all content in a data set. Additionally, new alignment options for data labels have been added for column, bar, line, point, and area charts, allowing users to position labels in locations such as Center, Inside end, Inside base, Outside end, Left, Right, Above, or Below.

Group data by time frame in Google Sheets pivot tables.

When creating pivot tables in Google Sheets, users can now group their data by specific time frames, such as week, month, or year, to facilitate better temporal analysis of their data.

Ability to add checkboxes in cells in Google Sheets.

Google Sheets has added the ability to insert checkboxes directly into cells, making it easier for users to create checklists and track task completion within their spreadsheets.

Expanded options for row and column grouping in Google Sheets.

Google Sheets now provides more options for grouping rows and columns, enabling users to organize and manage their data more effectively.

Added printing page breaks and custom paper sizes to Google Sheets.

Google Sheets has introduced new printing capabilities, allowing users to add printing page breaks and define custom paper sizes to better control the layout of their printed documents.