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

Nyx · Newbie Joined: 24 May 2005 Posts: 2

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?

9point9 · Moderator Joined: 31 Aug 2004 Posts: 3875 Location: UK

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/

Nyx · Newbie Joined: 24 May 2005 Posts: 2

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?