Plotting Date/Time vs. Temperature

[qwaszx]

Please help! I have to finish this by tomorrow. How do I plot Date/Time vs. Temperature? I have a column of cells formatted like "1/1/2017 12:00:00 AM CST" and the other column simply temperatures "88.98468" I need temp on y-axis and date/time on x-axis. The times are in 5 minute increments.

Here is what my data looks like (Except it goes on for 3 months)

Time	3C-NE1-T(Slab Temp)
1/1/17 12:00:00 AM CST	83.50618
1/1/17 12:15:00 AM CST	83.50618
1/1/17 12:30:00 AM CST	83.80544
1/1/17 12:45:00 AM CST	83.80544
1/1/17 1:00:00 AM CST	83.80544
1/1/17 1:15:00 AM CST	83.80544
1/1/17 1:30:00 AM CST	83.80544
1/1/17 1:45:00 AM CST	84.10499
1/1/17 2:00:00 AM CST	84.10499
1/1/17 2:15:00 AM CST	84.10499
1/1/17 2:30:00 AM CST	84.10499
1/1/17 2:45:00 AM CST	84.10499
1/1/17 3:00:00 AM CST	84.10499
1/1/17 3:15:00 AM CST	84.10499
1/1/17 3:30:00 AM CST	84.40694
1/1/17 3:45:00 AM CST	84.40694
1/1/17 4:00:00 AM CST	84.40694
1/1/17 4:15:00 AM CST	84.40694
1/1/17 4:30:00 AM CST	84.40694
1/1/17 4:45:00 AM CST	84.40694
1/1/17 5:00:00 AM CST	84.40694
1/1/17 5:15:00 AM CST	84.40694
1/1/17 5:30:00 AM CST	84.40694
1/1/17 5:45:00 AM CST	84.40694
1/1/17 6:00:00 AM CST	84.40694
1/1/17 6:15:00 AM CST	84.70677
1/1/17 6:30:00 AM CST	84.70677
1/1/17 6:45:00 AM CST	84.70677
1/1/17 7:00:00 AM CST	84.70677
1/1/17 7:15:00 AM CST	84.70677
1/1/17 7:30:00 AM CST	84.70677
1/1/17 7:45:00 AM CST	84.70677
1/1/17 8:00:00 AM CST	84.70677
1/1/17 8:15:00 AM CST	84.70677

<tbody>
</tbody>

 

[JustynaMK]

Hi qwaszx,

1) You should try removing " AM CST" suffix from the whole column A, in order to force Excel to recognize these fields as date & time. Make sure that the cell format is now set to "Custom" (dd/mm/yyyy hh:mm).
2) Select both columns A & B and create a Scatter chart (instead of a Line chart), it should properly present the data.
3) You can now format your new chart -> remove the Marker and add a Line in order to connect all points.

Hope it helps.

 

[qwaszx]

I have tried this and the dates on the x-axis appear wrong. The dates show as 00/01/1900 22/06/1905 and other random dates. How do I correct this?

 

[JustynaMK]

Hi, sorry for the delay - I am based in UK.
Let me know what Cell Format you have in column A (the one with dates), and also what is the format of X-axis (date axis) on your Scatter Chart?