Thread: dynamic chart

i searched and found a bunch of helpful responses, and maybe I'm just having a morning braincramp, so apologies if this has been answered somewhere.

I would like to create a chart for a dynamic table and the key is I don't want blank space on the chart.

Here's examplte TABLE:

A B
1project title
2----------
3 name numb
4 bird 22
5 bee 40
6 bear 55

so went to 'insert->name->define' and created a "namelist" and "numblist" which refer as such:

=OFFSET($a$3,0,0,COUNT($a$3:$a100),1)
=OFFSET($b$3,0,0,COUNT($b$3:$b100),1)

1ST QUESTION: notice how I use the first two lines for project info. Therefore I can't use count($a:$a) and instead have to define $a100. The only way I can see getting around this is to actually offset all the data off the printable part of the page and reference that 'ghost copy' of the data.. is there a better way? (eg. if I had 101 data lines, the last few wouldn't be captured in current method).

2ND QUESTION: How do I reference these dynamic lists in the 'source data' of the chart?

3RD QUESTION: I assume the way I've set it up will mean that if I delete A6 and B6, the chart won't still try and plot 4 entries and will leave one entry blank? (this is what i'm trying to avoid).

Thanks a ton for your help with this!

ok.. i figured all my first three questions out..

however, the function for dynamic charting that i'm using is changing the formula for the series:

=series(sheet1!a1,workbook1.xls!namelist,workbook1!numb)

my only remaining question is to be able to have multiple sheets using the dynamic lists (ie. namelist, numb)

the series function only defines by workbook name and not sheet name.. therefore I'd need to create a new dynamic list for each sheet??

any help?