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


--
idle
------------------------------------------------------------------------
idle's Profile: http://www.excelforum.com/member.php...o&userid=29551
View this thread: http://www.excelforum.com/showthread...hreadid=492561

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


--
idle
------------------------------------------------------------------------
idle's Profile: http://www.excelforum.com/member.php...o&userid=29551
View this thread: http://www.excelforum.com/showthread...hreadid=492561

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


--
idle
------------------------------------------------------------------------
idle's Profile: http://www.excelforum.com/member.php...o&userid=29551
View this thread: http://www.excelforum.com/showthread...hreadid=492561