How to change the data of a chart according to the selected date?

I think you can use a QUERY to achieve that. Have not used a Date component in my apps, do that store a value in the sheet?

If yes, you can probably do something like: QUERY(your original full data, “SELECT * WHERE DateCol = '”&(Insert Cell Where Date component value is stored)&"’,-1)

Then get the chart based on the newly queried value.

Hope it helps.

1 Like