Ask Your Question
0

How do you plot time series in calc? [closed]

asked 2013-02-28 09:14:35 +0100

user1934851 gravatar image

updated 2014-01-08 01:24:22 +0100

oweng gravatar image

Hello, I would like to plot a time series in libreoffice calc and I am having some issues.

My graphs are always blank when I try to plot my data.

All of my data was exported from C# and powershell from DateTime objects, so the data is in a time format as follows

HH:MM:SS.FFFFFF

Wherein

HH = Hours
MM = Minutes
SS = Seconds
FF = Fractions of a second

Thank you.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-25 00:59:06.073675

3 Answers

Sort by » oldest newest most voted
0

answered 2013-02-28 17:03:11 +0100

w_whalley gravatar image

Calc may have failed to interpret your string HH:MM:SS.FFFF as a time and left it as a string. You can test this by using the function ISNUMBER(). A string will return FALSE.

If this is the case, try this: select your time values and use Data/Text to Columns using the default to change the column type to Standard. There are other ways to convert the string HH:MM:SS.FFFF to a fractional day, but Text to Columns seems easiest.

edit flag offensive delete link more
0

answered 2013-02-28 16:09:16 +0100

ROSt52 gravatar image

Calc can deal with such time values on the x- and y-axis. Nothing special. Create your data array and build your chart

edit flag offensive delete link more

Comments

Additional comment: time format is HH:MM:SS.000 Number of 0s are the number of digits.

ROSt52 gravatar imageROSt52 ( 2013-02-28 16:09:49 +0100 )edit

Additional comment:

ROSt52 gravatar imageROSt52 ( 2013-02-28 16:09:56 +0100 )edit
0

answered 2013-02-28 17:02:33 +0100

user1934851 gravatar image

It had to do with two things,

  1. Removing erronious characters in data -> '
  2. Formatting of cells in a Time format

After I did this I was able to create graphs without problems.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-02-28 09:14:35 +0100

Seen: 6,879 times

Last updated: Feb 28 '13