Formating x axis with data

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
 
J

Jon Peltier

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
 
A

adam1964

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
 
A

adam1964

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Scatter chart with categories on x-Axis 2
Odd chart type needed 1
Position of X axis labels 4
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Scatterpoot not using X values properly -- using relative ranking 3
How do I extend the X-axis in Excel2007 3

Top