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

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

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