[Libreoffice-bugs] [Bug 137991] Date/time labelling in a chart is VERY poor

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137991

--- Comment #11 from Uwe Auer <uwe at franke-auer.de> ---
(In reply to Ralph Peters from comment #10)
> Created attachment 167101 [details]
> My bad plot
> 
> Hi Uwe,
> 
> Your last attachment/file worked fine!!  All looks correct.  Now I need to
> understand how to do what you did!  
> 
> This attachment shows what I get.  I can change the format of the x-axis to
> "Time" but then I get dates starting in 1900; this is not what I see when I
> inspect x-axis info in your chart.
> 
> I think (or hope) the difference is that somehow you have set the Format of
> Column A to BOTH "Date" and "Time" and I cannot figure out how to do that. 
> I can set the Format to EITHER "Date" or "Time".  Suggestions?
> 
> Thanks for your help!
> Ralph

Please understand that this is not a support forum but a bug tracker - please
ask your question at ask.libreoffice.org. My comment #3
https://bugs.documentfoundation.org/show_bug.cgi?id=137991#c3 directed to the
problems of your sheet. The dates are not calc dates but text, hence you need
to turn the text to date using `Data -> Text To Columns`. The second problem is
you are using a Line Chart, which is not the type of chart to be used if both
axis contain numerical data. You should use "XY(Scatter)" type chart.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201109/572feca6/attachment.htm>