Thanks, June! That's exactly what I need. Unfortunately, when it comes to VBA I'm a total noob. I've been trying to figure out how to take this code and tweak it to fit my needs for the last several hours - but to no avail. Could you help me determine what fields I need to change here? (And where to put it afterwards? Like I said - I'm starting at level 0.) Thanks!
Let's say:
Report Name = FeverChartReport
Graph Name = FCR
Label = JobID
X Values = ValueX
Y Values = ValueY
Code:
Dim i As Integer, cnnMe As New ADODB.Connection, rstMe As New ADODB.Recordset
Set cnnMe = CurrentProject.Connection
rstMe.Open "qryAll", cnnMe, adOpenStatic, adLockReadOnly
rstMe.MoveFirst
With Me.grpMain.Object.SeriesCollection(1)
For i = 1 To .Points.Count
With .Points(i)
.ApplyDataLabels
With .DataLabel
.Text = rstMe("strEngineer").Value & "; " & rstMe("X").Value & "; " & rstMe("Y").Value
With .Font
.Name = "Arial"
.Size = 10
.Bold = False
.Color = vbBlue
End With
End With
End With
rstMe.MoveNext
Next i
End With
rstMe.Close
cnnMe.Close
Set rstMe = Nothing
Set cnnMe = Nothing