Apache OpenOffice (AOO) Bugzilla – Issue 17983
don't restrict scale range with axis at value
Last modified: 2013-02-24 21:21:06 UTC
One editing option for bar charts and such is to permit the user to specify the range of the Y-axis values. However, chart does not permit a reduction in the range of the axis. For example, a series of bars are plotted, with data (heights) in the range 70000 to 74000, and let's say the default Y-axis is 0 to 75000. I am allowed to pick a higher (than 75000) top end value, but am restricted on the low end to values no greater than 0 (negative values permitted). I would like to make the Y-axis value range, say, 68000 to 75000, but can't set the low end any higher than 0. I didn't check, but I wouldn't be surprised if I couldn't reduce the high end to, say, 74500 (less than the default 75000). If the range of data values are A to B, I should be able to select a Y-axis value range of anything <= A on the low end and >= B on the high end, regardless of the default range chart picked. [noticed in 1.1 Beta 2]
Sorry, can`t reproduce. Tip: Try to scale the Axis by hand.
closed
Created attachment 9021 [details] Can't rescale axis minimum to above 0
reopen per attached example above
-> Phil: Thanks for your attached example; so I can reproduce the problem. The "Defect" is only the missing automatic function for Axit at on Scale Tabpage. Set the field into the automatic state or edit the field by hand an you get the correct result. ->BH: Missing automatic function for Axis at: Scale Tabpage. Compare with Excel.
Uh, no, the way you describe does not work for setting the lower bound of the Y-axis numbering (and drawing of graph, too). The automatic method insists on making 0 the lower bound and the manual method's value (above 0) is not accepted (error message that the value is above the minimum data value, which it's NOT).
Hello Björn, I consider this as a bug too. In Excel that works. Could you please give a comment? Thank you.
It is no bug. You must change the entry in "Axis at" from 0 to (in the attached example) 12 too. OOo cannot draw the X-Axis at y=0, if there is no y=0. When you mark "automatic" to the "Axis at", OOo will take the y-minimum for that by itself. I propose that for "Axis at" the default modus should be "automatic", so this confusing behavior would not appear.
That's absolutely right, your problem is the "Axis at" setting. It is automatic for all chart types except bar charts. The reason this was once done, is that together with auto Minimum, you will get a Minimum equal to the smallest value in the data. However in bar charts, you usually want to start the bars at 0 (imagine values like 1, 10, 6, 3. You would not want to have a Minimum of 1 where, as a result, the first bar would have zero-height). What we could do would be to change the default for "Axis at" for bar charts to be auto like in all other chart types, but it would have a different meaning: If Minimum is also auto, take 0, otherwise take the (manually set) minimum for "Axis at". ->BH/MMP: What do you think about this?
Hello Matthias, please decide this issue as you are the Chart-Owner. Thank you.
edit of summary
to be decided for OOo 3.
Firstly, the default for "Axis at" (origin) should stay auto for all chart types. Secondly, the UI (the scale tab page of the axis property dialog) should adapt a fixed (non-auto) origin-value, if minimum or maximum are changed such that the origin would lie out of the range [min;max].
IMHO "automatic" should be the default for all kind of charts. Anyway the error message should reflect the problem. The current error message is wrong!
*** Issue 49977 has been marked as a duplicate of this issue. ***
iha->bm: I'll take this one.
accepted
changed summary to something more meaningfull from 'Chart: restricted range of values in setting Y-axis numeric range' to 'Better automatisms for 'Axis At' value on scale tabpage to not hinder the user in his workflow'
This is fixed with the chart reimplemetation in CWs chart2mst3. There is no error dialog anymore when choosing min/max values that do not include the value maybe given for 'axis at'.
->Thomas: Fixed in CWS chart2mst3 milestone10, please verify.
changed target to 2.3
all amnual skaling works fine -> verified
ok in OOo 2.3rc2 -> closing