How to get percentile like 50%, 75% and 90%

[prasad]

Hi,

I am trying to get percentile as in column E. Please let me know if anybody has tried this. Thanks! in Advance Prasad

[#2]

Hi,

goto right click properties>select axes tab>

in that check the box show in percent ...it will do

[#3]

sorry,,,not axes..its number tab

[#4]

Hi,

Are you saying like 50%? if so just add to your formula like for example

num(sum(SPC),'#0%')

the num function can give you the specific form of number you like.

or if it is in a chart just go to the Number tab and set the expression to show in percentage.

Regards,

[prasad]

Thanks for the answers. I will try and update the status.