Scattered Graph

**Shijesh Kumar** · 02-16-2009, 04:33 PM

Hi,

I have three colums of data.
First represet company , second colum represent data1 ( x- axis) and third represet data2 ( y-axis).

I want to plot x-y graph with the company name

Eg.
McDon | 10 | 20

In the above case i want to show a round circle or dot which will be 10 right on x axis and 20 up on y axis and near the dot i want to show McDon as company name.

See that attachement... Graph is coming well.. but i am not able to add the company name to the dots.. or pot of x and y intersection

**Shijesh Kumar** · 02-17-2009, 04:25 AM

Solved myself...

**Andy Pope** · 02-17-2009, 04:43 AM

Care to share your solution?

**onlinev** · 02-17-2009, 04:44 AM

Hi,
This is onlinev from canada. I am a newbie of this site and in
my opinion this is a good site to visit on for the visitors.
It has a lot for the visitors.
onlinev
Finance Loans

**Shijesh Kumar** · 02-17-2009, 05:51 AM

Hi Andy,

Here the vba which i tried to make.

I'm not very good at chart .. so this is not a very good one to work with but it served my purpose

Please Login or Register  to view this content.

**Andy Pope** · 02-17-2009, 06:08 AM

Thanks for posting that.

You may find this free addin useful for linking data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

**Shijesh Kumar** · 02-17-2009, 06:12 AM

Thanks Andy,

I have that link...
But my office system does not allow us to download any exe or any executable files from internet...

Thats why i have to create a inefficient macro to serve my need.