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 Weigh
John 6 15
Bill 5 17
Steve 5.5 14

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