I create scatter plots using two values (salary, year of hire) that relate to
particular employees. I want to label each point with the contents of a
third cell (initials of the individual related to the point). I have figured
out how to change the label one point at a time, but I'd like to simply
relate the contents of a third column to the markers defined by two other
columns. Help!!
--
ahannigan

The free Excel add-in "Chart Data Labels" will do that.
It can also include the cell formatting in the data label and
link the cell contents to the label. Download from ...
http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"ahannigan"

wrote in message
I create scatter plots using two values (salary, year of hire) that relate to
particular employees. I want to label each point with the contents of a
third cell (initials of the individual related to the point). I have figured
out how to change the label one point at a time, but I'd like to simply
relate the contents of a third column to the markers defined by two other
columns. Help!!
--
ahannigan

This looks terrific! Do you have any idea where I can find the tools menu
(to get to Add-Ins) in Excel 2007?


--
ahannigan


"Jim Cone" wrote:

The free Excel add-in "Chart Data Labels" will do that.
It can also include the cell formatting in the data label and
link the cell contents to the label. Download from ...
http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"ahannigan"

wrote in message
I create scatter plots using two values (salary, year of hire) that relate to
particular employees. I want to label each point with the contents of a
third cell (initials of the individual related to the point). I have figured
out how to change the label one point at a time, but I'd like to simply
relate the contents of a third column to the markers defined by two other
columns. Help!!
--
ahannigan

Ha, they took that out. The old two-click process to get to the add-ins
dialog now takes at least four or five clicks. Let's see if I can remember
(Office 2007 is on another computer).

Office menu
Excel Options button
Add-ins item in the left column
Manage: Excel add-ins at the bottom
Go button

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ahannigan" wrote in message
...
This looks terrific! Do you have any idea where I can find the tools menu
(to get to Add-Ins) in Excel 2007?


--
ahannigan


"Jim Cone" wrote:

The free Excel add-in "Chart Data Labels" will do that.
It can also include the cell formatting in the data label and
link the cell contents to the label. Download from ...
http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"ahannigan"

wrote in message
I create scatter plots using two values (salary, year of hire) that
relate to
particular employees. I want to label each point with the contents of a
third cell (initials of the individual related to the point). I have
figured
out how to change the label one point at a time, but I'd like to simply
relate the contents of a third column to the markers defined by two other
columns. Help!!
--
ahannigan

The program will not install on XL2007 as it adds items to a "menu bar"
and there is no menu bar in XL2007.
The program code will have to be modified. That will be difficult for me,
as MS changed the code language required to work with their new Ribbon.
It appears to me as if they are trying to force a complete break between
previous versions and XL2007.
--
Jim Cone
San Francisco, USA



wrote in message
This looks terrific! Do you have any idea where I can find the tools menu
(to get to Add-Ins) in Excel 2007?
--
ahannigan


"Jim Cone" wrote:
The free Excel add-in "Chart Data Labels" will do that.
It can also include the cell formatting in the data label and
link the cell contents to the label. Download from ...
http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"ahannigan"

wrote in message
I create scatter plots using two values (salary, year of hire) that relate to
particular employees. I want to label each point with the contents of a
third cell (initials of the individual related to the point). I have figured
out how to change the label one point at a time, but I'd like to simply
relate the contents of a third column to the markers defined by two other
columns. Help!!
--
ahannigan

Jim,

If you are using commandbars to implement the menuing structure, 2007 will
stick all of your work under the Add-Ins tab. So, it is *possible* the
add-in will continue to work under 2007. Do note that you may still run
afoul of other changes MS made to its Office software.

--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"Jim Cone" wrote:

The program will not install on XL2007 as it adds items to a "menu bar"
and there is no menu bar in XL2007.
The program code will have to be modified. That will be difficult for me,
as MS changed the code language required to work with their new Ribbon.
It appears to me as if they are trying to force a complete break between
previous versions and XL2007.
--
Jim Cone
San Francisco, USA

{snip}

Tushar,
Thanks for your encouraging response.
(it would also be nice to hear back from "ahannigan" about his experience)

Except for your response,I have not seen/heard of anyone reporting their
results from attempting to use "prior" add-ins in xl07.
Other than the rows/columns count issue (which I won't have a problem with),
are there other major code issues?
Regards,
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




"Tushar Mehta"

wrote in message
Jim,
If you are using commandbars to implement the menuing structure, 2007 will
stick all of your work under the Add-Ins tab. So, it is *possible* the
add-in will continue to work under 2007. Do note that you may still run
afoul of other changes MS made to its Office software.
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach



"Jim Cone" wrote:
The program will not install on XL2007 as it adds items to a "menu bar"
and there is no menu bar in XL2007.
The program code will have to be modified. That will be difficult for me,
as MS changed the code language required to work with their new Ribbon.
It appears to me as if they are trying to force a complete break between
previous versions and XL2007.
--
Jim Cone
San Francisco, USA

{snip}