Dumb Chart Question

[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

 

[Dav]

What kind of chart are you using?

An XY (scatter chart) will scale each axis and so "Put in" blanks, a
line chart with the date as the xaxis will put the dates next to eaxh
other

Regards

Dav

 

[Cormac Foster]

What kind of chart are you using?

An XY (scatter chart) will scale each axis and so "Put in" blanks, a
line chart with the date as the xaxis will put the dates next to eaxh
other

It seems to be the case with any chart type.

Here's a screenshot of a 2-row data set:

http://www.cormac.com/images/tmp/excel1.gif

And here's a resulting chart from that selection:

http://www.cormac.com/images/tmp/excel2.gif

Thanks!

 

[Debra Dalgleish]

For a Line Chart, select the chart, and choose Chart>Chart Options

 

[Cormac Foster]

Perfect!

Thanks!

For a Line Chart, select the chart, and choose Chart>Chart Options