A series created with data in two workbooks

Discussion in 'Microsoft Excel Charting' started by Andrew, Jan 12, 2010.

  1. Andrew

    Andrew Guest

    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
     
    Andrew, Jan 12, 2010
    #1
    1. Advertisements

  2. Andrew

    Jon Peltier Guest

    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
     
    Jon Peltier, Jan 13, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian

    Chart With One Series Bars and Two Series of Lines

    Brian, Jan 30, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    352
    Jon Peltier
    Jan 30, 2004
  2. rich zielinski via OfficeKB.com

    series graph -- one series being added to another series

    rich zielinski via OfficeKB.com, Mar 28, 2005, in forum: Microsoft Excel Charting
    Replies:
    3
    Views:
    565
    rich zielinski via OfficeKB.com
    Mar 30, 2005
  3. Donald Macleod

    Displaying single and multiple data series.Single data series

    Donald Macleod, Jan 29, 2006, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    657
    Jon Peltier
    Jan 30, 2006
  4. Guest

    how do I plot a data series against two series

    Guest, Feb 15, 2006, in forum: Microsoft Excel Charting
    Replies:
    7
    Views:
    293
    MrShorty
    Feb 16, 2006
  5. bikash
    Replies:
    0
    Views:
    483
    bikash
    Jan 17, 2008
Loading...

Share This Page