[Solved] Chart problem time vs date

Discuss the spreadsheet application

[Solved] Chart problem time vs date

Postby nelsonset » Mon Dec 02, 2019 5:21 am

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?
Attachments
Screen-Shot-2019-12-02-at-1.15.38-pm.jpg
this is the chart i get
Last edited by nelsonset on Mon Dec 02, 2019 6:07 am, edited 1 time in total.
OpenOffice 4.1.5
Mac OSX 10.12.6
nelsonset
 
Posts: 3
Joined: Mon Dec 02, 2019 4:55 am

Re: Chart problem time vs date

Postby MrProgrammer » Mon Dec 02, 2019 5:34 am

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
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3953
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: [Solved] Chart problem time vs date

Postby nelsonset » Mon Dec 02, 2019 6:07 am

Thanks for your help ;-)
OpenOffice 4.1.5
Mac OSX 10.12.6
nelsonset
 
Posts: 3
Joined: Mon Dec 02, 2019 4:55 am

Re: [Solved] Chart problem time vs date

Postby RusselB » Mon Dec 02, 2019 6:21 am

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.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: [Solved] Chart problem time vs date

Postby nelsonset » Mon Dec 02, 2019 6:25 am

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?
OpenOffice 4.1.5
Mac OSX 10.12.6
nelsonset
 
Posts: 3
Joined: Mon Dec 02, 2019 4:55 am

Re: [Solved] Chart problem time vs date

Postby RusselB » Mon Dec 02, 2019 6:53 am

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.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 2 guests