I have a tab that’s generated from a Query. This query brings up the summation of the transactions.I want to put the graph on the same screen where it shows the composition of the total balance, that information is on another sheet and is obtained with another query. The relationship between tables is done, but for the query where the graph comes from depends on the value selected. Next image is with the value entered manualy
Is it possible to detect which option was selected on the screen to pass that value to the cell from which the query that obtains the detail is controlled?
Many thanks for you help