MS Excel graphing help? Please?

[TUS 373]

Can anyone answer this (probably very simple) question for me please?

I am trying to produce a scattergraph from a table of data. For simplicity, lets say I have 3 columns, A, B & C.

A contains names to values e.g. car names.

Columns B & C contain my X and Y co-ordinates, respectiviely. I can produce the scatter graph using these co-ordinates, no problem at all.

Problem is, I want the co-ordinates to pick up and display their corresponding names from column A. Whenever I try I end up with hundreds of them, and all in the wrong place.

Can anyone explaing how to do this and keep the data linked together properly. The s@dding paperclip Office Assistant is bloody useless in explaining it to me!

Thanks in anticipation,
Bryan

[TUS 373]

Anyone? I'm stuck!
Thanks

[TUS 373]

Thanks Guys, I'm still struggling on this. There are 95 plot points - that's alot to label manually. I'll keep trying.

As you rightfully say, if co-ordinate 2,3 is called A, then a want 'A' to appear next to the dot for co-ordinate 2,3 to identify it. Just can't make it work though and its a really frustrating waste of time that I don't have! Aaaarrrggggggggghhhh!!!!!!

[TUS 373]

Thanks for your help Tony.

So it looks like there is no quick and automatic way. I'm surprised really as I though that Excel 'does everything'. Obviously not!

I see how I can add the labels in manually now so that is a great help. Thankyou for your attention and reducing my stress levels dramatically (well they will be lower when I have finished doing it anyway!).

[TUS 373]

Thanks Tony, that's really cool. I have labelled the 95 co-ordinates manually, took me a while to do it yesterday. I have downloaded the extra software from your link for future use - as now doubt, I will be needing it again in the future!

How on earth did you find that site, its really useful.

Thanks for your help,
Merry Xmas!
Bryan