GNOME Bugzilla – Bug 611362
Line charts don't format date labels correctly
Last modified: 2010-03-02 16:11:38 UTC
Created attachment 154886 [details] File that demonstrates the bug I have one column of dates and one column of numerical data. If I create a line chart using the dates as labels, they will be printed along the X axis as numerical values, not as dates, and there does not seem to be a way to change their format to make them appear as dates instead. Attaching a sample file. The chart was created as follows: 1. Select B3:C13 2. "Insert" -> "Chart" 3. Select plot type "Line", subtype "Unmarked line plot". 4. Select "Use first series as shared abscissa" 5. Click "Forward". The date values are now shown as numbers, not dates, along the X axis. Note that there is no "Format" page for the X axis. 6. Click "Insert" and place the chart on the page. The dates are shown as numerical values along the X axis, not as dates.
Seems that the cell nodes in your file miss a ValueFormat property. Just typing again the dates in 1.10 fixes the issue. Probably something that has been fixed recently, but it's a bit annoying that old files are not correctly imported. Morten, any idea?
The file was created using 1.10.0.
Really, that makes things even more weird.
This is a "line" graph. I think you meant to use an xy type graph with the dates as the X and the rest as Y. The actual X axis in your graph takes numbers 1, 2, ... That's why there is no format page -- if you we to set the format it would apply to the ordinals, not the labels, and hence not be terribly useful. I doubt anyone actually looked at this before, but it should of course be made to work, somehow. --> Enhancement.
Morten, this is not the issue, the labels should be displayed using the cell formats, and this is what I get when I use a new file, but not with his sample.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report. (But you should still use an xy graph for this. That will correctly handle, for example, missing days.)