I am trying to create a dynamic chart that pulls calculations from a second file to display the last 13 months of data logged. I am having a problem with my formula-for example, the formula is reading the cells containing "=A13", and trying to put this value in the chart. I only want the formula to read the cell information when it contains a the actual information pulled from the second file.
This is how I have it set up so far:
Named Ranges:
chtcats=OFFSET(Data!$A$2,COUNTA(Data!$A:$A)-1,0,-MIN(chtLen,COUNTA(Data!$A:$A)-1),1)
chtlen=Data!$C$3
chtperpass=OFFSET(chtCats,0,1)
Chart info:
Name=Data!$B$2
Values='Dynamic Graph Test.xls'!chtPerPass
Categories axis lable=='Dynamic Graph Test.xls'!chtCats
Thanks, any ideas would be greatly appreciated!
Bookmarks