Created attachment 80976 [details]
test file with charts and explanations
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
Data points are off of he major grid lines
Data points position should be on the grid lines
Operating System: Windows XP
Version: 220.127.116.11 release
I observed the same in LibO 18.104.22.168
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.
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 22.214.171.124 and observed he same off-set of a data point from the vertical grid line.
Created attachment 109841 [details]
Setting as enhancement.
Created attachment 109939 [details]
screenshot made in Libo 126.96.36.199
raal`s comment made me doing a test again in v188.8.131.52. The red lines are showing where I expect the grid line to be.
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.