Max

Senior Member
Jul 15, 2003
4,828
Anybody good with Excel? My question is retarded: I can't seem to put words on the x-axis instead of numbers. My independents are posture conditions, so numbers don't exactly cut it.
 

Bjerknes

"Top Economist"
Mar 16, 2004
116,989
Anybody good with Excel? My question is retarded: I can't seem to put words on the x-axis instead of numbers. My independents are posture conditions, so numbers don't exactly cut it.
Which version do you have, the latest Excel?

You should be able to just make a column of the 'words' needed, highlight it with the other data, and it should appear on the X-axis.
 

Max

Senior Member
Jul 15, 2003
4,828
Ah, thank you. It still does the same thing though, man. It puts the text I have for the x-axis as arbitrary numbers (1, 2, and 3), even if I format those cells as text.
 

Firestarter

▀▄▀▄▀▄▀▄
Jul 15, 2006
25,814
Ah, thank you. It still does the same thing though, man. It puts the text I have for the x-axis as arbitrary numbers (1, 2, and 3), even if I format those cells as text.
Ok. Have you tried selecting the cells and on the top change it to change it General? Fugg it I'll printscreen it for you.
 

Max

Senior Member
Jul 15, 2003
4,828
I've already tried formatting it to General and Text. I don't even have that drop-down on the top toolbar HA! I have to right click and click "Format Cells".
 

swag

L'autista
Administrator
Sep 23, 2003
84,960
I got f*ed over by this very function yesterday when I imported some generated text user names for a test suite yesterday, and Excel decided to change the format of any string ending in "e#" (where '#' is one more more digits) into a number in scientific notation -- corrupting the data.

WTF, really. :(
 

Users Who Are Viewing This Thread (Users: 0, Guests: 197)