Use dynamic ranges. These "grow" as the table has more
rows added. Set your chart to pick up the data from the
range names.

eg Table is B6:J25

from the menu, Insert/Name/Define
enter a name like MyData
in refers to put this:

=OFFSET(Sheet1!$B$6,0,0,COUNTA(Sheet1!$B$6:$B$200) ,9)


Since this is a dynamic range, yuo won't see it listed in
the range names dropdown. to test, hit F5 ( goto) and
type in MyData
then hit Enter

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
I have a dynamic spread sheet. one day there may be five
rows of data for
charting.
after a week five more may be added. I have a programme
for drawing chart
for the first five rows which is dyamically programmed
which takes into
account augumentatins of data for these five items. But
when I added five
more rows I would like to draw charts for the additional
five rows. If I
use the same programme it again draws fresh charts for
the same rows for
which I have already drawn chart and of course for new
rows. I would like
to have a programme which from a list of names finds out
whether the chart
is available

If the chart is available go to the next name else draw
a chart.

how to go about.

thanks and regards


.