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

But this is a logarithm scale?

Create graph (Scatter)
Then click x-asis and right click -> Format axix
check box Logarithmic scale (Base 10)

I think that is not a log scale, zbor -- the spacing is sqrt(x), not log(x).

I have no idea how to do that in Excel.

In that case will help to create new SQRT column.
I've also add log to compare.

A shape should be same... now need to see how to adjust values of x axe.

Plotting data on that scale would be easy enough. Getting the axis and gridlines would be a PITA.

A PITA is a discomfort of the gluteus maximus.

I'd suggest you have a look at the web sites for Andy Pope (andypope.info) and Jan Karel Pieterse (http://www.jkp-ads.com), two of Excel's chart gods, and see if you can find anything you can adapt.

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.

Andy,

Thanks for jumping in. Could you explain the steps to get the labels and gridlines, or provide a link to your site that does?

Here is a link to Jon Peltier's tutorial for creating a reciprocal (1/x) axis chart http://peltiertech.com/Excel/Charts/RecipAxisChart.html The technique is basically a specific application of what he calls the arbitrary axis and gridline techniques that he also describes. I would expect the same basic technique would apply to a sqrt axis.

Exactly what I was looking for, thank you.