Help with excel please - SV650.org

Stingo · 18-05-11, 07:39 PM

Hello mighty org - I've forgotten how to put labels onto the horizontal axis of a graph. At the moment I have an axis that has 1, 2, 3 etc up to11. I want to replace this with years. For example should become 1519-1600, 2 should become 101-1650 and so on...its a basic line graph plotting numbers of a specific category over a time period...

Help appreciated...I am a dunce.

yorkie_chris · 18-05-11, 07:40 PM

I think there's an option somewhere you need to change from continuous to discreet

Stingo · 18-05-11, 07:41 PM

hmm...not seen that anywhere...

18-05-11, 09:04 PM

Quote:

Originally Posted by Stingo

hmm...not seen that anywhere...

Think its something like right click in the graph, select format axis then select number then date from the drop down. Can't remember exactly.

18-05-11, 10:53 PM

hover the mouse on the axis to be altered.
RH click and select format axis
change scale or whatever
SMcG

Stingo · 19-05-11, 07:42 AM

Quote:

Originally Posted by Stephen McG

hover the mouse on the axis to be altered.
RH click and select format axis
change scale or whatever
SMcG

yep...tried that...there wasn't an option to actually rename the points along the horizontal axis though...I have however been able to swap things around so that I have a group of series' each of a different colour that allowed me to place a name of my choosing down the side like a key...i'm sure this makes perfect sense to everyone reading it lol!

19-05-11, 08:03 AM

Is there not an option to rename the axis in the format graph box
or step 2 of the chart wizard under the tab series?

19-05-11, 08:06 AM

Did you use a graph/chart wizard thingy whassit?
It's been a few years since I used Excel but if you used the wizard then the raw data should be sitting somewhere in the spreadsheet. If you look at the raw data you have sitting there, I do believe that if you change whichever points need to be changed in there it may transfer directly to the chart/graph. Or if it doesn't then go through the wizard again. Keep a saved copy of what you've got done already though. So incase anything you do doesnt work, youve still got your base from which to start again. Maybe save another copy by going through Save As... and have that copy as the one to work from and the other as a back up. That way you still have one of the original which you're not playing around with and changing.

flymo · 19-05-11, 08:14 AM

you tried the Excel help system? Its pretty good.

19-05-11, 11:52 AM

put the values in a column
in 2007 you go to select data and i am sure there is an option to select the axis label values.

18-05-11, 07:39 PM	#1
Stingo Member Join Date: Feb 2006 Location: Plymouth, Devon - mostly. Posts: 527	Help with excel please Hello mighty org - I've forgotten how to put labels onto the horizontal axis of a graph. At the moment I have an axis that has 1, 2, 3 etc up to11. I want to replace this with years. For example should become 1519-1600, 2 should become 101-1650 and so on...its a basic line graph plotting numbers of a specific category over a time period... Help appreciated...I am a dunce. __________________ Twitter: @poseidon_ashore

18-05-11, 07:40 PM	#2
yorkie_chris Noisy Git Mega Poster Join Date: Apr 2007 Location: Halifax/Leeds Posts: 26,645	Re: Help with excel please I think there's an option somewhere you need to change from continuous to discreet __________________ Currently Ex Biker Now rebuilding a 63' fishing trawler as a dive boat

18-05-11, 07:41 PM	#3
Stingo Member Join Date: Feb 2006 Location: Plymouth, Devon - mostly. Posts: 527	Re: Help with excel please hmm...not seen that anywhere... __________________ Twitter: @poseidon_ashore

18-05-11, 10:53 PM	#5
Stephen McG Guest Posts: n/a	Re: Help with excel please hover the mouse on the axis to be altered. RH click and select format axis change scale or whatever SMcG

19-05-11, 08:03 AM	#7
Quedos Guest Posts: n/a	Re: Help with excel please Is there not an option to rename the axis in the format graph box or step 2 of the chart wizard under the tab series?

19-05-11, 08:06 AM	#8
Drumming_Animal Guest Posts: n/a	Re: Help with excel please Did you use a graph/chart wizard thingy whassit? It's been a few years since I used Excel but if you used the wizard then the raw data should be sitting somewhere in the spreadsheet. If you look at the raw data you have sitting there, I do believe that if you change whichever points need to be changed in there it may transfer directly to the chart/graph. Or if it doesn't then go through the wizard again. Keep a saved copy of what you've got done already though. So incase anything you do doesnt work, youve still got your base from which to start again. Maybe save another copy by going through Save As... and have that copy as the one to work from and the other as a back up. That way you still have one of the original which you're not playing around with and changing.

19-05-11, 08:14 AM	#9
flymo Member Mega Poster Join Date: Jan 2008 Location: North West Posts: 3,124	Re: Help with excel please you tried the Excel help system? Its pretty good.

19-05-11, 11:52 AM	#10
custard Guest Posts: n/a	Re: Help with excel please put the values in a column in 2007 you go to select data and i am sure there is an option to select the axis label values.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SBS 2008 and Excel	454697819	Idle Banter	7	27-01-11 08:41 PM
Excel help Needed	454697819	Idle Banter	9	05-11-10 02:14 PM
MCN show at Excel.	jacksuzukisv650	Bikes - Talk & Issues	15	10-02-10 10:49 AM
Excel	Graciepants	Idle Banter	15	31-03-09 10:52 PM
Excel geeks, please...	Filipe M.	Idle Banter	12	28-08-08 10:04 PM