dynamic chart ranges

hi there,
i have a table of data consisting on monthly info. this data comes from multiple sources which include an IF formula, when it is false it puts on a blank space " ".
im using the offset function to name the dynamic ranges:

=offset(page!$A$2,1,0,COUNTA(page!$A:$A)-1,1) for labels
and
=offset(labels,0,1) for values

then i substitute the series with
=series(page!$A$2,page!labels,lage!values,1)

but it doesn't seem to work if the cell is blank but it is actually a formula, it takes a larger range and the chart doesn't look nice...