Additional tools for enhanced reporting in Google Sheets
Thursday, August 1, 2019
- Slicers
- Scorecard Charts
- Themes
Earlier this year we announced several new features for objects in Sheets. Together, these new features make for a more impactful reporting experience in Sheets.
Using Slicers, Scorecard Charts, and Themes together to enhance reporting.
- Admins: No action required.
- End users: See below for how to use each new tool in Sheets.
Slicers are a new way of filtering for reports or dashboards by condition and by values. To learn more about using Slicers in Sheets, see our Help Center.
Scorecard charts:
Scorecard charts is a new way to call out key metrics, such as KPIs or a key stat, within your sheet. You’ll have the option to show your stat in comparison to another number, for instance illustrating percentage increase or decrease over time. See our Help Center for more information on how to insert a Scorecard chart in Sheets.
Themes:
You can now quickly alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel for your spreadsheets. To apply a preset theme, select Format > Theme and choose an option, or to create a custom theme, select Customize in the top right.
- Help Center: Filter charts and tables with Slicers
- Help Center: Display KPIs with scorecard charts
- Help Center: Edit & format a spreadsheet
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 1, 2019
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 15, 2019
- Available to all G Suite editions.
On/off by default?
- These features will be ON by default.
Stay up to date with G Suite launches