Results 1 to 2 of 2

Thread: Split Curves

  1. #1

    Split Curves



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	graph.PNG 
Views:	10 
Size:	13.6 KB 
ID:	2014  

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,356
    Articles
    0
    Excel Version
    365

Posting Permissions

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