custom axis label in scatter chart

[bidur]

When we plot scatter chart, the x-axis label is automatically assigned as fixed interval. But I want to change the x-axis label. For example, In the figure attached below, the x-axis label are 0, 20, 40, 60, 80, 100. But I want to make the label values from the percentile column like 0.0., 0.1, 1, 5, 10, 20 ,30....

http://www.freeimagehosting.net/2mexu

Thank u all.

 

[Andrew Poulsom]

Welcome to MrExcel.

Use a Line Chart and change the x axis to Text (Category).