How to replace drop down list filter to those normal excel filter?

Hi I'm attaching the spreadsheet for clearer example.

Cell D20 is where the drop-down list filter but there's drop down list has it's own limitation as in I can't find / search / type item hat I want to analyze.

Can someone further guide me how to set up the combobox or altervative way for filtering?

On top of that, I got another improvisation that I want to make.
How can we make the graph move from left to right, without scroll left to right and vice-versa?
is it possible to add one button, once you click it will slowly move the graph from left to right.... and another click, will back from the starting cell?
I don't know how you call it, it may call as animated graph... and I know this need programming.
I would also want to make the graph where the data point line will move like a real-time graph.....

Appreciate all the feedback and and helps...

Thanks

Regards
cks1026