X Y Scatter With Point name on each point ?

[Guest]

I need to create a excel chart with three columns which are x coordinate, y
coordinate and country name. I need a scatter chart, with point name labeled
againt each point. e.g. In the below example, I need country name to identify
each point in the chart. Pl. help !

x y Cname
1 5 US
2 2 Canada
5 7 Brazil
6 2 UK

 

[Andy Pope]

Hi,

Create a xy-scatter on the first to columns of data and then use Rob Bovey's
free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

 

[Guest]

Thanks Much Andy, I found one of your ealier answer also, tried it out and
worked !!

Do you know if this is something microsoft is planning add as a inbuilt
feature ?

 

[Jon Peltier]

Well, people have requested it for a long time, and it still hasn't made it
into Excel 2007. You could hope it makes it into the next version, in around
2010.

- Jon