Set x axis on numbers

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?

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.

É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