Hello everyone,
I am trying to figure out a way of building a sort of "graph if" scatter plot based on a selection in a drop down menu (currently, data validation list)
I am starting with a large dataset of payments (more than 10 000 rows) and would like to plot by company so that in they Y axis, we see payment amount and in the X axis, time.

I was thinking of graphing the whole columns (date is in T:T and Payment amount is in S:S) and somehow linking my data validation menu to an autofilter in the raw data (company name is in column D)
Any ideas as how to do this?