Data labels in scatter charts

I cannot figure out how to automatically have the data points in a scatter plot chart each be individually labeled. For example (a simple example to show my problem), if I want to plot the following data:

Name Height Weight
John 6 150
Bill 5 170
Steve 5.5 140

I want a scatter plot of height vs. weight, with each data point labeled with the person's name. I understand I can do this by having each data point (person) entered as a separate series and then labeling with "Series Name" in the Data Lables tab of the Chart Wizard. However, I have to do this for thousands of data points over dozens of charts and simply can't do this manually. The Data Labels options don't have the "Automatic Text" option that Excel Help says it should. Furthermore, I have tried to record a Macro to solve this problem, yet Visual Basic simply doesn't recognize anything having to do with Data Labels (the entries I put in the Data Labels tab of the Chart Wizard didn't even record in VB). Please help as this is very important to my assignment.

Thank you in advance for your help,
Joshua

Hi
have a look at the following add-ins which will do this for you as
Excel does not support this automatically
http://j-walk.com/ss/excel/files/charttools.htm
http://www.appspro.com/utilities/Labeler.asp


--
Regards
Frank Kabel
Frankfurt, Germany


Joshua wrote:
I cannot figure out how to automatically have the data points in a
scatter plot chart each be individually labeled. For example (a
simple example to show my problem), if I want to plot the following
data:

Name Height Weight
John 6 150
Bill 5 170
Steve 5.5 140

I want a scatter plot of height vs. weight, with each data point
labeled with the person's name. I understand I can do this by having
each data point (person) entered as a separate series and then
labeling with "Series Name" in the Data Lables tab of the Chart
Wizard. However, I have to do this for thousands of data points over
dozens of charts and simply can't do this manually. The Data Labels
options don't have the "Automatic Text" option that Excel Help says
it should. Furthermore, I have tried to record a Macro to solve this
problem, yet Visual Basic simply doesn't recognize anything having to
do with Data Labels (the entries I put in the Data Labels tab of the
Chart Wizard didn't even record in VB). Please help as this is very
important to my assignment.

Thank you in advance for your help,
Joshua