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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Floating Bar with Quartile Ranks 2
Convert Error Bars to Series and Colour 1
Bubble Chart best fit Scatter plot 3
percentile markers or boxplot on excel scatter graph 1
Percentile 1
Calculate the median value before a specified list 0
Non Linear Scatter plot, need to find y value 3
90% line across line chart 3

Top