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

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

--

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

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

Have a look at this add-in. I find it works very well.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address


"Bob Christensen 3" wrote in
message ...
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

Hi,

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

Cheers
Andy

Bob Christensen 3 wrote:
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

Thanks Andy, I did not notice the CTRL+V had failed me!
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

Bob Christensen 3 wrote:
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