Page 1 of 1

[Solved] Chart problem time vs date

PostPosted: Mon Dec 02, 2019 5:21 am
by nelsonset
Hi All,
I'm having an issue with creating a chart from a log file this is the content of the log file:

16:12:11,21/11/2019
16:12:15,21/11/2019
16:12:16,21/11/2019
16:12:21,21/11/2019
16:12:24,21/11/2019
16:12:31,21/11/2019
16:12:31,21/11/2019
16:13:4,21/11/2019
16:13:7,21/11/2019

I have imported this data into calc, changed the first column in the properties to Time and the second to Date I have attached screenshot of what I get.
I don't know what I'm doing wrong?

Re: Chart problem time vs date

PostPosted: Mon Dec 02, 2019 5:34 am
by MrProgrammer
Hi, and welcome to the forum.

nelsonset wrote:I'm having an issue with creating a chart from a log file this is the content of the log file:
16:12:11,21/11/2019
16:12:15,21/11/2019
16:12:16,21/11/2019
16:12:21,21/11/2019
16:12:24,21/11/2019
16:12:31,21/11/2019
16:12:31,21/11/2019
16:13:4,21/11/2019
16:13:7,21/11/2019
I will guess that you should read [Tutorial] Text to Columns, especially Q41/A41. Your screen capture is useless for analyzing the problem. If you need further assistance after studying the tutorial attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

nelsonset wrote:I have imported this data into calc, changed the first column in the properties to Time and the second to Date
There are three Date selections; be sure to select Date (DMY).

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Mac FAQ

Re: [Solved] Chart problem time vs date

PostPosted: Mon Dec 02, 2019 6:07 am
by nelsonset
Thanks for your help ;-)

Re: [Solved] Chart problem time vs date

PostPosted: Mon Dec 02, 2019 6:21 am
by RusselB
Using Text to Columns will help with getting your data into the correct format, but if you're wanting to chart it using the Date & Time combined (eg: 21/11/2019 16:12:11) meaning Nov. 21 2019 at 4:12:11 pm, then some additional work will be required to get the information into the form that Calc is wanting for charting purposes.

Re: [Solved] Chart problem time vs date

PostPosted: Mon Dec 02, 2019 6:25 am
by nelsonset
RusselB wrote:Using Text to Columns will help with getting your data into the correct format, but if you're wanting to chart it using the Date & Time combined (eg: 21/11/2019 16:12:11) meaning Nov. 21 2019 at 4:12:11 pm, then some additional work will be required to get the information into the form that Calc is wanting for charting purposes.


How would I chart it using the Date & Time combined the way you mentioned?

Re: [Solved] Chart problem time vs date

PostPosted: Mon Dec 02, 2019 6:53 am
by RusselB
First use the Text to Columns so that you have your dates and times as numbers. Even from the screenshot you provided I can see that the times, and possibly (thinking probably) the dates are text, not numbers.
Presuming your Times and Dates are now in columns C & D, then in column E enter the formula
Code: Select all   Expand viewCollapse view
=c1+d1
then copy the formula down for all the used rows in your spreadsheet.
Now format column E using Format -> Cells (Ctrl+1)
You'll have to decide if you want to use one of the preset formats that are listed, or if you want to use a custom format.
Then make your chart using the information in column E for the appropriate axis.