Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient) to find where it begins to reduce (this being the end of the first linear set of data). Then spit the XY data set so that 2 series are plotted the first ending based on the last highest r value. Finally fit the 2 series with linear trendlines to get the equations and using simulataneous equations (here i suppose an input box for the equations would work) work out the intersect of the linear fit lines.I can do this manually but have only managed to imlement a slider to work the data series fit by adding pairs of data points. this obviously takes time and then i have to fit the lines and carry out the simultaneous equation calcs.
I have never tried vba so this is quite a daunting task - any help here very much appreciated.
Steve
