Am 23.08.2013 22:30, schrieb Brian Barker:
At 21:37 23/08/2013 +0200, you wrote:
I try to compare different data series. Therefore I want to create a
bar chart where the x-axis is the timestamp and the y-axis contains
I suspect this is what Calc calls a column chart.
I saw year, month and day but nothing for time. Is it impossible to
use days and hours of timestamps as x-axis.
I'm not sure exactly what your problem is here. Is it just that the
default cell formats are generally for dates or times and not the
particular combination you require? You can create your own formats
in the "Format code" box at the bottom of the Format Cells dialogue.
Do you need something like "DD HH" or "NN HH"?
Or perhaps you mean something else?
I trust this helps.
Brian Barker - privately
Thanks Brian for your help, what you did in your example is setting the
x-axis format to text. This is a bit different from time-stamp. For a
time-stamp missing entries could be inserted as null values and
therefore stretch the x-axis. For example, if you look at a day, 0 to 24
hour, and you have values at 1,2 and 4. You get a hole in the graph for
the 3 value. _||_|___________
If you do it as text, this hole is missing, _|||______.
This is very important if you have sparse data of different origins, the
value at 10:01h and 10:55h should be matched to the hour 10 in the
chart. This is only possible if chart knows it is a time-stamp.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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