Data Labels

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
 
J

Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top