scatter plot data point labelling question

[Guest]

Hi,

I have three columns of data: watershed name, acres of original old growth
and, % loss of old growth acres.

I created a scatter plot that displays the watershed points with the number
of acres of original old growth for the Y axis and the % loss for the x axis.
Now I would like to use the third column, watershed name, to label these
points. I cannot see how to do this and would greatly appreciate any help you
have to offer. I exported the plot to a .pdf and labeled a few in photoshop
to give you an idea of what i mean: http://www.seawead.org/scatter.jpg

Thanks,

Bob

 

[Andy Pope]

From a previous reply.

There is no built in way to link data labels to cells. But with the aid of
this free addin you can do it.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

 

[Guest]

I should have mentioned that I am using excel 2007. If the best way to do
this is to install an add-in I would appreciate knowing which one is best
suited for excel 2007.

thanks again,

bob

 

[Bernard Liengme]

Have a look at this add-in. I find it works very well.
best wishes

 

[Andy Pope]

Hi,

I assume Bernard was referring to this addin.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

 

[Bernard Liengme]

Thanks Andy, I did not notice the CTRL+V had failed me!
best wishes