Using Excel 2007, I am trying to utilize the INDEX function directly within the Series Value box for charts. I watched your Youtube video and successfully created a defined names that contained the formula:
='IS History'!$E$10:INDEX('IS History'!$10:$10,Num_Hist_Months+4)
Using a defined name...