Hello all,
Iam student and for a lab test I need to solve about 450 excel sheets for my project.
The spreadsheet has X and Y data and curve is plotted. I need to split the curves into 3 parts based on major slope change and fit a trendline.
I can do it manually but I need an excel Macro which does this work. Iam trying for trendline with Rsquare >0.95 for all curves. How to do it with a vba, I want the idea. I can then write the code.
A sample is attached.
Iam student and for a lab test I need to solve about 450 excel sheets for my project.
The spreadsheet has X and Y data and curve is plotted. I need to split the curves into 3 parts based on major slope change and fit a trendline.
I can do it manually but I need an excel Macro which does this work. Iam trying for trendline with Rsquare >0.95 for all curves. How to do it with a vba, I want the idea. I can then write the code.
A sample is attached.
