Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.