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

I already found the solution for this problem and was using this SQL sentence

=“Select C ,B, E,sum(E) WHERE C = date '”&text(K4,“yyyy-mm-dd”)&"’ group by C,E, B"

I made this example so you can see how it works

this is the link Change chart according the selected day

Its a little slow but works :slight_smile:

**dates started on 4/22/20

Many thanks for your help!!!

1 Like