OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] X axis labels - how to?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
scott1x
General User
General User


Joined: 10 Nov 2007
Posts: 5

PostPosted: Sat Nov 10, 2007 8:36 pm    Post subject: [SOLVED] X axis labels - how to? Reply with quote

column A - Date
Column B - Value.

Chart value by date.. no problem BUT I cannot figure out how to get the date label from column A to show as the x axis label. All I can get is a row number there. How do I get the date to show as the x axis labels?


Last edited by scott1x on Sun Nov 11, 2007 8:19 am; edited 1 time in total
Back to top
View user's profile Send private message
dmd
General User
General User


Joined: 17 Dec 2005
Posts: 16

PostPosted: Sun Nov 11, 2007 5:30 am    Post subject: Reply with quote

I am using version 2.3.

After selecting Insert, Chart..., the chart wizard is displayed and in step two there is an option to select "First column as label" - selecting that option will replace Row 2, Row 3, etc. with the appropriate dates.

The option to select "First column as label" is also available if you right click in the x- axis and select Data Ranges...
Back to top
View user's profile Send private message
scott1x
General User
General User


Joined: 10 Nov 2007
Posts: 5

PostPosted: Sun Nov 11, 2007 8:01 am    Post subject: Reply with quote

dmd wrote:
I am using version 2.3.

After selecting Insert, Chart..., the chart wizard is displayed and in step two there is an option to select "First column as label" - selecting that option will replace Row 2, Row 3, etc. with the appropriate dates.


I am also using 2.3 but checking "first column as label" leaves me with and empty chart an a y axis that has a scale that seems to be related to nothing in my chart. It seems to be using the "B" column (my desired x axis), then, and ignoring the A column, my desired x axis lables.

I'm using WindowsXP.
Back to top
View user's profile Send private message
scott1x
General User
General User


Joined: 10 Nov 2007
Posts: 5

PostPosted: Sun Nov 11, 2007 8:19 am    Post subject: Reply with quote

I figured out what I was doing wrong... got it now... Thanks for the pointers!!!!

Scott Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group