# Need to get slope of peaks on excel graph

C

#### Capillod

I have a graph with many peaks which are decreasing logarithmically and i
need to get the slope of these peaks ignoring the "Noise" which is below
these peaks.

Any suggestions

T

#### Tushar Mehta

I'm sure your question makes sense to you but by definition a peak has a
slope of zero. Or do you mean the slope of a curve that includes only
the peaks? If so, plot the peak values as a 2nd series. If that is a
straight line, the trendline (or the LINEST function) will give you the
slope.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
+ Technology skills
Recipient Microsoft MVP award 2000-2005

C

#### capillod

Tushar Mehta

Sorry I probaly didnt word the question well. My graph has many peaks e.g.
20 peaks, each one smaller than the previous one. What i am trying to do is
draw a lins through the top of these peaks and then get the slope of this
line.

I have tried using the trendling but with no success. It does give me ths
slope of the whole graph which is useful but not what i am looking for.
Regards

Cathal

B

#### bj

Is your chart an XY or line chart?
If it is a XY chart it is easier.
You will need to set up a method on the spread sheet of identifying the peaks.
the method to do this depends on the noise in the data.
if the data between max and mins is always monotonically increasing or
decreasing you could use something like
=if(and(d3>d2,d3>d4),d3,na())
If there is a lot of up and down movement in your curves You will need to
put in a smoothing function

another way to do it is to select on the chart points which look like they
are maxes and record the x,y posion shown next to them.
record these positions on a new section of sheet plot it on the chart and