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: [email protected] 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
