I am trying to chart some data that is output by an application, following is the basic format of the data. Any help would be appreciated.
I am trying to do a line chart or a scatter chart with the data points connected where on the X axis "DATA1" would be one line, "DATA2" would be another line, and the date/time would be on the Y axis.
Date,Time,extra data(do not graph),Data Name,Data Point(seconds)
eg.
"2009/10/26","15:30:50","extradata","DATA1","3.937"
"2009/10/26","15:30:54","extradata","DATA2","3.391"
"2009/10/26","15:31:0","extradata","DATA3","4.797"
"2009/10/26","15:31:2","extradata","DATA4","1.953"
"2009/10/26","15:31:4","extradata","DATA5","2.093"
"2009/10/26","15:31:8","extradata","DATA6","3.469"
"2009/10/26","15:31:12","extradata","DATA7","4.438"
"2009/10/26","15:31:30","extradata","DATA8","17.813"
"2009/10/26","15:31:31","extradata","DATA9","0.671"
"2009/10/26","15:31:33","extradata","DATA1","0.531"
"2009/10/26","15:31:35","extradata","DATA2","1.937"
"2009/10/26","15:31:40","extradata","DATA3","3.313"
"2009/10/26","15:31:42","extradata","DATA4","1.813"
"2009/10/26","15:31:44","extradata","DATA5","1.562"
"2009/10/26","15:31:48","extradata","DATA6","4.453"
"2009/10/26","15:31:52","extradata","DATA7","3.922"
"2009/10/26","15:32:1","extradata","DATA8","9.5"
"2009/10/26","15:32:2","extradata","DATA9","0.484"
"2009/10/26","15:32:4","extradata","DATA1","0.563"
"2009/10/26","15:32:6","extradata","DATA2","1.782"
"2009/10/26","15:32:10","extradata","DATA3","2.36"
"2009/10/26","15:32:11","extradata","DATA4","1.672"
"2009/10/26","15:32:13","extradata","DATA5","1.25"
"2009/10/26","15:32:16","extradata","DATA6","3.25"
"2009/10/26","15:32:20","extradata","DATA7","3.891"
"2009/10/26","15:32:29","extradata","DATA8","9.313"
"2009/10/26","15:32:30","extradata","DATA9","0.562"
(BTW, I am a total excel newbie, so sorry if the question is a: too easy, or b: doesn't make sense)
Bookmarks