Set x axis on numbers

Éowyn wrote:

the numbers for the y axis are all evenly spread apart regardless of what is on the x axis

It sounds as if a 2D Scatter chart will do what you want (instead of a 2D Line chart).

For 2D Scatter make sure none of the data you are charting is in a Header Column in the table.

SG

The numbers for the Y (vertical) axis are going to be evenly spaced if the axis is linear. This is very normal for a chart. The only other choice you have is logarithmic, then it goes 1, 10, 100, and so on.

Now if you meant "the numbers on the x axis are all evenly spread apart", then use the scatter chart. It is the only true x-y chart. The line chart is a "category" chart and the x data is text, just like the column/bar charts and others. It could be 0, 1, 2, 3 or 3, -5, 20, 500 or Alpha, Beta, Apple ,Orange or whatever you can think of and each will be evenly spaced in the order of appearance in your table.

Any screenshots of the issue you mentioned? Do you want to evenly distribute the numbers on both the X and Y axis?

When you click on a chart, you can set Axis Scale under the Axis tab. What effect are you trying to achieve?