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.

Use an XY chart, not a Line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
PeltierTech.com
_______quot;Callumquot; gt; wrote in message
news
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.