Urgent: How do I get a scale with a root base for the x-axis? (example pic included)

As zbor has done you need to calculate the data points on the sheet and then plot them in the chart.

You can do the same for the axis and use Error bars to draw gridlines and data labels to label up axis.