Problem with Excel chart

[lgarcia3]

I have the following set of data. I am trying to create an XY chart wit
dots connected by a line. The line itself, however, is not coming up
Can anyone tell me what's going on?
Thanks!!
12/10/2003 19:40 0
12/10/2003 19:50
12/10/2003 20:00
12/10/2003 20:10
12/10/2003 20:20
12/10/2003 20:30
12/10/2003 20:40
12/10/2003 20:50
12/10/2003 21:00
12/10/2003 21:10
12/10/2003 21:20
12/10/2003 21:30
12/10/2003 21:40
12/10/2003 21:50
12/10/2003 22:00
12/10/2003 22:10
12/10/2003 22:20
12/10/2003 22:30
12/10/2003 22:40
12/10/2003 22:50
12/10/2003 23:00
12/10/2003 23:10
12/10/2003 23:20
12/10/2003 23:30
12/10/2003 23:40
12/10/2003 23:50
12/11/2003 0:00
12/11/2003 0:10
12/11/2003 0:20
12/11/2003 0:30
12/11/2003 0:40
12/11/2003 0:50
12/11/2003 1:00
12/11/2003 1:10
12/11/2003 1:20
12/11/2003 1:30
12/11/2003 1:40
12/11/2003 1:50
12/11/2003 2:00
12/11/2003 2:10
12/11/2003 2:20
12/11/2003 2:30
12/11/2003 2:40
12/11/2003 2:50
12/11/2003 3:00
12/11/2003 3:10
12/11/2003 3:20
12/11/2003 3:30
12/11/2003 3:40
12/11/2003 3:50
12/11/2003 4:00
12/11/2003 4:10
12/11/2003 4:20
12/11/2003 4:30
12/11/2003 4:40
12/11/2003 4:50
12/11/2003 5:00
12/11/2003 5:10
12/11/2003 5:20
12/11/2003 5:30
12/11/2003 5:40
12/11/2003 5:50
12/11/2003 6:00
12/11/2003 6:10
12/11/2003 6:20
12/11/2003 6:30
12/11/2003 6:40
12/11/2003 6:50
12/11/2003 7:00
12/11/2003 7:10
12/11/2003 7:20
12/11/2003 7:30
12/11/2003 7:40
12/11/2003 7:50
12/11/2003 8:00
12/11/2003 8:10
12/11/2003 8:20
12/11/2003 8:30
12/11/2003 8:40 0
12/11/2003 8:50
12/11/2003 9:00
12/11/2003 9:10
12/11/2003 9:20
12/11/2003 9:30
12/11/2003 9:40
12/11/2003 9:50
12/11/2003 10:00
12/11/2003 10:10
12/11/2003 10:20
12/11/2003 10:30
12/11/2003 10:40
12/11/2003 10:50
12/11/2003 11:00
12/11/2003 11:10
12/11/2003 11:20
12/11/2003 11:30
12/11/2003 11:40
12/11/2003 11:50 6.380885556
12/11/2003 12:00
12/11/2003 12:10
12/11/2003 12:20
12/11/2003 12:30
12/11/2003 12:40
12/11/2003 12:50
12/11/2003 13:00
12/11/2003 13:10
12/11/2003 13:20
12/11/2003 13:30
12/11/2003 13:40
12/11/2003 13:50
12/11/2003 14:00
12/11/2003 14:10
12/11/2003 14:20
12/11/2003 14:30
12/11/2003 14:40
12/11/2003 14:50
12/11/2003 15:00
12/11/2003 15:10 9.537026918
12/11/2003 15:20
12/11/2003 15:30
12/11/2003 15:40
12/11/2003 15:50
12/11/2003 16:00
12/11/2003 16:10
12/11/2003 16:20
12/11/2003 16:30
12/11/2003 16:40
12/11/2003 16:50
12/11/2003 17:00
12/11/2003 17:10
12/11/2003 17:20
12/11/2003 17:30
12/11/2003 17:40
12/11/2003 17:50
12/11/2003 18:00
12/11/2003 18:10
12/11/2003 18:20
12/11/2003 18:30 0.808555642
12/11/2003 18:40
12/11/2003 18:50
12/11/2003 19:00
12/11/2003 19:10
12/11/2003 19:20
12/11/2003 19:30
12/11/2003 19:40
12/11/2003 19:50
12/11/2003 20:00
12/11/2003 20:10
12/11/2003 20:20
12/11/2003 20:30
12/11/2003 20:40
12/11/2003 20:50
12/11/2003 21:00
12/11/2003 21:10
12/11/2003 21:20
12/11/2003 21:30
12/11/2003 21:40
12/11/2003 21:50 0.452966755
12/11/2003 22:00
12/11/2003 22:10
12/11/2003 22:20
12/11/2003 22:30
12/11/2003 22:40
12/11/2003 22:50
12/11/2003 23:00
12/11/2003 23:10
12/11/2003 23:20
12/11/2003 23:30
12/11/2003 23:40
12/11/2003 23:50
12/12/2003 0:00
12/12/2003 0:10
12/12/2003 0:20
12/12/2003 0:30
12/12/2003 0:40
12/12/2003 0:50
12/12/2003 1:00
12/12/2003 1:10 0.367275879
12/12/2003 1:20
12/12/2003 1:30
12/12/2003 1:40
12/12/2003 1:50
12/12/2003 2:00
12/12/2003 2:10
12/12/2003 2:20
12/12/2003 2:30
12/12/2003 2:40
12/12/2003 2:50
12/12/2003 3:00
12/12/2003 3:10
12/12/2003 3:20
12/12/2003 3:30
12/12/2003 3:40
12/12/2003 3:50
12/12/2003 4:00
12/12/2003 4:10
12/12/2003 4:20
12/12/2003 4:30 0.302889718
12/12/2003 4:40
12/12/2003 4:50
12/12/2003 5:00
12/12/2003 5:10
12/12/2003 5:20
12/12/2003 5:30
12/12/2003 5:40
12/12/2003 5:50
12/12/2003 6:00
12/12/2003 6:10
12/12/2003 6:20
12/12/2003 6:30
12/12/2003 6:40
12/12/2003 6:50
12/12/2003 7:00
12/12/2003 7:10
12/12/2003 7:20
12/12/2003 7:30
12/12/2003 7:40
12/12/2003 7:50 0.255369846
12/12/2003 8:00
12/12/2003 8:10
12/12/2003 8:20
12/12/2003 8:30
12/12/2003 8:40
12/12/2003 8:50
12/12/2003 9:00
12/12/2003 9:10
12/12/2003 9:20
12/12/2003 9:30
12/12/2003 9:40
12/12/2003 9:50
12/12/2003 10:00
12/12/2003 10:10
12/12/2003 10:20
12/12/2003 10:30
12/12/2003 10:40
12/12/2003 10:50
12/12/2003 11:00
12/12/2003 11:10 0.215376105
12/12/2003 11:20
12/12/2003 11:30
12/12/2003 11:40
12/12/2003 11:50
12/12/2003 12:00
12/12/2003 12:10
12/12/2003 12:20
12/12/2003 12:30
12/12/2003 12:40
12/12/2003 12:50
12/12/2003 13:00
12/12/2003 13:10
12/12/2003 13:20
12/12/2003 13:30
12/12/2003 13:40
12/12/2003 13:50
12/12/2003 14:00
12/12/2003 14:10
12/12/2003 14:20
12/12/2003 14:30 0.193026941
12/12/2003 14:40
12/12/2003 14:50
12/12/2003 15:00
12/12/2003 15:10
12/12/2003 15:20
12/12/2003 15:30
12/12/2003 15:40
12/12/2003 15:50
12/12/2003 16:00
12/12/2003 16:10
12/12/2003 16:20
12/12/2003 16:30
12/12/2003 16:40
12/12/2003 16:50
12/12/2003 17:00
12/12/2003 17:10
12/12/2003 17:20
12/12/2003 17:30
12/12/2003 17:40
12/12/2003 17:50 0.17205664
12/12/2003 18:00
12/12/2003 18:10
12/12/2003 18:20
12/12/2003 18:30
12/12/2003 18:40
12/12/2003 18:50
12/12/2003 19:00
12/12/2003 19:10
12/12/2003 19:20
12/12/2003 19:30
12/12/2003 19:40
12/12/2003 19:50
12/12/2003 20:00
12/12/2003 20:10
12/12/2003 20:20
12/12/2003 20:30
12/12/2003 20:40
12/12/2003 20:50
12/12/2003 21:00
12/12/2003 21:10 0.157270258
12/12/2003 21:20
12/12/2003 21:30
12/12/2003 21:40
12/12/2003 21:50
12/12/2003 22:00
12/12/2003 22:10
12/12/2003 22:20
12/12/2003 22:30
12/12/2003 22:40
12/12/2003 22:50
12/12/2003 23:00
12/12/2003 23:10
12/12/2003 23:20
12/12/2003 23:30
12/12/2003 23:40
12/12/2003 23:50
12/13/2003 0:00
12/13/2003 0:10
12/13/2003 0:20
12/13/2003 0:30 0.144824206
12/13/2003 0:40
12/13/2003 0:50
12/13/2003 1:00
12/13/2003 1:10
12/13/2003 1:20
12/13/2003 1:30
12/13/2003 1:40
12/13/2003 1:50
12/13/2003 2:00
12/13/2003 2:10
12/13/2003 2:20
12/13/2003 2:30
12/13/2003 2:40
12/13/2003 2:50
12/13/2003 3:00
12/13/2003 3:10
12/13/2003 3:20
12/13/2003 3:30
12/13/2003 3:40
12/13/2003 3:50 0.134204422
12/13/2003 4:00
12/13/2003 4:10
12/13/2003 4:20
12/13/2003 4:30
12/13/2003 4:40
12/13/2003 4:50
12/13/2003 5:00
12/13/2003 5:10
12/13/2003 5:20
12/13/2003 5:30
12/13/2003 5:40
12/13/2003 5:50
12/13/2003 6:00
12/13/2003 6:10
12/13/2003 6:20
12/13/2003 6:30
12/13/2003 6:40
12/13/2003 6:50
12/13/2003 7:00
12/13/2003 7:10 0.125034993

 

[Guest]

Hi lgarcia3
I assume that you are graphing the date and time against the other value. The problem you are running into is becuase of all the blank values. Since these data sets don't have a Y value, excel is treating them as a break in the data

You could sort your data on the second column, then select the complete data sets, and then resort these on the first column. Now you will have a continuous set of points, and will get the connecting line

Another option is to fill in all of the blanks with an N/A# error. This will force excel to ignore those data sets rather then treat them as breaks. You would enter the formula =NA() in these cells

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- lgarcia3 > wrote: ----

I have the following set of data. I am trying to create an XY chart wit
dots connected by a line. The line itself, however, is not coming up
Can anyone tell me what's going on
Thanks!
12/10/2003 19:40
12/10/2003 19:50
12/10/2003 20:00
12/10/2003 20:10
12/10/2003 20:20
12/10/2003 20:30
12/10/2003 20:40
12/10/2003 20:50
12/10/2003 21:00
12/10/2003 21:10
12/10/2003 21:20
12/10/2003 21:30
12/10/2003 21:40
12/10/2003 21:50
12/10/2003 22:00
12/10/2003 22:10
12/10/2003 22:20
12/10/2003 22:30
12/10/2003 22:40
12/10/2003 22:50
12/10/2003 23:00
12/10/2003 23:10
12/10/2003 23:20
12/10/2003 23:30
12/10/2003 23:40
12/10/2003 23:50
12/11/2003 0:00
12/11/2003 0:10
12/11/2003 0:20
12/11/2003 0:30
12/11/2003 0:40
12/11/2003 0:50
12/11/2003 1:00
12/11/2003 1:10
12/11/2003 1:20
12/11/2003 1:30
12/11/2003 1:40
12/11/2003 1:50
12/11/2003 2:00
12/11/2003 2:10
12/11/2003 2:20
12/11/2003 2:30
12/11/2003 2:40
12/11/2003 2:50
12/11/2003 3:00
12/11/2003 3:10
12/11/2003 3:20
12/11/2003 3:30
12/11/2003 3:40
12/11/2003 3:50
12/11/2003 4:00
12/11/2003 4:10
12/11/2003 4:20
12/11/2003 4:30
12/11/2003 4:40
12/11/2003 4:50
12/11/2003 5:00
12/11/2003 5:10
12/11/2003 5:20
12/11/2003 5:30
12/11/2003 5:40
12/11/2003 5:50
12/11/2003 6:00
12/11/2003 6:10
12/11/2003 6:20
12/11/2003 6:30
12/11/2003 6:40
12/11/2003 6:50
12/11/2003 7:00
12/11/2003 7:10
12/11/2003 7:20
12/11/2003 7:30
12/11/2003 7:40
12/11/2003 7:50
12/11/2003 8:00
12/11/2003 8:10
12/11/2003 8:20
12/11/2003 8:30
12/11/2003 8:40
12/11/2003 8:50
12/11/2003 9:00
12/11/2003 9:10
12/11/2003 9:20
12/11/2003 9:30
12/11/2003 9:40
12/11/2003 9:50
12/11/2003 10:00
12/11/2003 10:10
12/11/2003 10:20
12/11/2003 10:30
12/11/2003 10:40
12/11/2003 10:50
12/11/2003 11:00
12/11/2003 11:10
12/11/2003 11:20
12/11/2003 11:30
12/11/2003 11:40
12/11/2003 11:50 6.38088555
12/11/2003 12:00
12/11/2003 12:10
12/11/2003 12:20
12/11/2003 12:30
12/11/2003 12:40
12/11/2003 12:50
12/11/2003 13:00
12/11/2003 13:10
12/11/2003 13:20
12/11/2003 13:30
12/11/2003 13:40
12/11/2003 13:50
12/11/2003 14:00
12/11/2003 14:10
12/11/2003 14:20
12/11/2003 14:30
12/11/2003 14:40
12/11/2003 14:50
12/11/2003 15:00
12/11/2003 15:10 9.53702691
12/11/2003 15:20
12/11/2003 15:30
12/11/2003 15:40
12/11/2003 15:50
12/11/2003 16:00
12/11/2003 16:10
12/11/2003 16:20
12/11/2003 16:30
12/11/2003 16:40
12/11/2003 16:50
12/11/2003 17:00
12/11/2003 17:10
12/11/2003 17:20
12/11/2003 17:30
12/11/2003 17:40
12/11/2003 17:50
12/11/2003 18:00
12/11/2003 18:10
12/11/2003 18:20
12/11/2003 18:30 0.80855564
12/11/2003 18:40
12/11/2003 18:50
12/11/2003 19:00
12/11/2003 19:10
12/11/2003 19:20
12/11/2003 19:30
12/11/2003 19:40
12/11/2003 19:50
12/11/2003 20:00
12/11/2003 20:10
12/11/2003 20:20
12/11/2003 20:30
12/11/2003 20:40
12/11/2003 20:50
12/11/2003 21:00
12/11/2003 21:10
12/11/2003 21:20
12/11/2003 21:30
12/11/2003 21:40
12/11/2003 21:50 0.452966755
12/11/2003 22:00
12/11/2003 22:10
12/11/2003 22:20
12/11/2003 22:30
12/11/2003 22:40
12/11/2003 22:50
12/11/2003 23:00
12/11/2003 23:10
12/11/2003 23:20
12/11/2003 23:30
12/11/2003 23:40
12/11/2003 23:50
12/12/2003 0:00
12/12/2003 0:10
12/12/2003 0:20
12/12/2003 0:30
12/12/2003 0:40
12/12/2003 0:50
12/12/2003 1:00
12/12/2003 1:10 0.367275879
12/12/2003 1:20
12/12/2003 1:30
12/12/2003 1:40
12/12/2003 1:50
12/12/2003 2:00
12/12/2003 2:10
12/12/2003 2:20
12/12/2003 2:30
12/12/2003 2:40
12/12/2003 2:50
12/12/2003 3:00
12/12/2003 3:10
12/12/2003 3:20
12/12/2003 3:30
12/12/2003 3:40
12/12/2003 3:50
12/12/2003 4:00
12/12/2003 4:10
12/12/2003 4:20
12/12/2003 4:30 0.302889718
12/12/2003 4:40
12/12/2003 4:50
12/12/2003 5:00
12/12/2003 5:10
12/12/2003 5:20
12/12/2003 5:30
12/12/2003 5:40
12/12/2003 5:50
12/12/2003 6:00
12/12/2003 6:10
12/12/2003 6:20
12/12/2003 6:30
12/12/2003 6:40
12/12/2003 6:50
12/12/2003 7:00
12/12/2003 7:10
12/12/2003 7:20
12/12/2003 7:30
12/12/2003 7:40
12/12/2003 7:50 0.255369846
12/12/2003 8:00
12/12/2003 8:10
12/12/2003 8:20
12/12/2003 8:30
12/12/2003 8:40
12/12/2003 8:50
12/12/2003 9:00
12/12/2003 9:10
12/12/2003 9:20
12/12/2003 9:30
12/12/2003 9:40
12/12/2003 9:50
12/12/2003 10:00
12/12/2003 10:10
12/12/2003 10:20
12/12/2003 10:30
12/12/2003 10:40
12/12/2003 10:50
12/12/2003 11:00
12/12/2003 11:10 0.215376105
12/12/2003 11:20
12/12/2003 11:30
12/12/2003 11:40
12/12/2003 11:50
12/12/2003 12:00
12/12/2003 12:10
12/12/2003 12:20
12/12/2003 12:30
12/12/2003 12:40
12/12/2003 12:50
12/12/2003 13:00
12/12/2003 13:10
12/12/2003 13:20
12/12/2003 13:30
12/12/2003 13:40
12/12/2003 13:50
12/12/2003 14:00
12/12/2003 14:10
12/12/2003 14:20
12/12/2003 14:30 0.193026941
12/12/2003 14:40
12/12/2003 14:50
12/12/2003 15:00
12/12/2003 15:10
12/12/2003 15:20
12/12/2003 15:30
12/12/2003 15:40
12/12/2003 15:50
12/12/2003 16:00
12/12/2003 16:10
12/12/2003 16:20
12/12/2003 16:30
12/12/2003 16:40
12/12/2003 16:50
12/12/2003 17:00
12/12/2003 17:10
12/12/2003 17:20
12/12/2003 17:30
12/12/2003 17:40
12/12/2003 17:50 0.17205664
12/12/2003 18:00
12/12/2003 18:10
12/12/2003 18:20
12/12/2003 18:30
12/12/2003 18:40
12/12/2003 18:50
12/12/2003 19:00
12/12/2003 19:10
12/12/2003 19:20
12/12/2003 19:30
12/12/2003 19:40
12/12/2003 19:50
12/12/2003 20:00
12/12/2003 20:10
12/12/2003 20:20
12/12/2003 20:30
12/12/2003 20:40
12/12/2003 20:50
12/12/2003 21:00
12/12/2003 21:10 0.157270258
12/12/2003 21:20
12/12/2003 21:30
12/12/2003 21:40
12/12/2003 21:50
12/12/2003 22:00
12/12/2003 22:10
12/12/2003 22:20
12/12/2003 22:30
12/12/2003 22:40
12/12/2003 22:50
12/12/2003 23:00
12/12/2003 23:10
12/12/2003 23:20
12/12/2003 23:30
12/12/2003 23:40
12/12/2003 23:50
12/13/2003 0:00
12/13/2003 0:10
12/13/2003 0:20
12/13/2003 0:30 0.144824206
12/13/2003 0:40
12/13/2003 0:50
12/13/2003 1:00
12/13/2003 1:10
12/13/2003 1:20
12/13/2003 1:30
12/13/2003 1:40
12/13/2003 1:50
12/13/2003 2:00
12/13/2003 2:10
12/13/2003 2:20
12/13/2003 2:30
12/13/2003 2:40
12/13/2003 2:50
12/13/2003 3:00
12/13/2003 3:10
12/13/2003 3:20
12/13/2003 3:30
12/13/2003 3:40
12/13/2003 3:50 0.134204422
12/13/2003 4:00
12/13/2003 4:10
12/13/2003 4:20
12/13/2003 4:30
12/13/2003 4:40
12/13/2003 4:50
12/13/2003 5:00
12/13/2003 5:10
12/13/2003 5:20
12/13/2003 5:30
12/13/2003 5:40
12/13/2003 5:50
12/13/2003 6:00
12/13/2003 6:10
12/13/2003 6:20
12/13/2003 6:30
12/13/2003 6:40
12/13/2003 6:50
12/13/2003 7:00
12/13/2003 7:10 0.125034993