Labeling each data point in scatter chart
 

Is there some way to create a scatter chart automatically with each of the
points labelled from the following data? I have over 100 data points each
with a unique label and doing each series x value, y value and name
individually takes a lot of time. I could transpose the data if it helps.

label x y
aaa 150 0.001
bbb 200 0.0005
ccc 35 0.03
ddd 15 0.1

Thanks

Labeling each data point in scatter chart
 

Use one of these free utilities. They integrate very smoothly into Excel.

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Kris" wrote in message
...
Is there some way to create a scatter chart automatically with each of the
points labelled from the following data? I have over 100 data points each
with a unique label and doing each series x value, y value and name
individually takes a lot of time. I could transpose the data if it helps.

label x y
aaa 150 0.001
bbb 200 0.0005
ccc 35 0.03
ddd 15 0.1

Thanks

Labeling each data point in scatter chart
 

Thanks Jon, XY Chart Labeler looks like it will do the trick.

"Jon Peltier" wrote:

Use one of these free utilities. They integrate very smoothly into Excel.

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Kris" wrote in message
...
Is there some way to create a scatter chart automatically with each of the
points labelled from the following data? I have over 100 data points each
with a unique label and doing each series x value, y value and name
individually takes a lot of time. I could transpose the data if it helps.

label x y
aaa 150 0.001
bbb 200 0.0005
ccc 35 0.03
ddd 15 0.1

Thanks