Re: [libreoffice-users] data point not distributed equally on charts with date on the X-axis

Hi,

Le 10/06/2016 22:20, Harald Linden a écrit :
> Hello list,
>
> I'm trying to visualize a few CSVs from my router. The original CSV
> contains the date in epoch plus a few zeroes. I have converted that to
> date using =(A2/1000)/86400+25569.
>
> From that, I tried to generate a chart and the values pooled at certain
> points on the X-Axis, instead of distributing evenly. See an example here:
>
> https://owncloud.7183.org/index.php/s/qf42u9QpP9YooHY
>
> There are two charts in the document, the first labeled using the first
> column, the second labeled using the second column. Both should look
> equal, but obviously don't. Any idea why this happens and how to fix this?

Obviously, Calc uses the date instead of date+hour to define the
category. Why, I do not know. But it's clear that in this case you do
not have true categories because you have only one value for each
category. In such cases you should use XY chart type instead of line,
because what you want to show is a function F(t).

If you really want use line chart + categories, it works if you replace
the formula in column B by:
=TEXT((A2/1000)/86400+25569;"JJ/MM/AAAA HH:MM:SS")

Another point: you should use a secondary Y-axis to make state changes
visible.

Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted