Thanks for the reply Jon. Unfortunately I was not able to understand that
tutorial and I don't know much easier you can explain it to me. Really just
wanna have my charts created basically by entering in a range of dates
anywhere in the spreadsheet and have the chart automatically read that and
know where the range of data is and be able to be produced automatically
instead of having to change the series inside the chart data everytime I want
to see a new chart.

Sean

"Jon Peltier" wrote:

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