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.
Reference By Google