Scatter Charts

[Guest]

I am trying to do a simple scatter chart where one column of numbers
represents the series for the X-axis and another represents the y-axis and
the plots are the combined points.
I would like to assign a label to each point to make them easily
identifiable as to what each point represents.
Example:
Ref X-Axis Y-Axis
1 14.5 11.0 would like this plot to have a label of 1
2 15.0 9.5 would like this plot to have the label 2
3 26.25 20.5 would like this plot to have the label 3
and so on.

 

[Guest]

To add the independent data labels . . .

You can use Rob Bovey's XY Chart Labeler add-in located at:

http://www.appspro.com/Utilities/ChartLabeler.htm

or John Walkenbach's Chart Tools add-in located at:

http://j-walk.com/ss/excel/files/charttools.htm

or you can 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".
Last, you can use the process described here:

http://www.pdbook.com/index.php/excel/auto_update_xy_chart_with_independent_data_labels/