+ Reply to Thread
Results 1 to 2 of 2

Displaying x-axis scale as mm/dd/yy hh:mm:ss

  1. #1
    Registered User
    Join Date

    Displaying x-axis scale as mm/dd/yy hh:mm:ss

    Hi there,
    I have to plot pressure data that's been automatically recorded by a data-logger, using Excel 2003; the logger records the date/time in the following format in each cell: 11/25/2006 10:03:00, 11/25/2006 10:22:00, 11/25/2006 10:42:00, 11/25/2006 11:02:00...etc. When I try to do a simple scatter plot of the data, the scale on the x-axis turns comes up with very strange values (i.e. the scale will start at Jan 0, 1900 (!) or in other instances less 'strange' dates, but still not reflective of the actual date/time stamp). I've tried to use different formats on the "number" tab, but with no luck. Also, I've found that when I click on the "link to source" box, it scales the axis with a series of numbers that corresponds to the number of cells that have been included in the data series. Since I'm working with a reasonably large number of data points (data recorded roughly every 20 minutes, from November 2006 till the present time) this gives me an x-axis that's scaled from 0 to 35 000. Can anyone offer suggestions as to how I can get Excel to recognize the actual value for the data points?

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Hi there,

    This worked for me as far as removing "strange" values is concerned.

    Right-click on the x-axis, select Format Axis > Number > Custom & enter dd/mm/yyyy hh:mm

    You seem to have an awful lot of data points on your graph - have you considered using a selectable "time-window" approach?


    Greg M

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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