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. 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:
    377
    Randy Reese
    Mar 18, 2004
  2. Guest
    Replies:
    1
    Views:
    187
    Guest
    Feb 18, 2005
  3. Guest
    Replies:
    5
    Views:
    194
    Tom Ogilvy
    Jun 2, 2005
  4. Corey
    Replies:
    2
    Views:
    483
    Corey
    Dec 11, 2006
  5. joeyej

    How to chart data from multiple sheets in Workbook

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

Share This Page