try this formula:

=LARGE($A$1:$A$25,1) will return the largest value in your range
=LARGE($A$1:$A$25,2) will return the second largest value in your
range and so on up to
=LARGE($A$1:$A$25,10) for the tenth largest value.

NOTE: ties will be repeated as many times as they appear. e.g.
1,2,3,3 will show 3 as largest AND second largest, 2 will be third
largest.

Plot the results of the formulas.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475930