Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GRAPH - DataLabel.Text - How to assigne a specific data ?

Status
Not open for further replies.

accessuserit

Programmer
Nov 10, 2001
29
IT
I need to show a text containeined in a specific field in my Scatter Chart type, around the single point.

I have founded a function very similar, but incomplete.
the function is belove:
-----------------------------------
Private Sub cmdAddLabels_Click()
With Mychart.SeriesCollection(1).Points(2)
.HasDataLabel = True
.DataLabel.Text = "MyText"
.DataLabel.Font.ColorIndex = 0
End With
End Sub
-----------------------------------------
This function, show on side of point the text "MyText"

Now, i need to replace by a function, the value "MyText" with my field [company_name] on row 1 (record1)

Help me please

Very Very Thanks
Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top