Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / MSExcel

Author
Message
Indicium
16
Years of Service
User Offline
Joined: 26th May 2008
Location:
Posted: 12th Oct 2009 00:47
Link
Hey, does anybody know if its possible in excel for both axis to show numbers, instead of the x axis showing letters?

if so how ?

thanks
nightmare

Omricon W.I.P
Back to top
Profile PM
David R
21
Years of Service
User Offline
Joined: 9th Sep 2003
Location: 3.14
Posted: 12th Oct 2009 01:11 Edited at: 12th Oct 2009 01:12
Link
It doesn't normally give letter labels to the X axis unless it can't make sense of the data you've giving it to graph with (as in, it kind 'see' anything else useful you've selected to label the columns with)

What data are you actually putting in it? Just a single column of data or something?

09-f9-11-02-9d-74-e3-5b-d8-41-56-c5-63-56-88-c0
Back to top
Profile PM Email Website
Indicium
16
Years of Service
User Offline
Joined: 26th May 2008
Location:
Posted: 12th Oct 2009 01:24
Link
Sorry, I don't think ive made myself clear.



As you can see, the x axis of the table are a-h, is it possible for this to be 1-8 instead?

Omricon W.I.P
Back to top
Profile PM
NeX the Fairly Fast Ferret
20
Years of Service
User Offline
Joined: 10th Apr 2005
Location: The Fifth Plane of Oblivion
Posted: 12th Oct 2009 01:28
Link
Eh...... I just looked and I can't see any obvious way.

Back to top
Profile PM Website
David R
21
Years of Service
User Offline
Joined: 9th Sep 2003
Location: 3.14
Posted: 12th Oct 2009 01:29 Edited at: 12th Oct 2009 01:30
Link
Ah, you want "R1C1 Style" if I remember correctly - a thing that does numbered X column headers to fulfil a compatibility issue.

Tools -> Options -> General (tab) -> Tickbox on top left

It's something that applies globally to Excel (and may affect formulae) though, so not sure how much use that is

09-f9-11-02-9d-74-e3-5b-d8-41-56-c5-63-56-88-c0
Back to top
Profile PM Email Website
Indicium
16
Years of Service
User Offline
Joined: 26th May 2008
Location:
Posted: 12th Oct 2009 04:05 Edited at: 12th Oct 2009 04:07
Link
sorry again. shouldve mentioned im using excel 2007 does it still work?

EDIT: Nevermind. Found It, Thanks Alot

Omricon W.I.P
Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2025-05-25 20:01:55
Your offset time is: 2025-05-25 20:01:55