Use major internal on chart as one month

Hi, there was a bug filed for this on openoffice that is closed saying it’s been implemented. And this page
http://help.libreoffice.org/Chart/Scale
suggests you can set the interval to a date type (week or month), but I can’t seem to find out how.

I’m wondering how you can set the major interval on an XY scatter plot to one month? Not 30 days, which then doesn’t stay consistent with the 1st of the month. Anybody know how?

“Type
For some types of axes, you can select to format an axis as text or date, or to detect the type automatically. For the axis type “Date” you can set the following options.
Minimum and maximum value to be shown on the ends of the scale.
Resolution can be set to show days, months, or years as interval steps.
Major interval can be set to show a certain number of days, months, or years.

Hi @jetpeach, as @Pedro1 mentions below, Please file an enhancement bug and provide as much information as possible. The QA team will be happy to help you triage your feature request in the bugtracker. Thanks!

Hi @jetpeach, it is only possible in the LINE-chart not the X-Y-Scatter. What makes not much sense to me, it should be also possible for x-y-charts.

Double click on the axes and change Type in Scale tab from Automatic to Date.

And how do you set the interval to months? I can only find a value field where you can type a fixed value.

Pedro followed up with exactly what I’m still wondering. If anybody can help please respond, this is still open. Thanks

Same is true for me. There’s no control in the Scale tab to change the type. How do you make LO show that control?

@Pedro1, @tohuwawohu, @jetpeach – Did any of you figure out how to set the interval type?

@qubit1, no. @mariosv said it was possible. But I can’t find that option in Calc.

Hi @Pedro1, If this feature hasn’t been implemented properly in LO, could you please (re)open a bug for it? Thanks.

Hi @all, my mistake, searching a bit I have seen that XY is the only type chart that does not let select the scale type, but I think it should not be a problem because dates are linear data, so should be the same doing it with line type instead of XY, with dates as X.

@qubit1, this is not a bug. It is a limitation as @mariosv mentions. So the answer would be “This feature is not available in LibreOffice (or any other Office, to my knowledge). Please post a Feature Request at Bugzilla” :slight_smile:

Hi @jetpeach,

Please file an enhancement bug and provide as much information as possible. Don’t forget to mark your bug as an ‘enhancement’. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!

Hi all, if you have found this here is a bug that has already been filed requested just what I mentioned.
https://bugs.freedesktop.org/show_bug.cgi?id=54132

Unfortunately, it seems unlikely to be worked on soon because the code is quite a mess…
When someone proposed an “easy hack” to allow some of this functionality, it sounds like it is difficult…

quote"
Chart2 code is one of the places that is horribly complicated and a endless source for confusion and regressions
Unfortunately, it seems unlikely to be worked on soon because the code is quite a mess…
Especially the date axis handling is quite non-intuitive.

I’d prefer if we won’t mark chart2 bugs as ProposedEasyHacks because we have nobody who is confident enough to throw some code pointers into a bug report."

You might want to look at my discussion with Rost52.