tháng 8 3, 2015
Include hidden and filtered data in charts in Google Sheets
If you opt to include that hidden or filtered data and then later want to exclude it from the same sheet, you can simply expand the chart menu in the upper right corner of the chart and select Advanced edit. That will open the Chart Editor, where you can choose Chart types and uncheck the box next to Include hidden / filtered data. The next time you hide or filter source data in that same sheet, you’ll see the message again.
Not only will this give you greater control over the spreadsheets you create within Google Sheets, it will prevent Microsoft Excel spreadsheets that contain hidden data and that are imported into Sheets from being inaccurately displayed.
Launch Details
Release track:
**Update to original post (August 12, 2015): We originally communicated that this feature was launching to both Rapid release and Scheduled release domains on Monday, August 3rd. While it launched successfully to Rapid release domains on that date, it did not go live for Scheduled. The feature will now launch to Scheduled release domains on Monday, August 17th.
Rollout pace:
Impact:
Action:
More Information
Help Center
Note: all launches are applicable to all Google Apps editions unless otherwise noted
Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates