Filter charts using text box input or filters

I am trying to filter the charts in my dashboard using a text input and a filter component. The data source is a google sheet. I am unable to figure our how to do this. The table gets filtered based on search query but the chart doesnt update based on changed input. I am sure it must be something really simple but any help will be appreciated. Thank you!!

What is the source for the chart? Is it set to refresh only when triggered, or when inputs change?

data source is google sheet

So a query connected to the Google Sheet? It it a different query than the table query? A query connected to the table connected to the Google Sheet?

Have you set up the query that is used by the chart to:

Can you send a screenshot of the query that is used as the chart input?