LinkBack URL
About LinkBacks
You need to have a dynamic row start position.
Fans_Range: =OFFSET(Sheet1!$L$2,Sheet1!$I$3-1,0,COUNT(Sheet1!$L:$L),1)
Where the formula in I3 is
=MATCH(B2,K2:K366,0)
You also need to update the named range for axis labels.
You need to have a dynamic row start position.
Fans_Range: =OFFSET(Sheet1!$L$2,Sheet1!$I$3-1,0,COUNT(Sheet1!$L:$L),1)
Where the formula in I3 is
=MATCH(B2,K2:K366,0)
You also need to update the named range for axis labels.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks