C
Cormac Foster
Hi. I have a simple worksheet tracking and calaculating the following
information about runs:
Date | Miles | Hours / Minutes | Minutes per Mile | Marathon Pace
Runs happen roughly 4x/week, so my entries might look like:
06/01/2006 | 6 | 1 / 0 | 10 | 3:42
06/03/2006 | 6 | 1 / 0 | 10 | 3:42
06/05/2006 | 6 | 1 / 0 | 10 | 3:42
etc.
The problem is that when I select 2 columns (let's say Date, Miles) to
chart them, Excel creates entries for the days not entered:
06/01/2006 XXXXXXXXXXXXXX
06/02/2006
06/03/2006 XXXXXXXXXXXXXX
06/04/2006
06/05/2006 XXXXXXXXXXXXXX
etc.
I've searched trough all the Chart Options and such, with no luck. I
must be missing something simple. Any ideas?
Any suggestions on a good way to enter run times as hh:mm and calculate
paces would be great, too. Right now I'm kluging it with hours and
minutes as separate fields.
Thanks!
C
information about runs:
Date | Miles | Hours / Minutes | Minutes per Mile | Marathon Pace
Runs happen roughly 4x/week, so my entries might look like:
06/01/2006 | 6 | 1 / 0 | 10 | 3:42
06/03/2006 | 6 | 1 / 0 | 10 | 3:42
06/05/2006 | 6 | 1 / 0 | 10 | 3:42
etc.
The problem is that when I select 2 columns (let's say Date, Miles) to
chart them, Excel creates entries for the days not entered:
06/01/2006 XXXXXXXXXXXXXX
06/02/2006
06/03/2006 XXXXXXXXXXXXXX
06/04/2006
06/05/2006 XXXXXXXXXXXXXX
etc.
I've searched trough all the Chart Options and such, with no luck. I
must be missing something simple. Any ideas?
Any suggestions on a good way to enter run times as hh:mm and calculate
paces would be great, too. Right now I'm kluging it with hours and
minutes as separate fields.
Thanks!
C