A series created with data in two workbooks

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

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
 
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
 
Back
Top