Chart using dynamic range name that includes if formula and is on another workbook

I am trying to make a chart that changes dynamically according to data on another workbook. The workbook with data, named "mPacking" has a sheet named Machine. I made a named range called "testing" in the name manager with this formula,

=IF(Machine!$M$8=INDIRECT("H"&COUNTA(Machine!$H:$H)),INDEX(Machine!$D:$D,MATCH(Machine!$M$10,Machine!$H:$H,0),1):(INDIRECT("D"&COUNTA(Machine!$D:$D))),INDEX(Machine!$D:$D,MATCH(Machine!$M$10,Machine!$H:$H,0),1):(INDEX(Machine!$D:$D,MATCH((Machine!$M$8),Machine!$H:$H,0)-1,1)))

It seems to get the range that I want correctly, even when using the IF formula. When i go to the workbook with the chart, select and add the series with the named range, =mPacking.xlsm!testing , I get an error saying invalid path. I am not sure which step am I doing wrong since a lot of stuff is going on.