LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default charting time series with milliseconds with scatter

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding and Subtracting a Time with MilliSeconds carl Excel Worksheet Functions 8 April 5th 23 02:41 PM
Charting Time Series Data klbva Charts and Charting in Excel 1 November 3rd 06 05:09 PM
Comparing time values which have milliseconds in them e.g 10:20:30 Jon Stickings Excel Discussion (Misc queries) 5 October 5th 06 02:03 PM
Time-Series Charting asaylor Charts and Charting in Excel 3 July 19th 06 04:12 PM
Alternatives for Excel for charting dated time-series? Matthew Pollock Charts and Charting in Excel 2 March 7th 05 01:20 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"