Graph Points

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a graph with 40 points
I am trying to enter the apexs values (high & low) in cells next to the
chart.
Not having any luck with "=if(and(c3>c4,c5,c4,c5,c4),if(and(etc.
any suggestions or method appreciated
I have max & min points ok
 
Andy - Thank you. I can use your formula. However, what I am trying to
identify is the peak points other than MAX or MIN. If we start in 2002 with
$60,000 and contribute $30,000 a year for 5 years we have $210,000, then we
spend $100,000 (balance of $110,000) then contribute $180,000 over 6 years
(new max of $290,000). I am trying to show the $210,000 and $110,000 points.
Duane
 
Hi,

One way, assuming data in B2:B14,

C2: =IF(AND(B2<B1,B1<>0),B2,NA())
D2: =IF(AND(B2>B3,B3<>0),B2,NA())

Copy the cells down to C14:D14. Plot these as 2 series. Column C will give
you the trough and D the peaks.

Cheers
Andy
 
Back
Top