Hi Barb,
It is probably me being dum, but I still can't get it to work. I've
installed Ron Bovey's XY Chart Labeler, and it reads on the web site that it
will 'The labeler will detect and apply the source range formatting
characteristics to the data labels as well as live-link the data label text
to the source range text.' But nothing additional seems to happen. I create a
X Y (scatter) chart based on the below the table and I've tried a bubble
chart on this exmaple table but to no avail do the TEAM # labels appear. If I
set the X axis range to MANAGER # B2:B11, Y axis range to CLIENTS # C2:C11
and the size range to REVENE D2:D11 the bubble chart looks create but I want
to put the TEAM # name next to the appropraite bubble but how do I make Ron
Bovey's XY Chart Labeler used the TEAM # range as the Label source. Do I need
to include the TEAM # column when I make the data source for the chart or do
I add the data later. The problem is that I don't see anything noticable that
indicates that the XY Chart Labeler is doing something, I can see the
atpvbaen.xla loaded so I presume it is installed correctly.

Hope you can help? Thanks in advance



TEAM # MANAGER # CLIENTS# REVENUE
TEAM 01 2 5 60
TEAM 02 6 10 120
TEAM 03 4 15 180
TEAM 04 5 6 72
TEAM 05 6 12 144
TEAM 06 8 18 216
TEAM 07 2 7 84
TEAM 08 4 14 168
TEAM 09 3 21 252
TEAM 10 1 8 96





I've done this using Ron Bovey's XY Chart Labeler

www.appspro.com

"Kevin McCartney" wrote in
message ...
Hi,

I have the following table exmaple, what I like to do is to plot the team
as where their values cross, e.g. for TEAM 01 where 5 and 60 cross on a
graph
having Revenue as the Y axis and Clients as the X axis.

COLUMN A COLUMN B COLUMN C
TEAMS CLIENTS REVENUE
TEAM 01 5 60
TEAM 02 10 120
TEAM 03 15 180
TEAM 04 6 72
TEAM 05 12 144
TEAM 06 18 216
TEAM 07 7 84
TEAM 08 14 168
TEAM 09 21 252
TEAM 10 8 96

Any guidence, much appriciated.

Hi Barb,

I'm being a nooop, the addin was not loaded, silly me..... doooh :-)

"Kevin McCartney" wrote:

Hi Barb,
It is probably me being dum, but I still can't get it to work. I've
installed Ron Bovey's XY Chart Labeler, and it reads on the web site that it
will 'The labeler will detect and apply the source range formatting
characteristics to the data labels as well as live-link the data label text
to the source range text.' But nothing additional seems to happen. I create a
X Y (scatter) chart based on the below the table and I've tried a bubble
chart on this exmaple table but to no avail do the TEAM # labels appear. If I
set the X axis range to MANAGER # B2:B11, Y axis range to CLIENTS # C2:C11
and the size range to REVENE D2:D11 the bubble chart looks create but I want
to put the TEAM # name next to the appropraite bubble but how do I make Ron
Bovey's XY Chart Labeler used the TEAM # range as the Label source. Do I need
to include the TEAM # column when I make the data source for the chart or do
I add the data later. The problem is that I don't see anything noticable that
indicates that the XY Chart Labeler is doing something, I can see the
atpvbaen.xla loaded so I presume it is installed correctly.

Hope you can help? Thanks in advance



TEAM # MANAGER # CLIENTS# REVENUE
TEAM 01 2 5 60
TEAM 02 6 10 120
TEAM 03 4 15 180
TEAM 04 5 6 72
TEAM 05 6 12 144
TEAM 06 8 18 216
TEAM 07 2 7 84
TEAM 08 4 14 168
TEAM 09 3 21 252
TEAM 10 1 8 96





I've done this using Ron Bovey's XY Chart Labeler

www.appspro.com

"Kevin McCartney" wrote in
message ...
Hi,

I have the following table exmaple, what I like to do is to plot the team
as where their values cross, e.g. for TEAM 01 where 5 and 60 cross on a
graph
having Revenue as the Y axis and Clients as the X axis.

COLUMN A COLUMN B COLUMN C
TEAMS CLIENTS REVENUE
TEAM 01 5 60
TEAM 02 10 120
TEAM 03 15 180
TEAM 04 6 72
TEAM 05 12 144
TEAM 06 18 216
TEAM 07 7 84
TEAM 08 14 168
TEAM 09 21 252
TEAM 10 8 96

Any guidence, much appriciated.

DOH! You're not alone. I've done things like that before myself.

Did it work the way you wanted?

"Kevin McCartney" wrote in
message ...
Hi Barb,

I'm being a nooop, the addin was not loaded, silly me..... doooh :-)

"Kevin McCartney" wrote:

Hi Barb,
It is probably me being dum, but I still can't get it to work. I've
installed Ron Bovey's XY Chart Labeler, and it reads on the web site
that it
will 'The labeler will detect and apply the source range formatting
characteristics to the data labels as well as live-link the data label
text
to the source range text.' But nothing additional seems to happen. I
create a
X Y (scatter) chart based on the below the table and I've tried a bubble
chart on this exmaple table but to no avail do the TEAM # labels appear.
If I
set the X axis range to MANAGER # B2:B11, Y axis range to CLIENTS #
C2:C11
and the size range to REVENE D2:D11 the bubble chart looks create but I
want
to put the TEAM # name next to the appropraite bubble but how do I make
Ron
Bovey's XY Chart Labeler used the TEAM # range as the Label source. Do I
need
to include the TEAM # column when I make the data source for the chart
or do
I add the data later. The problem is that I don't see anything noticable
that
indicates that the XY Chart Labeler is doing something, I can see the
atpvbaen.xla loaded so I presume it is installed correctly.

Hope you can help? Thanks in advance



TEAM # MANAGER # CLIENTS# REVENUE
TEAM 01 2 5 60
TEAM 02 6 10 120
TEAM 03 4 15 180
TEAM 04 5 6 72
TEAM 05 6 12 144
TEAM 06 8 18 216
TEAM 07 2 7 84
TEAM 08 4 14 168
TEAM 09 3 21 252
TEAM 10 1 8 96





I've done this using Ron Bovey's XY Chart Labeler

www.appspro.com

"Kevin McCartney" wrote in
message ...
Hi,

I have the following table exmaple, what I like to do is to plot the
team
as where their values cross, e.g. for TEAM 01 where 5 and 60 cross on
a
graph
having Revenue as the Y axis and Clients as the X axis.

COLUMN A COLUMN B COLUMN C
TEAMS CLIENTS REVENUE
TEAM 01 5 60
TEAM 02 10 120
TEAM 03 15 180
TEAM 04 6 72
TEAM 05 12 144
TEAM 06 18 216
TEAM 07 7 84
TEAM 08 14 168
TEAM 09 21 252
TEAM 10 8 96

Any guidence, much appriciated.