We’re making charts in Google Sheets easier to use and analyze. This launch introduces the option to include hidden and/or filtered data in Sheets charts. Going forward, if you create a chart in Sheets on the web and then filter or hide any of the source data, a small message will appear indicating that the data has been removed from your chart and giving you the option to include it. While this option will only appear on the web, any settings will be respected on mobile as well.![](http://web.archive.org./web/20240226210613im_/https://lh4.googleusercontent.com/_UhZ5-iJRh0DdepFFW4DORbv7xUXfCp_pHK4X24vdy-zn5k8gn4yGuLQyY9Dx__4m9Z8xy3GoSgmU1UeBnRCMnXeL80-1USBVTPu5cLp88BaN6rDVzfuFA4sg9qAZi9mx7aRJ_4)
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 DetailsRelease track:Launching to both Rapid release and Scheduled release**
**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:
Full rollout (1–3 days for feature visibility)
Impact:
All end users
Action:
Change management suggested/FYI
More Information
Help Center