G
Guest
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
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