Forum Discussion
Non
Oct 26, 2025Occasional Reader
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 formatThank you in advance to anyone who can help me!
- Non
1 Reply
- PeterBartholomew1Silver Contributor
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.