Bug 65878 - FORMATTING: date points in chart don't match gridlines
Summary: FORMATTING: date points in chart don't match gridlines
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
Reported: 2013-06-18 02:16 UTC by bugquestcontri
Modified: 2019-03-18 21:30 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

test file with charts and explanations (23.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-06-18 02:16 UTC, bugquestcontri
excel chart (49.46 KB, image/png)
2014-11-22 09:44 UTC, raal
screenshot made in Libo (36.58 KB, image/png)
2014-11-24 13:06 UTC, bugquestcontri

Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2013-06-18 02:16:41 UTC
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: release
Comment 1 bugquestcontri 2013-06-18 02:17:33 UTC
I observed the same in LibO
Comment 2 m.a.riosv 2013-06-18 21:59:50 UTC
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.
Comment 3 bugquestcontri 2013-06-19 02:40:34 UTC
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.

Comment 4 bugquestcontri 2013-06-19 02:45:08 UTC
I just found the left status field and changed it to REOPEN. See my comment above for details
Comment 5 Joel Madero 2014-11-06 22:03:31 UTC
Need independent confirmation from QA - moving to UNCONFIRMED.
Comment 6 bugquestcontri 2014-11-08 14:08:39 UTC
I made the same in v and observed he same off-set of a data point from the vertical grid line.
Comment 7 raal 2014-11-22 09:44:17 UTC
Created attachment 109841 [details]
excel chart
Comment 8 raal 2014-11-22 09:45:03 UTC
Setting as enhancement.
Comment 9 bugquestcontri 2014-11-24 13:06:38 UTC
Created attachment 109939 [details]
screenshot made in Libo

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. 

Comment 10 Regina Henschel 2017-10-14 16:30:01 UTC
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.