Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Raj Raj is offline
external usenet poster
 
Posts: 130
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.charting
Raj Raj is offline
external usenet poster
 
Posts: 130
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data point labels in a scatter diagram sdstephens Charts and Charting in Excel 12 March 6th 06 02:04 AM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Data point labels in XY scatter chart TonyGB007 Charts and Charting in Excel 1 December 9th 05 09:13 AM
plotting 2 variables as scatter and naming each point Jane Charts and Charting in Excel 1 June 22nd 05 03:55 PM
On a scatter chart show two point have same value Maz Page Charts and Charting in Excel 1 December 16th 04 01:00 PM


All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"