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

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
the value.

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.