I would like to create a graph from data sets that are referenced by a
formula from another workbook. For example, the x-data could be:

=offset(indirect(" 'C:\[MyFile.xls]MyWorksheet'!a1",0,0,100,1))

It would return the first 100 cells from the specified file.

For one data set, I can set a name "xData" equal to this formula, and enter
the name in the x-values box (similar course of action for the y-values).
But for several data sets, how can I do it? I have not seen the ability to
array names (xData(1), xData(2), etc.); is there any other way to achieve the
same result?