dynamic ch

  1. B

    Dynamically change chart value lookup range

    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...

Some videos you may like

This Week's Hot Topics