You can define a dynamic range that adjusts to dates you enter into cells. I
wrote a somewhat involved tutorial which you may be able to adapt:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sean Moor" wrote in message
...
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??