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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

idle - 11 Dec 2005 19:07 GMT

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 :)

Signature

idle

Reply to this Message

idle - 11 Dec 2005 19:15 GMT

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

Signature

idle

Reply to this Message

idle - 11 Dec 2005 20:58 GMT

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 ;)

Signature

idle

Reply to this Message