=offset(Sheet1!$A$1,0,0,Count(Sheet1!A:A),1)

Count won't count ""

--
Regards,
Tom Ogilvy


"Ribeye" wrote:

Im trying to use a dymanic chart and I am using an If then formula for the
data. My false data = "". I thought this was equal to a blank cell but for
some reason the dynamic chart is picking it up as something and graphing
these blank cells. If I delete the cells the dynamic chart works perfectly.
Please advise as to what I need to replace the "" with in order to make the
chart work. -Thanks