View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Jason is offline
external usenet poster
 
Posts: 367
Default Can I get multiple trend data on one curve?

I need to find points in a curve where the data slope changes. I have been
doing this manually and was wondering if there is a trend function I can use
to find these points automatically?

Here is a Very simple example of my data. (usually have 200 points)
1 0
2 10
3 20
4 28
5 36
6 41
7 46
8 51
9 54
10 57
11 60
12 62
13 64
14 65
15 66
16 67

If you graph this, you can plainly see the changes of slope, but the data I
usually use is a smooth curve that I am trying to find Breakpoints for to
linearize the curve. Thanks for any help