A series created with data in two workbooks
 

Is this even possible?

SERIES("Travel",,('[Milage.xls]2008'!$F$3:$F$42,'[Car.xls]2007'!$F$3:$F$44),2)

I have tryed a number of times with no luck.

Thanks

A series created with data in two workbooks
 

All data for the Y values of a chart series must be in the same
worksheet. However, the Y values of a series can come from one sheet or
book, and the X values from another. And of course, different series can
come from anywhere.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Andrew wrote:
Is this even possible?

SERIES("Travel",,('[Milage.xls]2008'!$F$3:$F$42,'[Car.xls]2007'!$F$3:$F$44),2)

I have tryed a number of times with no luck.

Thanks