Group:  Microsoft Excel ยป microsoft.public.excel.charting
Thread: Measuring Slope of peak on Excel graph

Geek News

Measuring Slope of peak on Excel graph
Lionel Lin 12/31/2008 11:52:04 AM
I have a graph with many peaks which are decreasing and increasing and i
need to get the slope of these peaks ignoring the rest which is below
these peaks.

My graph has many peaks e.g. 50 peaks, each one. What i am trying to do is
draw a line through the top of two peaks and then get the slope of this
line.


Any suggestions?
Re: Measuring Slope of peak on Excel graph
"David Biddulph" <groups [at] biddulph.org.uk> 12/31/2008 12:30:35 PM
If your chosen 2 peaks are X1,Y1 and X2,Y2, then the slope is
=(Y2-Y1)/(X2-X1)
--
David Biddulph

"Lionel Lin" <Lionel Lin[ at ]discussions.microsoft.com> wrote in message
news:857749AB-207E-40A9-A883-941E97B4284C[ at ]microsoft.com...
[Quoted Text]
>I have a graph with many peaks which are decreasing and increasing and i
> need to get the slope of these peaks ignoring the rest which is below
> these peaks.
>
> My graph has many peaks e.g. 50 peaks, each one. What i am trying to do is
> draw a line through the top of two peaks and then get the slope of this
> line.
>
>
> Any suggestions?


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net