Oh, I see. That does make things more interesting . . .

No, I don't think there's a way that you can make Excel pull the names into
the labels, but what you can do is use that Data Labels tab to put the labels
in, then manually type the information you actually want into each one.
Excel will let you type over whatever it automatically puts into that label.
It's still not as fast and easy as having Excel generate name labels for you,
but at least it's faster than manually creating a bunch of text boxes and
getting them aligned properly.

Steph

"Dave Stanley" wrote:

What I really need to do is plot x and y in a scatter graph but then assign
the names of those who attained score1 and score2 to the points drawn, so
each datalabel is the name of the scorer. Going through the options allows
me to call the x value or the y value but not the name.
Any ideas?
Thanks

Dave
"Dave Stanley" wrote in message
.. .
Hi
If I plot a graph in excel with the following data

Name Score1 Score2
fred 12 23
john 22 22
pete 38 33
erica 33 33
jo 33 22

I make a scatter graph and have score one as one axis and score two as the
second axis. This produces little dots on the graph to represent where
these
are. Is there a way now to add Name to these points, for example 12,23 on
the graph would have the Name Fred against it, 38,33 would have the name
Pete etc.

I can do this manually by placing a small text box near each, but surely
there is a way to do this automatically.

Please tell me there is

Dave