LinkBack URL
About LinkBacks
To base a chart on a range reference you will need to create a named range.
CHTDATA: =INDEX(Sheet1!$A:$A,Sheet1!$A$1):INDEX(Sheet1!$A:$A,Sheet1!$B$1)
Assuming A1 contains the starting point and B1 the end point.
The formula in C1 is not required.
To base a chart on a range reference you will need to create a named range.
CHTDATA: =INDEX(Sheet1!$A:$A,Sheet1!$A$1):INDEX(Sheet1!$A:$A,Sheet1!$B$1)
Assuming A1 contains the starting point and B1 the end point.
The formula in C1 is not required.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks