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.
Bookmarks