Question: How to use time as an axis label

[Zerex71]

Greetings,

One thing that has bothered me for a while is my inability to use times
as an axis label. Typically I have to convert everything to seconds or
something whether for use on the X- or Y-axis. I want to know - there
must be a way - how I can have a column or row of times in the format
hh:mm:ss and use those directly as label in a chart. Any help would be
greatly appreciated!

Mike

[Bryan Hessey]

I am using Excel 2003, and to use Time, or Date as the X (Category) axis works fine, so long as time is entered as 4:20:35 etc

What error do you get?

--

Greetings,

One thing that has bothered me for a while is my inability to use times
as an axis label. Typically I have to convert everything to seconds or
something whether for use on the X- or Y-axis. I want to know - there
must be a way - how I can have a column or row of times in the format
hh:mm:ss and use those directly as label in a chart. Any help would be
greatly appreciated!

Mike