View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Adding a custom label to a series point

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