Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am trying to plot data dumped to csv file with time series so X Axis is the
time in following format (currently): Dec-1-2009 09:48:39.972 AM I can change this format if it helps. The times are sample times of data and are not uniform in interval. So chart needs to respect the the different XAxis intervals between ticks. I update the data from csv file it looks fine. I put it in a scatter - straight line - with markers. But I can't get the XAxis correct. I can change the format of the datetime stamp in the csv file - this would be no problem. I have seen many false paths on the internet of someone asking similiar questions. Anyone can direct me to a good source for charting scientific type samples in milliseconds with excel 2007 - with a date that has the Month Day Year hours min secs and milliseconds ? Here is typical data: Dec-1-2009 09:48:39.972 AM 203.85 Dec-1-2009 09:48:50.619 AM 212.28 Dec-1-2009 09:49:01.266 AM 189.59 Dec-1-2009 09:49:11.913 AM 206.41 Dec-1-2009 09:49:22.560 AM 209.3 Dec-1-2009 09:49:33.207 AM 196.99 Dec-1-2009 09:52:23.559 AM 196.77 Dec-1-2009 09:52:34.206 AM 198.09 Dec-1-2009 09:52:44.853 AM 199.59 Dec-1-2009 09:52:55.500 AM 203.87 Dec-1-2009 09:53:06.147 AM 193.87 Dec-1-2009 09:53:16.794 AM 188.1 Dec-1-2009 09:53:27.441 AM 212.21 Dec-1-2009 09:53:38.088 AM 182.68 Dec-1-2009 09:53:48.735 AM 212.35 Dec-1-2009 09:53:59.382 AM 210.95 Dec-1-2009 09:54:10.029 AM 210.79 Thanks , Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding and Subtracting a Time with MilliSeconds | Excel Worksheet Functions | |||
Charting Time Series Data | Charts and Charting in Excel | |||
Comparing time values which have milliseconds in them e.g 10:20:30 | Excel Discussion (Misc queries) | |||
Time-Series Charting | Charts and Charting in Excel | |||
Alternatives for Excel for charting dated time-series? | Charts and Charting in Excel |