With ChartObjects(1).Chart.SeriesCollection(1).Points(2 )
.HasDataLabel = True
.DataLabel.Text = "year one results"
End With
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"den1s"
wrote in message
Hello,
is there away to add text to a series point? I have a graph and I would
like to add a text description of one of the points, i.e. "year one
results".
If possible I would like to be able to do this in Excel VBA, which
would enable some data analysis before labelling a point.
Any suggestions would be appreciated