Works like a charm. Many thanks.

M John

"Jon Peltier" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>