Peter -
Use one of these third party Excel add-ins to assign another column as data
labels to a series in a chart. Both are free, and easy to install and use:
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com/ss
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Peter R Knight" <(E-Mail Removed)> wrote in message
news:5ECECA81-BF2E-4D50-82F8-(E-Mail Removed)...
> hi,
> is it possible to lable data points on a scatter chart not with the x or y
> values but with a thrid column from the spreadsheet. e.g. the following
> example, time is plotted on the x axis and value on the y and I'd like the
> data points labeled a,b,c ...
>
> label time value
> a 1 1
> b 2 4
> c 3 9
> d 4 16
> e 5 25
> f 6 36
> g 7 49
> h 8 64
> i 9 81
> j 10 100
> k 11 121
> l 12 144
> m 13 169
>