Spreadsheet: 227774d1365805114-chart-using-dynamic-range-name-that-includes-if-formula-and-is-on-another-workbook-mpacking
Sheet: Machine

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Y/W
 |  |  | 8797 |  |  |  | 2012Week45
 |  |  | 18 |  |  |  | 2012Week45
 |  |  | 48 |  |  |  | 2012Week45
 |  |  | 3 |  |  |  | 2012Week45
 |  |  | 5887 |  |  |  | 2012Week45
 |  |  | 1200.1 |  |  |  | 2012Week46
 |  |  | 616.599999999999 |  |  |  | 2012Week46 |  |  |  |  | 2013Week15
 |  |  | 33.0999999999995 |  |  |  | 2012Week46
 |  |  | -550.400000000001 |  |  |  | 2012Week46
 |  |  | -1133.9 |  |  |  | 2012Week46
 |  |  | -1717.4 |  |  |  | 2012Week48
 |  |  | -2300.9 |  |  |  | 2012Week48
 |  |  | -2884.4 |  |  |  | 2012Week48
 |  |  | -3467.9 |  |  |  | 2012Week48
 |  |  | -4051.4 |  |  |  | 2012Week48
 |  |  | -4634.9 |  |  |  | 2012Week49
 |  |  | -5218.4 |  |  |  | 2012Week49
 |  |  | -5801.9 |  |  |  | 2012Week49
 |  |  | -6385.4 |  |  |  | 2012Week49
 |  |  | -6968.9 |  |  |  | 2012Week49
 |  |  | -7552.4 |  |  |  | 2012Week49
 |  |  | -8135.9 |  |  |  | 2012Week50
 |  |  | -8719.4 |  |  |  | 2012Week50
 |  |  | -9302.9 |  |  |  | 2012Week50
 |  |  | -9886.4 |  |  |  | 2012Week50
 |  |  | 78672 |  |  |  | 2012Week50
 |  |  | -11053.4 |  |  |  | 2012Week50
 |  |  | -11636.9 |  |  |  | 2012Week51
 |  |  | -12220.4 |  |  |  | 2012Week51
 |  |  | -12803.9 |  |  |  | 2012Week51
 |  |  | -13387.4 |  |  |  | 2012Week51
 |  |  | -13970.9 |  |  |  | 2012Week51
 |  |  | 427687 |  |  |  | 2012Week52
 |  |  | -15137.9 |  |  |  | 2012Week52
 |  |  | -15721.4 |  |  |  | 2012Week52
 |  |  | -16304.9 |  |  |  | 2012Week52
 |  |  | -16888.4 |  |  |  | 2012Week53
 |  |  | -17471.9 |  |  |  | 2013Week1
 |  |  | -18055.4 |  |  |  | 2013Week1
 |  |  | -18638.9 |  |  |  | 2013Week1
 |  |  | -19222.4 |  |  |  | 2013Week1
 |  |  | -19805.9 |  |  |  | 2013Week2
 |  |  | -20389.4 |  |  |  | 2013Week2
 |  |  | -20972.9 |  |  |  | 2013Week2
 |  |  | -21556.4 |  |  |  | 2013Week2
 |  |  | -22139.9 |  |  |  | 2013Week2
 |  |  | -22723.4 |  |  |  | 2013Week2
 |  |  | -23306.9 |  |  |  | 2013Week3
 |  |  | -23890.4 |  |  |  | 2013Week3
 |  |  | -24473.9 |  |  |  | 2013Week3
 |  |  | -25057.4 |  |  |  | 2013Week3
 |  |  | -25640.9 |  |  |  | 2013Week3
 |  |  | -26224.4 |  |  |  | 2013Week3
 |  |  | -26807.9 |  |  |  | 2013Week4
 |  |  | -27391.4 |  |  |  | 2013Week4
 |  |  | -27974.9 |  |  |  | 2013Week4
 |  |  | -28558.4 |  |  |  | 2013Week4
 |  |  | -29141.9 |  |  |  | 2013Week4
 |  |  | -29725.4 |  |  |  | 2013Week4
 |  |  | -30308.9 |  |  |  | 2013Week5
 |  |  | -30892.4 |  |  |  | 2013Week5
 |  |  | -31475.9 |  |  |  | 2013Week5
 |  |  | -32059.4 |  |  |  | 2013Week5
 |  |  | -32642.9 |  |  |  | 2013Week5
 |  |  | -33226.4 |  |  |  | 2013Week5
 |  |  | -33809.9 |  |  |  | 2013Week6
 |  |  | -34393.4 |  |  |  | 2013Week6
 |  |  | -34976.9 |  |  |  | 2013Week6
 |  |  | -35560.4 |  |  |  | 2013Week6
 |  |  | -36143.9 |  |  |  | 2013Week6
 |  |  | -36727.4 |  |  |  | 2013Week6
 |  |  | -37310.9 |  |  |  | 2013Week7
 |  |  | -37894.4 |  |  |  | 2013Week7
 |  |  | -38477.9 |  |  |  | 2013Week7
 |  |  | -39061.4 |  |  |  | 2013Week7
 |  |  | -39644.9 |  |  |  | 2013Week7
 |  |  | -40228.4 |  |  |  | 2013Week7
 |  |  | -40811.9 |  |  |  | 2013Week8
 |  |  | -41395.4 |  |  |  | 2013Week8
 |  |  | -41978.9 |  |  |  | 2013Week8
 |  |  | -42562.4 |  |  |  | 2013Week8
 |  |  | -43145.9 |  |  |  | 2013Week8
 |  |  | -43729.4 |  |  |  | 2013Week8
 |  |  | -44312.9 |  |  |  | 2013Week9
 |  |  | -44896.4 |  |  |  | 2013Week9
 |  |  | -45479.9 |  |  |  | 2013Week9
 |  |  | -46063.4 |  |  |  | 2013Week9
 |  |  | -46646.9 |  |  |  | 2013Week9
 |  |  | -47230.4 |  |  |  | 2013Week9
 |  |  | -47813.9 |  |  |  | 2013Week10
 |  |  | -48397.4 |  |  |  | 2013Week10
 |  |  | -48980.9 |  |  |  | 2013Week10
 |  |  | -49564.4 |  |  |  | 2013Week10
 |  |  | -50147.9 |  |  |  | 2013Week10
 |  |  | -50731.4 |  |  |  | 2013Week11
 |  |  | -51314.9 |  |  |  | 2013Week11
 |  |  | -51898.4 |  |  |  | 2013Week11
 |  |  | -52481.9 |  |  |  | 2013Week11
 |  |  | -53065.4 |  |  |  | 2013Week11
 |  |  | -53648.9 |  |  |  | 2013Week12
 |  |  | -54232.4 |  |  |  | 2013Week12
 |  |  | -54815.9 |  |  |  | 2013Week12
 |  |  | -55399.4 |  |  |  | 2013Week12
 |  |  | -55982.9 |  |  |  | 2013Week12
 |  |  | -56566.4 |  |  |  | 2013Week13
 |  |  | -57149.9 |  |  |  | 2013Week13
 |  |  | -57733.4 |  |  |  | 2013Week13
 |  |  | -58316.9 |  |  |  | 2013Week13
 |  |  | -58900.4 |  |  |  | 2013Week13
 |  |  | -59483.9 |  |  |  | 2013Week14
 |  |  | -60067.4 |  |  |  | 2013Week14
 |  |  | -60650.9 |  |  |  | 2013Week14
 |  |  | -61234.4 |  |  |  | 2013Week14
 |  |  | -61817.9 |  |  |  | 2013Week14
 |  |  | -62401.4 |  |  |  | 2013Week15
 |  |  | -62984.9 |  |  |  | 2013Week15
 |  |  | -63568.4 |  |  |  | 2013Week15
 |  |  | -64151.9 |  |  |  | 2013Week15