Thread: Date range plotting - Non linear date range

Hello Forum,
The scenario is as follows:
Average temperature is taken for a room on non-linear intervals. Sometimes taken 15 mins apart, sometimes a couple hours passes between each time, and then no temperatures are taken throughout the night.

I am attempting to show the temperature changes over a 24 hour period but as the data is placed on the graph, the distance between each point on the line are equal. (See attached graph)

What I would like to see is somehow the date/time at the bottom of the graph should show its actual position instead of equally spaced.

(In the attached worksheet "temperature-timeline.zip") The graph shows the First time stamp at 15:04 (24 hr clock), the Second time stamp is one minute later. The Third timestamp is 4 minutes after but when excel places the points on the chart, the 3 points are equally spaced.

Is there any way for Excel to put these points in their relative positions instead of equally spaced apart?

Ive attached a JPG (temperature-timeline.jpg) which I created in MSPAINT which shows exactly what type of graph I am looking to create.

Thanks for any assistance.

Select the chart, do Chart > Chart Type, and change it to a scatter-plot.