how to extract a specific range of days (7 or 30) to make a chart
 

I haven't figured out how to take a specific range of data from a worksheet
and use this range, say 7 or 30 days to retrieive data associated with this
range to make a chart.
I would like this to be automated depending upon the value of days, again 7
or 30 calendar days.