In one of my charts I have a data series where the reference is currently as follows:
=Data!$B$30:$T$30
However when I select a different date in Cell B3 I would like this range to change so it calls up the information based on the date I have selected.
I was hoping I could enter the...