PC Review


Reply
Thread Tools Rate Thread

A series created with data in two workbooks

 
 
Andrew
Guest
Posts: n/a
 
      12th Jan 2010
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 Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      14th Jan 2010
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 Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
chart with two data series and two colors for each data series bikash Microsoft Excel Charting 0 17th Jan 2008 03:04 AM
how do I plot a data series against two series =?Utf-8?B?RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?= Microsoft Excel Charting 7 16th Feb 2006 05:24 AM
Displaying single and multiple data series.Single data series Donald Macleod Microsoft Excel Charting 2 30th Jan 2006 03:52 AM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Microsoft Excel Charting 3 30th Mar 2005 06:23 PM
Chart With One Series Bars and Two Series of Lines Brian Microsoft Excel Charting 1 30th Jan 2004 08:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:01 AM.