Hi Mike,

Not sure of what you need here, but it sounds to me like you should
be plotting each data series against their equivalent seconds and not
against each other.
So you would have two series in the same chart each plotted as
Y-axis = data
X-axis = seconds
(or vice versa)

HTH
Martin




"Mike" wrote in message
...
I have two columns of data, each having a different number of cells. I
want
to plot them against each other to create an xy scatter chart. Is there a
way to redistribute the data in the column with the least amount of cells
to
match the column with the most cells? The data I want on the x axis was
collected during an experiment once per second and the data on the y axis
was
collected 4-5 per second. Both were started and stopped at the same point
in
the test. I just need to evenly distribute the data that was collected
once
per second over the total number of cells of data that were collected 4-5
times per second.
Thanks for your time