scatter plot data point labelling question

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" <BobChristensen3@discussions.microsoft.com> wrote in
message news:EC6528CD-008F-4A6D-921A-E4FAE459D9C7@microsoft.com...
> 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" <BobChristensen3@discussions.microsoft.com> wrote in
message news:EC6528CD-008F-4A6D-921A-E4FAE459D9C7@microsoft.com...
> 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" <andy@andypope.info> wrote in message
news:usj4OXQKIHA.4272@TK2MSFTNGP05.phx.gbl...
> 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