XY Plot for time (Excel)

[ceecld]

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.

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

Thanks in advance

Chris

 

[GlennUK]

So, what are you after exactly? Did you want labels on each of your points containing the time?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[ceecld]

at selected points on the curve i would be looking to have the time stamp shown otherwise it would be too cluttered.

I've actually managed to do this in openoffice, however it our work computers don't have OO and I don't think our IT dept would allow me to install it on a company laptop.

 

[SkipVought]

Hi,

This can be done with VBA. There are chart events, and a method called GetChartElement. This method returns the point offset for the selected source data series range, with which you could display the corresponding time stamp value.

If you wish to try this, please repost in Forum707 for VBA help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

How about splitting your series as below and then choosing only one of the series for lables? You can split them whichever way you like (that is, one value in B, two values in D etc)
[blue][tt] x y x1 y1
Label 01 6.4 2.4
Label 02 2.7 5.6
Label 03 1.5 0.6
Label 04 2.6 5.0
Label 05 1.4 2.6
Label 06 3.9 2.0
Label 07 8.9 1.9
Label 08 8.9 7.2
Label 09 0.6 6.0
Label 10 2.2 5.7
Label 11 9.8 6.2
Label 12 9.4 7.6
Label 13 0.4 8.1
Label 14 8.4 9.8
Label 15 4.2 9.2
Label 16 0.4 0.8
Label 17 9.5 4.4
Label 18 2.3 6.9
Label 19 7.7 6.5
Label 20 6.0 3.8
[/tt][/blue]

I don't particularly care about apathy

 

[ceecld]

xlhelp..

this was my idea that i would have the main XY plot then a subset of corrds which i would then overlay to give the time at specitic points.. it's getting the label onto the x,y graph that im having the problem with.

 

[xlhelp]

BTW, I did try it. With a little bit of imaginative formatting you can make the chart look like you only have two series.

I don't particularly care about apathy

 

[lionelhill]

If you do a lot of plotting, seriously, consider a 3rd party graph program. We use Sigmaplot, but I haven't tried others. It interacts with Excel very well, and once you've got over the learning curve, it's so much more flexible, you'll never regret it.

Excel's fine for a quick plot for a presentation or to stick in a report, but if you have a particular format in mind, it rapidly becomes a nightmare.

 

[GlennUK]

There is a free utility for labelling X-Y charts, from Rob Bovey ...

http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers, Glenn.

Beauty is in the eye of the beerholder.