software

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.

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

quot;Callumquot; gt; wrote in message
...
gt; Can anyone help me with a problem I am having?
gt;
gt; I have a spreadsheet showing 2000 data points plotted against time, sounds
gt; simple
gt;
gt; However, the number of data points corresponding to 1 second of 'footage'
gt; varies. E.g. in a 1 second interval, I sometimes get 5 readings being
gt; recorded (0.2, 0.4, 0.6, 0.8, 1.0 sec), and in the next 1 second interval,
gt; I
gt; get 10 readings being recorded (0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8,
gt; 0.9,
gt; 1.0 sec).
gt;
gt; When it comes to graphing the data, the time scale along the X-axis is not
gt; 'to scale', I am looking to have the tick mark labels to be displayed in 1
gt; second increments (instead of say every 5 data points).
gt;
gt; Can anyone help me?
gt;
gt; Thank you so much in advance.
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

quot;Kelly O'Dayquot; wrote:

gt; Callum:
gt;
gt; Use an XY chart, not a line chart.
gt;
gt; Once you have XY chart, change X axis format to meet your needs.
gt;
gt; Post back with specific questions and I'll be glad to walk you through
gt; process.
gt;
gt; ...Kelly
gt;
gt;
gt;
gt;
gt; quot;Callumquot; gt; wrote in message
gt; ...
gt; gt; Can anyone help me with a problem I am having?
gt; gt;
gt; gt; I have a spreadsheet showing 2000 data points plotted against time, sounds
gt; gt; simple
gt; gt;
gt; gt; However, the number of data points corresponding to 1 second of 'footage'
gt; gt; varies. E.g. in a 1 second interval, I sometimes get 5 readings being
gt; gt; recorded (0.2, 0.4, 0.6, 0.8, 1.0 sec), and in the next 1 second interval,
gt; gt; I
gt; gt; get 10 readings being recorded (0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8,
gt; gt; 0.9,
gt; gt; 1.0 sec).
gt; gt;
gt; gt; When it comes to graphing the data, the time scale along the X-axis is not
gt; gt; 'to scale', I am looking to have the tick mark labels to be displayed in 1
gt; gt; second increments (instead of say every 5 data points).
gt; gt;
gt; gt; Can anyone help me?
gt; gt;
gt; gt; Thank you so much in advance.
gt;
gt;
gt;

quot;Callumquot; gt; wrote in message
...
gt; Kelly, thanks for the advice.
gt;
gt; However, the x axis is a time scale in format hh:mm:ss.000 which I have
gt; converted into ss (ranging from 0 sec - 0 sec (corresponding to 1:00).
gt; When
gt; I try to format the x-axis scale, the min is set to 0, and the max is
gt; automatically set to 0.0008.
gt;
gt; I expected the max to be set to 60, not 0.0008. I suspect that the
gt; scaling
gt; 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 quot;Format Axisquot; the numbers will appear as proportions
of a day, but you can use time formatting to set them if you wish.
--
David Biddulph