Scaling x-axis with time

[Guest]

Can anyone help me with a problem I am having?

I have a spreadsheet showing 2000 data points plotted against time, sounds
simple

However, the number of data points corresponding to 1 second of 'footage'
varies. E.g. in a 1 second interval, I sometimes get 5 readings being
recorded (0.2, 0.4, 0.6, 0.8, 1.0 sec), and in the next 1 second interval, I
get 10 readings being recorded (0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9,
1.0 sec).

When it comes to graphing the data, the time scale along the X-axis is not
'to scale', I am looking to have the tick mark labels to be displayed in 1
second increments (instead of say every 5 data points).

Can anyone help me?

Thank you so much in advance.

 

[Kelly O'Day]

Callum:

Use an XY chart, not a line chart.

Once you have XY chart, change X axis format to meet your needs.

Post back with specific questions and I'll be glad to walk you through
process.

...Kelly

(e-mail address removed)

 

[Guest]

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).

Any tips?

Thanks in advance.

Callum

 

[David Biddulph]

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.