> Hi,
> I have been struggling with this all day.

> I have this named formula which I am also using as a data range in a chart:
> =offset('dev data'!$E$5,0,0,COUNTA('dev data'!$E:$E), 1)

> The problem is that cells 5-12 are blank and there is data from 13 on. I
> need to include the blank cells to make my chart accurate.

> But the chart only graphs cells 5-13--not the rest of the data as I also
> need. I tried changing the last number to something higher but it tells me
> "the reference is not valid. it must be a single cell row or column"

> any ideas?

> thanks

> Marci Colwell

> If the blank cells will not change, you could simply add 8 to the formula:

> =offset('dev data'!$E$5,0,0,COUNTA('dev data'!$E:$E)+8, 1)

> > Hi,
> > I have been struggling with this all day.

> > I have this named formula which I am also using as a data range in a
chart:
> > =offset('dev data'!$E$5,0,0,COUNTA('dev data'!$E:$E), 1)

> > The problem is that cells 5-12 are blank and there is data from 13 on. I
> > need to include the blank cells to make my chart accurate.

> > But the chart only graphs cells 5-13--not the rest of the data as I also
> > need. I tried changing the last number to something higher but it tells
me
> > "the reference is not valid. it must be a single cell row or column"

> > any ideas?

> > thanks

> > Marci Colwell