How to plot percentile chart

J

John

is there a way in Excel that allows to plot a percentile chart, such as the median, nth and mth percentile

thanks

John
 
P

Peter Atherton

John

Excel has PERCENTILE and Median Functions. e.g.

=MEDIAN(D2:D20)
=PERCENTILE(D2:D20,0.9)

Use these on your data and chart the results or use an
AutoFilter on the data to show the top 10% values And plot
these

Regards
Peter
-----Original Message-----
is there a way in Excel that allows to plot a percentile
Click to expand...
chart, such as the median, nth and mth percentile?
 
Top