You have to define a Name in the workbook, using a formula like this OFFSET,
then link the chart series data to this Name. This is the technique used to
create dynamic charts:

http://peltiertech.com/Excel/Charts/Dynamics.html

The file has to be open if the OFFSET formula is live.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"hmm" wrote in message
...
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?