+ Reply to Thread
Results 1 to 4 of 4

Date range plotting - Non linear date range

  1. #1
    Registered User
    Join Date
    10-14-2008
    Location
    Earth
    Posts
    11

    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.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by zhollett; 01-09-2009 at 03:55 PM. Reason: Solved

  2. #2
    Registered User
    Join Date
    01-08-2009
    Location
    Lincoln, England
    MS-Off Ver
    Excel 2007
    Posts
    7
    Hi,

    What kind of timeframe are you using for these graphs? If they are always from midnight to midnight for instance? Or 00:00 Monday to 23:59 Sunday?

    Regards
    James

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669
    Select the chart, do Chart > Chart Type, and change it to a scatter-plot.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    10-14-2008
    Location
    Earth
    Posts
    11
    Thanks shg.

    I was having troubles earlier with scatter because i had the date and temp columns reversed and didn't re-visit scatter again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1