Data Labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
_______
 
Back
Top