Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XY Plot with time (Excel)

Status
Not open for further replies.

ceecld

Technical User
Jul 17, 2003
68
US
Hi

Im looking to plot an XY series which also has a corresponding time stamp e.g.

time (s) X Y
1.0 5 6
1.1 6 9
2.5 8 1
....

it's easy enough to get the XY plot, however im having trouble trying to get the time stamp associated with the specific XY coordinates. The data I have is approx 30,000 rows and to multiple decimal places so it's difficult to manually find the time just by taking the coords. The idea is that at a few select points i would display the time stamp for the corresponding XY coords.

is there anyway i can assocaite this third column (time) with the XY coords?

Thanks in advance

Chris

p.s. ive managed to do this in Openoffice, however our IT dept wont let me use it on my works computer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top