Project Description

📖 < 1 min read

What’s changing

Google is improving the way data is suggested and how data is selected when creating a chart in Google Sheets. It’s now easier to locate and select the data you need when creating a dashboard over a dataset with slicers, pivot tables, charts, and more.

Who’s impacted

End users

Why you’d use it

When creating reports in Sheets, it’s common to create multiple charts from the same data table, but using different column ranges. Previously, all data ranges on a table would be used when creating a chart. Now, you’ll be able to select which columns to use for the chart axis and series. This allows you to quickly customize your charts so that they display the most relevant data.

Getting started

Admins: There is no admin action required for this feature.

End users: This feature will be available by default. In the chart editor, you can select a column as the X-axis and under “Series” you can select additional columns to populate your chart.

Rollout pace

Availability

  • Available to all G Suite customers and users with personal Google accounts
Thanks for sharing and spreading the word!