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. jcknortheast
    Replies:
    1
    Views:
    4,665
    Stephen Bullen
    Dec 5, 2003
  2. Brian

    Chart With One Series Bars and Two Series of Lines

    Brian, Jan 30, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    451
    Jon Peltier
    Jan 30, 2004
  3. Guest

    Adding new series to chart with two series types

    Guest, Nov 14, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    339
    medicenpringles
    Nov 14, 2004
  4. 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:
    710
    rich zielinski via OfficeKB.com
    Mar 30, 2005
  5. Guest

    chart data series -- plot a table as a single series

    Guest, Sep 15, 2005, in forum: Microsoft Excel Charting
    Replies:
    7
    Views:
    551
    Jon Peltier
    Sep 20, 2005
  6. Donald Macleod

    Displaying single and multiple data series.Single data series

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

    how do I plot a data series against two series

    Guest, Feb 15, 2006, in forum: Microsoft Excel Charting
    Replies:
    7
    Views:
    380
    MrShorty
    Feb 16, 2006
  8. bikash
    Replies:
    0
    Views:
    673
    bikash
    Jan 17, 2008
Loading...