Calc bar chart for timestamps

users
#1

I try to compare different data series. Therefor I want to create a bar
chart where the x-axis is the timestamp and the y-axis contains the
value. I saw year, month and day but nothing for time. Is it impossible
to use days and hours of timestamps as x-axis.

#2

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.

Yes, but a column chart has the same problem

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"?

In the x-axis scaling dialog, the smallest resolution I can choose is
day. No hour, no minute!

For me it seems impossible to show e.g. the temperature measurements of
the day, e.g. measured every 10 minutes. I'm using version 4.1.

#3

Hi :slight_smile:
Which OS are you using here?  Not sure if that makes a different tbh but it might help to know

Is the table-of-data able to hold the much finer grained time?  Is the column formatted as text or as date/time and how fine grained is that formatting?

Regards from
Tom :slight_smile:

#4

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.