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