Dynamic range for source data in chart

[lala14b]

Hi, Please help! I'm trying to create a pie chart using a dynamic named range. The named is piedata and the range is =OFFSET(DataInColumn!$L$7,0,0,COUNT(DataInColumn!$K$7:$K$21),1)

When I try to link it to the source data, it tells me the range is invalid and doesn't let me proceed. I tried using =piedata, =Sheet1!, and =Top50.xls!PieData, and none of these have worked.

Any ideas??

 

[venkat1926]

try this and see whether you succeed

=offset(dataincolumn!L7,0,0,countA(dataincolumn!$L:$L),2)

are there any data beyond row 21???????

if there are use this formula


=offset(dataincolumn!$L$7,0,0,countA(dataincolumn!$L$7:$L$21),2)