Hi,

One way, assuming data in B2:B14,

C2: =IF(AND(B2<B1,B1<0),B2,NA())
D2: =IF(AND(B2B3,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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Duplatt" wrote in message
...
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

"Andy Pope" wrote:

Hi,

I think you just need the MIN and MAX formula.
See this page.
http://peltiertech.com/Excel/Charts/FormatMinMax.html

Cheers
Andy

Duplatt wrote:
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(c3c4,c5,c4,c5,c4),if(and(etc.
any suggestions or method appreciated
I have max & min points ok