Include hidden and filtered data in charts in Google Sheets

Google Apps update alerts

---

Include hidden and filtered data in charts in Google Sheets Posted: 03 Aug 2015 03:48 PM PDT 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. 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: Launching to both Rapid release and Scheduled release Rollout pace: Full rollout (1–3 days for feature visibility) Impact: All end users Action: Change management suggested/FYI 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