Date / time for x axis chart

[LeepII]

I know this has been asked before, but I have tried every fix I have found on this board and microsofts, and none of them have worked.
Using Microsoft Office 365 ProPlus.

Just need a chart that shows temperature and humidity vs date/time. My data set is pretty small, only 20,000 lines over a week (the data logger records every 30 sec). No matter what I try excel positively refuses to put date / time on the x-axis.
I have: Formatted my date/time cells as date time, text, and general, no affect.
I have: selected the x axis and and said the data was time, no affect. Temperature and humidity cells have been formatted as numbers, general, text, no affect.
Tried scatterplot, 2d line both dont work.

Here is the first couple of lines of my data set to look at:

Sample

<tbody>
[TD="width: 64"]Temp (F)[/TD]
[TD="width: 64"]Hum (%RH)[/TD]
[TD="width: 64"]Dew Point (F)[/TD]
[TD="width: 184"]Date Time[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]71.4[/TD]
[TD="align: right"]51.85[/TD]
[TD="align: right"]52.79[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:07[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]71.7[/TD]
[TD="align: right"]50.25[/TD]
[TD="align: right"]52.22[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:07[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]71.85[/TD]
[TD="align: right"]49.1[/TD]
[TD="align: right"]51.73[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:08[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]71.85[/TD]
[TD="align: right"]48.7[/TD]
[TD="align: right"]51.51[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:08[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]71.85[/TD]
[TD="align: right"]48.5[/TD]
[TD="align: right"]51.39[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:09[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]71.75[/TD]
[TD="align: right"]48.55[/TD]
[TD="align: right"]51.33[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:09[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"]71.75[/TD]
[TD="align: right"]48.55[/TD]
[TD="align: right"]51.33[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:10[/TD]

[TD="align: right"]8[/TD]
[TD="align: right"]71.7[/TD]
[TD="align: right"]48.45[/TD]
[TD="align: right"]51.23[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:10[/TD]

[TD="align: right"]9[/TD]
[TD="align: right"]71.7[/TD]
[TD="align: right"]48.45[/TD]
[TD="align: right"]51.23[/TD]
[TD="class: xl63, align: right"]5/16/2018 9:11[/TD]

</tbody>

The plan was to write a VBA to auto import the data and have the charts update weekly, but I cannot get excel to produce the chart in the first place so I can never get to the actual scripting.

Any help would be most appreciated.

 

[Oscar Cronquist]

I have: selected the x axis and and said the data was time, no affect. Temperature and humidity cells have been formatted as numbers, general, text, no affect.

I changed the x axis type to "Text axis" and date and time show up for all data points. Have you tried that?

 

[LeepII]

Oscar,

Yes I had tried the same, still had the same problem.

However Im stubborn, I finally found a method that always puts the date / time on the x axis. This method works no matter the formatting applied to the date / time column or the data column.

1 - Select the column that has the data you wanted plotted for the y-axis, DO NOT select the date / time column at this time.
2 - Insert 2D chart
3 - Right click on chart area and select "Select Data".
4 - Edit Horizontal
5 - Pick the column that has date/time for the data selected.
6 - Click OK, click OK.

You now have a chart that properly puts date / time on the x axis. No idea why excel makes it so difficult. JMP would just see date vs data and automatically sort it out.