Automatically vary range in graph depending on #rows data entered?

I want to set up a chart so that the range of values entered in the Source
Data dialog box automatically changes depending on a count of the number of
rows of data that has been pasted into worksheet of source data. Can I embed
a link to a cell with the number representing the number of rows. For
example, in =Data!$H$2:$H$70, I want the "70" to vary depending on how many
rows of data have been pasted. For Excel 2002 and/or2007.

Dynamic Charts:
http://peltiertech.com/WordPress/20...dynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

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


"dalek" <dalek@discussions.microsoft.com> wrote in message
news:861C8819-EC84-4581-B0A9-7CFBA15BD15D@microsoft.com...
>I want to set up a chart so that the range of values entered in the Source
> Data dialog box automatically changes depending on a count of the number
> of
> rows of data that has been pasted into worksheet of source data. Can I
> embed
> a link to a cell with the number representing the number of rows. For
> example, in =Data!$H$2:$H$70, I want the "70" to vary depending on how
> many
> rows of data have been pasted. For Excel 2002 and/or2007.