How do you chart data from multiple sheets within a workbook?

Discussion in 'Microsoft Excel Programming' started by joeyej, Mar 23, 2012.

  1. joeyej

    joeyej Guest

    How do you chart data from multiple sheets within a workbook? I'd like to create a line graph illustrating the increase in one cell's values across the many sheets in one workbook.

    Thanks,

    J
     
    joeyej, Mar 23, 2012
    #1
    1. Advertisements

  2. joeyej

    merjet Guest

    I don't believe the latter can be done. One can put line1 and line2
    from different sheets on one chart. However, all points on line1 must
    come from one sheet only; ditto for line2.
     
    merjet, Mar 25, 2012
    #2
    1. Advertisements

  3. joeyej

    Greg Glynn Guest

    It can be done. I've used macros in the past to gather data which is
    not sequentially located, then charted the result.

    Do a Google Search for

    ..SeriesCollection(1).Values = Array(

    That should get you started. Basically, you create array variables in
    your macro then stuff them into the number series for your charts.
    It's a bit of a pig to get your head around, but it does work.

    Greg
     
    Greg Glynn, Mar 26, 2012
    #3
  4. joeyej

    merjet Guest


    > It can be done.  I've used macros in the past to gather data which is
    > not sequentially located, then charted the result.


    Not sequentially located on *one* sheet, fine. Not sequentially
    located on *more than one* sheet is a different matter.
     
    merjet, Mar 26, 2012
    #4
    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. Steven R. Berke

    What commands do you use to name a workbook, save a workbook,open a workbook

    Steven R. Berke, Jul 24, 2003, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    762
    pancho
    Jul 24, 2003
  2. Randy Reese

    Help with copying data from multiple sheets to multiple sheets

    Randy Reese, Mar 18, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    474
    Randy Reese
    Mar 18, 2004
  3. Guest
    Replies:
    1
    Views:
    218
    Guest
    Feb 18, 2005
  4. Guest
    Replies:
    5
    Views:
    243
    Tom Ogilvy
    Jun 2, 2005
  5. Corey
    Replies:
    2
    Views:
    730
    Corey
    Dec 11, 2006
  6. geniusideas
    Replies:
    10
    Views:
    785
  7. Sherry

    Combine multiple sheets within workbook

    Sherry, Feb 24, 2010, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    327
    Sherry
    Feb 24, 2010
  8. joeyej

    How to chart data from multiple sheets in Workbook

    joeyej, Mar 23, 2012, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    435
    joeyej
    Mar 23, 2012
Loading...