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
Bookmarks