Excel isn't magic, it needs a mechanism to know that the two dates you enter
refer somehow to the total data range, and to apply the subset of the data
range to the chart. The tutorial I cited provides that mechanism.

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


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