Forum Discussion

Non's avatar
Non
Occasional Reader
Oct 26, 2025

How to create a Date-Time Temperature Graph

Hi there,

 

I was wondering if Excel is able to create a similar Date Time vs Temperature graph as shown, the green coded one? (the data was extracted from an app)

I want to be able to show the Date AND Time on my Excel chart

I want to make something like this with Excel

 

 

 

 

 

 

 

 

 

 

 

I have the raw number data but is unable to convert it into a graph similar to the one shown above, for reference the format of my raw data looks like this (below), but my raw data have three thousands results

Raw Data format

Thank you in advance to anyone who can help me!

- Non

1 Reply

  • I obtained this with a scatter chart but used a number format with Ctrl/J (line feed) inserted between the date and time elements of the format.

Resources