If the Y-Axis in a X-Y diagram is set to "start automatically at minimum" always starts at 0, no matter how big the minimum is. Steps to reproduce: -open new Calc document -in the first column enter nummbers between 500 and 700 -in the second column enter any numbers you like -create a X-Y chart with this da -set the Y-Axis in the X-Y diagram to "start automatically at minimum" It will start at 0 and not as expected at 480 or 460. If you invert the axis, the X-axis starts at 450, which is not optimum but acceptable. This Bug appears in Version 3.3.4 ,3.4.4 and 3.5.0 on Linux and on Windows.
<http://wiki.documentfoundation.org/BugReport_Details#Version> NOT reproducible with Parallel Dev-Installation of "LibreOffice 3.5.0 Beta1 - WIN7 Home Premium (64bit) German UI [Build-ID: 7362ca8-b5a8e65-af86909-d471f98-61464c4] Windows_Release_Configuration 11-Dec-2011 06:51" and attached sample.ods. I do not understand the sample and the report. Why should the first (500 ... 700) column contain y-axis values? @Frieder: Please attach a sample document!
Created attachment 54607 [details] Sample Document See comment 1
Created attachment 54610 [details] Sample
I'm sorry I interchanged the first and the second column in my first description. But in the sample it is correct.
Interesting! I compared the samples, had an Idea an found th (or at least a) rule. I my attachment Sample 3 on Table 2 You find a modified version of Frieder's Sample for your won experiments The modifications are: Y-Values except start value will are calculated The rule seems to be: Only if result of "Y Value range" to "Y Minimum Value" is equal or smaller to 0,2 the automatic Y start value adaption will become active. Details can be discussed, but in general that is a useful feature, Please see example "XY_Diagramm_Sample_2.ods - Table 3". The chart shows a sinus oscillating around the Start value in C2. For a start Value 10 it's a benefit to see the distance of the line from Y=0, most users can live with the white area below the curve (and to avoid it, you can scale Y-axis manually) For a start Value 1.000.000 it's a benefit to avoid the distance of the chart curve from Y=0, with a normal scale showing all that 1.000.000 you can not see the sinus. All the same with OOo 3.1.1 My Conclusion ------------- Not a bug in function, but Help and Manual should explain how and when Automatic Ymin will be <> 0 @Kohei: I do not know whether I found all details of the rule, can you please check and forward information to David so that he can integrate it into help and manual? Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Created attachment 54624 [details] XY_Diagramm_Sample_2 See comment 5!
quote Rainer Bielefeld : "For a start Value 10 it's a benefit to see the distance of the line from Y=0, most users can live with the white area below the curve (and to avoid it, you can scale Y-axis manually)" Ok for some cases it seems to by a benefit to see the distance of the line from Y=0 . But in that cases you can scale the Y-axis manually to start at 0. The problem I have with the actual solution is, that if I change the Y-Value of a diagram, and I don't wont the Y-Axis start at 0 I have to rescale the axis every time I change the data. At the time I help myself with a macro, but that cant by the solution for a normal user. For the macro code download the following Calc-document.(in German language) http://wurzelmanager.blogger.de/getfile?name=klassenarbeit_bewertung2.ods So it would by great to have the choice between the actual solution, and the real minimum of the Y-axis.
(In reply to comment #7) > I have to rescale the axis every time I change the data. I agree, that might be annoying. I doubt that you can find an optimum for all needs, but an additional selection "opttimum fit axis to min-value - max-value" might have a good cost-benefit relation? May be you want to submit a separate enhancement request? Or we find one who can create an Extension?
>Or we find one who can create an Extension? I can try to create an Extension for that, but I think, to have a extension only for that is a little bit overkill. I can ad some more functionality. For example to format several options of a chart like intervals, Axis position, Axis orientation .... by a formula in Calc. But it will teak some time an till that will bee finished. I knew all of the UNO API to do that by Basic-macro, but I never built an extension before. I found the Extension-Builder and the Extension-Compiler. With these to tools it should bee easy to make a Extension out of my macros, but it's still a lot of work to make help-texts, ad a licence ....
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.