time in the Y-axel...

[oRm]

Hi
I want to display my runners tracktime in a diagram (chart). It should be a
linear one so its possible to see the change over time easily.
I've managed to do that but I cant grade the Y-axel the way I want. :-(

This is what I've tried so far.

The source has been formatted with mm:ss (minutes and seconds), so I tried
to do the same in the settings for the diagram (chart). Dosen't work. Then
I've tried all values between 0->1 and nothing seems to work...

Could any kind soul give me a hint or some help, plz?!

Cheers oRm

 

[Fred Smith]

It can be done.

Remember that times in Excel are fractions of a day. So an hour is 1/24 (=
0.4167). I formatted my 10K times (which are around an hour) with a minimum
of 0.032 (= 46 minutes), and increments of 0.002 (= 3 minutes). The Y-axis
looks fine.

 

[oRm]

Thanks Fred. I'll give it a try asap.
Cheers!

-oRm-

 

[Jon Peltier]

To make this easier to enter in the axis scale dialog, enter the times
in time format into the min, max, and major unit boxes. 46 minutes is
0:46:00 while 3 minutes is 0:03:00. Excel converts these into their
decimal equivalents.

- Jon

 

[oRm]

Thank you!
This was easier and it works perfect!

-oRm-

 

[Jon Peltier]

Yes, I remember how happy I was the first time I tried entering
time-formatted numbers into the boxes, and Excel accepted them. One of
those undocumented features that I hope they don't fix in future versions.

- Jon

 

[oRm]

"...they dont fix..." !!!???
Why not? It should be some note about it somewhere...dont you think?

-oRm-

 

[Jon Peltier]

Sorry, I was being facetious. I haven't seen any documentation of this
anywhere. And there was an undocumented feature elsewhere in Excel that
I made use of in many of my solutions, and they "fixed" the feature so
it no longer works in XP or 2003. I guess that one they decided was a bug.

If they "fix" this data entry thing by describing it, I'd be happy. If
they "fix" it so it no longer works that way, I wouldn't.

- Jon

 

[oRm]

-oRm-

Sorry, I was being facetious. I haven't seen any documentation of this
anywhere. And there was an undocumented feature elsewhere in Excel that
I made use of in many of my solutions, and they "fixed" the feature so
it no longer works in XP or 2003. I guess that one they decided was a bug.

If they "fix" this data entry thing by describing it, I'd be happy. If
they "fix" it so it no longer works that way, I wouldn't.

- Jon