In the next column, construct the text of the desired labels. An example
formula would be

=A2&CHAR(10)&B2&CHAR(10)&C2

where CHAR(10) is a carriage return. Use these constructed labels as the
data labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"M John" wrote in message
...
John,
I have created the macro (which works beautifully) and want to know if the
following is possible:

For an x-y chart with the following points:

x y
A 1 5
B 2 10
C 3 12
D 4 30

Is it possible to get the data label for each point in the graph to read:
(for C, as an example)

C
3
12

Many thanks,
M John







"John Mansfield" wrote:

kbpratt,

In addition to Rob's XY Chart Labeler addin, you can also use the
following
macro:

Sub AddLabels()
Dim RngLabels As Range
Dim Ser As Series
Dim i As Long
If TypeName(Selection) = "Series" Then
Set Ser = Selection
Set RngLabels = Application.InputBox(prompt:="Select the label
range:", Type:=8)
Ser.HasDataLabels = True
For i = 1 To Ser.Points.Count
Ser.Points(i).DataLabel.Text = RngLabels(i)
Next i
Else
MsgBox "Select a series in a chart."
End If
End Sub

In the dialog box, add the reference to the data source like
"Sheet1!A1:A5".

----
Regards,
John Mansfield
http://www.pdbook.com


"kbpratt" wrote:

Hello-

Is there any way to label individual points in an XY scatter with data
from
ajdacent cells? For exampl, I have 3 columns with a name, an x value
and a y
value. I want to plot points with the XY data and label each point
with the
names from the first column. Seems simple but I can't figure it out