Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 11:01 AM
Kevin McCartney
 
Posts: n/a
Default Barb Reinhardt: HOW TO: Plot a Team Name ....

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 D211 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.



  #2   Report Post  
Old December 1st 04, 11:51 AM
Kevin McCartney
 
Posts: n/a
Default

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 D211 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.


  #3   Report Post  
Old December 1st 04, 01:28 PM
Barb Reinhardt
 
Posts: n/a
Default

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 news
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 D211 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO: Plot a Team Name on a chart based on two values Kevin McCartney Charts and Charting in Excel 1 November 30th 04 05:26 PM
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 2 November 29th 04 08:22 PM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017