+ Reply to Thread
Results 1 to 2 of 2

Combine Data Series.

  1. #1
    Registered User
    Join Date
    01-28-2009
    Location
    Huntsville, AL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Combine Data Series.

    First post...
    What I am trying to do is create a macro that will allow a user to select multiple data series in a scatter plot and create a new data series which contains all of the data of the selected series i.e. combines all the selected series into a new seies with the same data. This is for doing a fit of all the selected data.

    I was disappointed that seriescollection does not have a range property.

    The only way I could think to do this is to use the seriescollection.formula and do some string parsing (which I shudder to think about because my plots can have series from different worksheets and some of the series themselves have ranges which are "split up" on a given worksheet).

    So given the above, anyone have an idea on how to do this? Remember, any idea must be able to handle any number of series which may have data ranges on multiple worsheets i.e. I don't want to have to specify the ranges manually - rather, I need to get them from the chart itself.

    code snippetts welcomed

    Thanks in advance
    Last edited by VBA Noob; 01-28-2009 at 04:11 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Combine Data Series.

    You can not create a series with data from more than one sheet.
    You can have non contiguous range from the same sheet, depending upon generated series formula length.

    The simplest approach is to hold the data on a working sheet and append selected ranges.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1