View Single Post
  #1   Report Post  
Radixa
 
Posts: n/a
Default How to positionne DataLabel on top of a point ?

Hello all,

I can't position correctly a datalabel on top of one point of a serie on the
graph: it appears always on the right of the point.

Here is the code:

Set oPoint = ActiveChart.SeriesCollection(1).Points(1)
oPoint.ApplyDataLabels Type:=xlShowValue
oPoint.DataLabel.VerticalAlignment = xlVAlignTop
oPoint.DataLabel.HorizontalAlignment = xlHAlignCenter
oPoint.DataLabel.Text = True
oPoint.DataLabel.Text = "Text to put on top"

Any help would be appreciated ...

Rad