Values not displaying in chart

Solved
RomyZrl Posted messages 3 Registration date   Status Membre Last intervention   -  
RomyZrl Posted messages 3 Registration date   Status Membre Last intervention   -
Hello everyone,

As the title suggests, I created a "scatter plot" but not all the data in my series is displaying in the graph, even though they fall within the minimum and maximum of my axes (only the first data points are displaying properly).

I am attaching the file for you to understand more easily.

It's a timetable (hours between 6 AM & 8 AM) / location (kilometer point of the journey) for trains.

The relevant tabs are "Bildfahrplan 2" for the scatter plot; and the "Bildfahrplan 1" tab for the data. For now, I am only interested in the line named IC1003, for distances between -1.8 and 93.8.

https://www.cjoint.com/?0Acq3AqKfmJ

Thank you in advance if anyone can understand the problem (and explain how to fix it)

Configuration: Windows 7 / Chrome 39.0.2171.95

2 réponses

tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
The reason for the non-display on the graph is simple: the values not displayed have 1 day too many.
If we convert to standard format
06:42 >> 0.279...
06:44 >> 1.28...
The origin lies in the upstream sheets.

Look at columns J and K of the Info sheet.
2
RomyZrl Posted messages 3 Registration date   Status Membre Last intervention  
 
Thank you very much, Tontong, for your quick response! Indeed, it was problematic.

I was able to fix that by changing the values to standard format.
0