Use major internal on chart as one month

asked 2012-04-18 02:01:29 +0200

jetpeach
46 ● 1 ● 1 ● 5

updated 2013-01-28 21:33:07 +0200

qubit

5721 ● 3 ● 48 ● 41

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."

delete close flag offensive retag edit

Comments

Hi @jetpeach, as @Pedro 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!

qubit ( 2013-01-28 21:31:30 +0200 )edit

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.

horst ( 2013-02-16 17:24:32 +0200 )edit

Comments

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

Pedro ( 2012-04-19 08:45:40 +0200 )edit

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

jetpeach ( 2012-05-16 07:08:49 +0200 )edit

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?

tohuwawohu ( 2012-06-17 12:47:31 +0200 )edit

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

qubit ( 2013-01-26 21:23:48 +0200 )edit

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

Pedro ( 2013-01-27 22:51:28 +0200 )edit

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

qubit ( 2013-01-27 23:51:42 +0200 )edit

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.

mariosv ( 2013-01-28 00:05:48 +0200 )edit

@qubit, 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" :)

Pedro ( 2013-01-28 18:02:07 +0200 )edit

Use major internal on chart as one month

Comments

3 Answers

Comments

Resources

Donate

Question tools

Stats

Related questions