One approach I use for this -- put your data into a nice, filterable list, then use the built in autofilter utility. A chart based on a filterable list should only show the visible data, and the visible data are controlled by the filter. https://www.wikihow.com/Use-AutoFilter-in-MS-Excel