pull from a block of data:Chart problem

Hi,

Hoping someone can help me with this one. I've set up some graphs that pull from a block of data but the problem i've come across is the date range always changes. I want to find a way to make the graph update the date range automatically so that i don't have to go into each graph and manually change it. See attached file for what i've done.

Thanks,
John