Re: [libreoffice-users] Calc bar chart for timestamps

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: 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