Thread: 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?

what defines the "breaking point"?

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

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.

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

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.