Thread: Converting X-axis from exact numbers to a scale

Hi,

I'm trying to make a line graph based on two sets of data. These are a subset of the data:

Distance Moran's I
57.302 0.33
143.568 0.084
198.755 0.009
248.781 -0.059
296.452 -0.063
342.166 -0.061
386.37 -0.051

I want the Moran's I data on the Y-axis and the Distance data along the X-axis, which I've been able to do easily using a PivotTable/Chart. However when I create the chart I can't seem to change the X-axis data from the exact number, i.e. 57.302, 143.568 etc to a scale e.g. 0 100 200 300 400.

Anybody know how to change the X-axis so it's displaying my data in a scale rather than the exact numbers?

Many thanks for the help

Ben