X Y Scatter With Point name on each point ?
 

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

X Y Scatter With Point name on each point ?
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Raj" wrote in message
...
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

X Y Scatter With Point name on each point ?
 

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 ?

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Raj" wrote in message
...
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

X Y Scatter With Point name on each point ?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Raj" wrote in message
...
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 ?

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Raj" wrote in message
...
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