Hi All

I am trying to chart dynamic data. I need to add rows and columns everyday and would like my chart to dynamically adjust to these values. I have used this offset function:
=OFFSET($A$1,0,0,COUNTA($A:$A),1)
and have suceed in dynamically updating the rows.
I would llike to add additional columns and have used the following offset function:
=OFFSET($A$1,0,0,COUNTA($A:$A),COUNTA($1:$1))
but get the following error:
This reference is not valid. References for titles, values or sizes must be a single cell, row or column.

I am stumped. I have tried everything I can think of and can not figure this out.

Can any one please help me out. I would greatly appreciate all advice.

Thanks