MrExcel Publishing
Your One Stop for Excel Tips & Solutions

finding maxima


Posted by nmn on September 19, 2001 9:52 AM

I understand how the MAX() function can return the
largest value in a data series, but is there any way
to find and label maximum value in a series on an xy
chart? Also, aside from inspection, is there a way to
determine which x value corresponds to the maximum y
value?


Posted by IML on September 19, 2001 9:59 AM

Partial answer II

for your second query, lets say X's occupy A1:A15. Y's B1:B15

The formula
=INDEX(A1:B15,MATCH(MAX(B1:B15),B1:B15,0),1)
will return the X value next to the maximum Y. In the event of ties, it will return the first match


Good luck

Posted by Eric on September 19, 2001 10:21 AM

another partial answer

This is just a display trick, but you could find the max value, and plot its X,Y pair as a separate series with a "highlight" color.