Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Measuring Slope of peak on Excel graph
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Measuring Slope of peak on Excel graph
If your chosen 2 peaks are X1,Y1 and X2,Y2, then the slope is
=(Y2-Y1)/(X2-X1) -- David Biddulph "Lionel Lin" <Lionel wrote in message ... 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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Measuring Slope of peak on Excel graph
Aloha Lionel,
I have followed a few of your threads on this subject and feel your frustration when no one really gets your question. I have been attempting the same thing for quite a while myself with no success. I will post back here if I get any satisfactory results. Also, Please, if you have any good information on this subject, forward it to me. Thanks John On Wednesday, December 31, 2008 6:52 AM Lionel Li wrote: 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? On Wednesday, December 31, 2008 7:30 AM David Biddulph wrote: If your chosen 2 peaks are X1,Y1 and X2,Y2, then the slope is =(Y2-Y1)/(X2-X1) -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Area under the curve for each peak in a graph of mulitple peaks? | Excel Worksheet Functions | |||
How to add slope formula to graph | Charts and Charting in Excel | |||
Slope of graph? | Charts and Charting in Excel | |||
Need to get slope of peaks on excel graph | Excel Discussion (Misc queries) | |||
Need to get slope of peaks on excel graph | Charts and Charting in Excel |