I am creating a Dashboard report for my Accounting department at work and I
have a weekly one I set up with links for the series of a chart to another
worksheet. Easy. But what I am trying to do is instead of creating a new
one each week by changing the link location for the data is there a way I can
just enter in a range of dates and the charts automatically change and filer
in the new data without me having to change the link in the series where the
data entry is coming from??