Hi my formula for the chart looks like this
=SERIES('trackLog-2013-Jun-16_09-TEST'!$M$1,,'trackLog-2013-Jun-16_09-TEST'!$M$2:$M$21425,1)
Is it possible to use indirect to reference the sheet with the charts cell a1 contains trackLog-2013-Jun-16_09-TEST
Ive tried
=SERIES(INDIRECT("'"&$A$1&"'!$M$1,INDIRECT("'"&$A$1&"'!$M$1:INDIRECT("'"&$A$1&"'!$M$21425,1)
Any help please to solve this, thanks
Try constructing named ranges that use the indirect. The use the named ranges in the SERIES formula
MyName: =INDIRECT("'"&$A$1&"'!" & $M$1)
MyData: =INDIRECT("'"&$A$1&"'!"&$M$1&":"&$M$21425)
SERIES=(Book1!MyName,,Book1!MyData,1)
Where Book1 is the name of the workbook containing the named ranges.
Also not INDIRECT will only work when references other workbooks that are open.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks