how to change x axis to numbers (or accomplish similar)

I

idle

I would like to make a grid for plotting co-ordinates. I simply need
both x and y axis to be numbers

example 1 2 3
2
3

Is there a way to change the x axis to be numbers instead of letters?
Or if not is there a quick way for me to just enter the nubers into the
grid without having to type them all (i need 1 - 5000)

Thanks :)
 
I

idle

nvm I found it :)

I posted my question first and searched second lol. In case anyone
else is interested you just select R1C1 reference style from the
options menu

Cheers
 
I

idle

Ok now I need to make one with negative valeues. So each axis would go
from - 5000 to + 5000

I think this can be edited in the format tab once you have an axis
selected. However I simply can not figure out how to select an axis.
I have read about double clicking the axis lable but do not see one.
The bad news is this is the first hour I have ever used a spread sheet.
The good news is this will probably be the last hour I will ever need
too ;)
 
Top