+ Reply to Thread
Results 1 to 10 of 10

breaking point of a plot

  1. #1
    Registered User
    Join Date
    10-29-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    breaking point of a plot

    hi
    I want to find this graph's breaking point. how can I find? If someone helps, I really will be happy.
    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: breaking point of a plot

    Hello and welcome to the forum.

    Can you explain what you mean with "breaking point"? I know a little about formatting charts, but I'm not necessarily clued up in your terminology, so a little explanation would go a long way.

    What do you want to achieve? How would that display in the graph?

  3. #3
    Registered User
    Join Date
    10-29-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: breaking point of a plot

    thanks a lot for your answer. I want to calculate the point which I show on the graph. it has to be 0.7 in x axis.. but I don t know how to find...
    Attached Files Attached Files

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: breaking point of a plot

    what defines the "breaking point"?

    what do you want to do once the "breaking point" has been "identified"?

  5. #5
    Registered User
    Join Date
    10-29-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: breaking point of a plot

    the breaking point value (x axis) has to be found. these are experimental datas. I see 0.7 is the breaking point but has to be found by excel...I hope I can explain the problem.

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: breaking point of a plot

    the breaking point value (x axis) has to be found
    I understand that. But how do you define it?

    these are experimental datas.
    Fine. Nothing wrong with that.

    I see 0.7 is the breaking point
    Why?

    but has to be found by excel.
    If you can put the rule into simple words, then there will be a way to tell Excel how to find it. So far, you have not provided why that point is the "breaking point"

    I hope I can explain the problem.
    So do I. Unfortunately, so far there has been no real explanation. You need to define WHY, WHAT, WHERE.

  7. #7
    Registered User
    Join Date
    10-29-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: breaking point of a plot

    http://www.processtrends.com/toc_tre...ise_Regression

    I want to calculate my own "c" point like in this link...

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: breaking point of a plot

    Isn't the answer in the Link that is supplied just below your example. There is a link to a workbook with all the Excel formulae.

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  9. #9
    Registered User
    Join Date
    10-29-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: breaking point of a plot

    but I couldn't apply the link and excel formulas to my problem...I couldn't find a solution
    http://www.processtrends.com/Files/s...ewise_regr.zip here is a program to find a breakpoint..

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: breaking point of a plot

    Is not the really problem that you do not have the data to perform the task.

    The aticle mentions 2 segments of data. You do not have this.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1