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

How do I change date scale for X axis in XY Chart?

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


Joined: 24 May 2005
Posts: 2

PostPosted: Wed May 25, 2005 12:02 am    Post subject: How do I change date scale for X axis in XY Chart? Reply with quote

I created a XY chart that has dates for X axis.
I want to change minimum and maximum date of X axis, but Calc shows "Invalid number" error and does not accept the change I try to submit. It seems to me this is because the input date is converted to string in the default format of Date type before submitting.

How do I change scale in date type on a XY chart?
Is there some option to have Calc to understand input date properly in X axis property?
Back to top
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Wed May 25, 2005 1:32 am    Post subject: Reply with quote

You will have to input it as a number. This is because all spreadsheets handle dates as a time index from 1900-01-01. Therefore, 2000-01-01 would be 36525. You can work it out by entering in the date that you want in to a cell and then converting it to number format.
_________________
Arch Linux
OOo 3.2.0

OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/
Back to top
View user's profile Send private message Visit poster's website
Nyx
Newbie
Newbie


Joined: 24 May 2005
Posts: 2

PostPosted: Wed May 25, 2005 3:06 am    Post subject: Reply with quote

Thank you for a suggestion.
I tried it, but it did not work. The input number is converted into a date string as soon as I move focus to another field, and Calc shows the same error message when I click OK button.
Is there a way to prevent it being converted to a string?
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