Creating a Line Chart with a numeric x-axis

[chipman88]

I'm trying to create a line chart that will format linearly with x-axis values from 0 to 125 when my data is at x-values of 0, 25 85 and 125. All my efforts so far have the same x-axis spacing between the numbers and my data looks weird.

[gebobs]

Right click on the x-axis and select Format Axis. For axis type, select Date axis. Play around with the units to get it to display how you like. If you set major unit to 25 it will label 25,50,75,100,125.

[chipman88]

Thanks, GEBOBS, but I need negative values in the x-axis. using the Date format still doesn't work.

[chipman88]

You can't use a line chart in this way. You have to use a SCATTER chart with lines.