Formating x axis with data

  • Thread starter Thread starter adam1964
  • Start date Start date
A

adam1964

Hi:

I have Microsoft Excel 2002. I have 10 minutes worth of data (a
object's change in position in x and y) that I want to plot as
function of time. The time function, recorded with an accuracy of .01,
is recorded with the positional data. How do I graph the positional
and y data so that the x axis is the time data, and the delta x and
data are plotted lines on the graph?

Thanks.


Ada
 
Adam -

You need three columns of data. Put the time in column A, X (or delta X)
in column B, and Y (or delta Y) in column C. Select the data and create
an XY Scatter chart with the chart wizard. Do not create a Line chart.

- Jon
 
Hi:

Would you mind looking at my data? I tried the Scatter Chart but th
data does not conform to what I am looking for. X axis would have th
time data (1344.402 through 1747.003) and the delta x and delta y dat
points plotted as a function of their corresponding times.

Thanks.

Ada

Attachment filename: stv data.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42082
 
Sorry: My data set had a hidden column of data. I deleted the column an
now I have what I was looking for.

Sorry for wasting bandwidth.

Ada
 
Back
Top