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?
Thanks!!
Bookmarks