Thread: A series created with data in two workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
  
Posts: 461
Default 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
Reply With QuoteReply With Quote