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!

find the presence of data in chart - need help

Status
Not open for further replies.

accessuserit

Programmer
Nov 10, 2001
29
IT
If in my chart i have two value(row of data) the script work correctly, else i receive a error msg.
This is the script:
_____________________________________________________
Private Sub cmdAddLabels_Click()
With Mychart.SeriesCollection(1).Points(1)
.HasDataLabel = True
.DataLabel.Text = ("A")
End With
With Mychart.SeriesCollection(1).Points(2)
.HasDataLabel = True
.DataLabel.Text = ("B")
End With
End Sub
____________________________________________________

Help me to bypass this error!
Thanks
Paul
 
insert into after the
Private Sub cmdAddLabels_Click()

line an

on error resume next

statement
;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top