how ti find a particular is available

[R.VENKATARAMAN]

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

 

[Patrick Molloy]

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