MachaMacha
07-23-2008, 07:02 AM
Hello,
In the picture below I have data on individual/time/price unsorted. The columns to the right this data is sorted by individual ascending, then by time ascending. Each individual is a series on the scatterplot to the right with x-val=time, y-val=$.
My problem is that I would like to constantly update the left three columns with new data points which are not in order of time.
Is the best way to create this scatterplot to copy the values to the right and sort by name and then time and then create a series based on the individual's name? Or is there a smarter way to create this scatterplot which will update each time I add a new entry?
Or is it better to create a 2x2 array for each person with time and $ and then use a function/sub to sort each array by time and then have each array be the series on the scatterplot?
Thanks
In the picture below I have data on individual/time/price unsorted. The columns to the right this data is sorted by individual ascending, then by time ascending. Each individual is a series on the scatterplot to the right with x-val=time, y-val=$.
My problem is that I would like to constantly update the left three columns with new data points which are not in order of time.
Is the best way to create this scatterplot to copy the values to the right and sort by name and then time and then create a series based on the individual's name? Or is there a smarter way to create this scatterplot which will update each time I add a new entry?
Or is it better to create a 2x2 array for each person with time and $ and then use a function/sub to sort each array by time and then have each array be the series on the scatterplot?
Thanks