Adding Second X-Axis with Custom Values to Scatter Plot

[ageneral]

I have searched all over on Google and on this forum, but I can't find a clear way to do this.
I currently have a scatter plot with x-axis 0 to 100 in increments of 10.
I want to add a second x-axis without changing the plotted data.
For each increment of 10 on my original axis, I want a custom value for that increment on the other axis.
However, I still want my series to be plotted the same way against the original axis.
0 - 0
10 - 0.0897
20 - 0.2018
30 - 0.346
40 - 0.5382
50 - 0.8072
60 - 1.21
70 - 1.8835
80 - 3.23
90 - 7.27
100 - 999

How can I add a another x-axis with the values on the right column as the corresponding labels?

[MrShorty]

I'm sure there are other ways to do it. To me, the easiest approach might be to create a dummy series, format it to look like an axis, and label it using the XY Chart labeler addin from appspro.com

0 - y0 - 0
10 - y0 - .0897
20 - y0 - .2018
...
100 - y0 - 999

where y0 is some value that will place the dummy series/axis where you want it. Plot column 2 against column 1 in your scatter plot, then label it with column 3. Format the series as a line with + data markers so it looks like an axis.

[ageneral]

Shouldn't there be a more official way to do it? This method seems cheap and not professional enough to present to my coworkers. It probably would work though

[Andy Pope]

Excel charts do not have Custom axes. If you need you chart to display one you need to build it as MrShorty suggests.

[ageneral]

OK. I will use that method. Thanks!