Created attachment 80976 [details] test file with charts and explanations Problem description: Position of data points in charts don't match position Identification of single data points very difficult. Chart is not correct. Steps to reproduce: 1. Create a new chart 2. click x-axis 3. select Insert Major Grid 4 compare position of data points and major grid lines Current behavior: Data points are off of he major grid lines Expected behavior: Data points position should be on the grid lines Operating System: Windows XP Version: 4.0.3.3 release
I observed the same in LibO 3.6.6.2
Hi bugquestcontri, data point coincides midpoint of the label, for all dates. You can change the Scale type to text for x-axis to see like you want. I think it is not a bug, if you are not agree, please REOPEN it.
I agree that with TEXT the lines match with the data points. However, in my real file I need start my x-axis with 01-Jan-2012 and need to set scale to DATE. (I forgot to make this setting in the sample file thus it was on AUTOMATIC) Therefore I still regard it as a bug. Actually in all charts the data point need to match with the grid line and this independent of the setting AUTOMATIC, TEXT or DATE. This has to do with the fact that in 2-dimensional chart a data point has an x and y coordinate. Also this means we unfortunately have a bug. I only did not observe this bug for year (usage of LibO) because I never needed to identify a certain point but only see a trend. Once one needs to identify a certain point(s) to understand e.g. seasonal trends, one needs to able to clearly see data point on the grid lines. I hope that the settting WONTFIX is the correct one to REOPEN a bug. ROSt52
I just found the left status field and changed it to REOPEN. See my comment above for details
Need independent confirmation from QA - moving to UNCONFIRMED.
I made the same in v 4.2.7.2 and observed he same off-set of a data point from the vertical grid line.
Created attachment 109841 [details] excel chart
Setting as enhancement.
Created attachment 109939 [details] screenshot made in Libo 4.3.4.1 raal`s comment made me doing a test again in v4.3.4.1. The red lines are showing where I expect the grid line to be. XP/SP3
In LibreOffice the labels are always between the ticks. Excel lets the user decide, whether the label is on the tick or between the ticks. Such feature is missing in LibreOffice.
The feature is implemented in the meantime and will be available in LibreOffice version 7.6. You can already test a pre-release from https://dev-builds.libreoffice.org/daily/libreoffice-7-6/ The release will be end of August.
Created attachment 190037 [details] Screenshot comparing OOo 3.3 and LO 7.1 The original issue described by bugquestcontri (the apparent misalignment because labels are aligned with data points rather than the tick marks grids) is resolved since LO 7.0. See attached screenshot comparing OOo 3.3 (left) and LO 7.1.0.3 (right). Bibisected the fix with linux-64-7.0 repo to: commit ed2c880a691a0b179bbc92a8ce4ee49eac004035 author Tünde Tóth <tundeth@gmail.com> Thu May 21 10:20:43 2020 +0200 committer László Németh <nemeth@numbertext.org> Mon May 25 13:41:49 2020 +0200 tdf#133005 Chart: fix ODF import of date axis position Chart with date axis setting "On tick marks" wasn't imported correctly. See commit 40d83914d43f60a196dfabddea0b52e2046b333a (tdf#127792 implement UNO chart attribute MajorOrigin) Reviewed-on: https://gerrit.libreoffice.org/c/core/+/94621 Thanks Tünde!