"Callum" wrote in message
...
Kelly, thanks for the advice.

However, the x axis is a time scale in format hh:mm:ss.000 which I have
converted into ss (ranging from 0 sec - 0 sec (corresponding to 1:00).
When
I try to format the x-axis scale, the min is set to 0, and the max is
automatically set to 0.0008.

I expected the max to be set to 60, not 0.0008. I suspect that the
scaling
is not in the correct format (i.e. ss).

Your 60s, if in a cell formatted in time, will actually be stored as
0.000694444 which is 1/24/60, i.e. a minute as a fraction of a day, as Excel
stores times in days.
The 0.0008 tick mark is 1 minute 9.12 seconds.
If yu want to set the maximum of the axis to 0:01:00 (i.e. 60 seconds), you
can do that. Similarly, you can set the major unit on the axis to 0:0:10 if
you want to.

When you go back into "Format Axis" the numbers will appear as proportions
of a day, but you can use time formatting to set them if you wish.
--
David Biddulph