How to positionne DataLabel on top of a point ?

[Radixa]

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

 

[Andy Pope]

Hi Rad,

Try this,

oPoint.DataLabel.Position = xlLabelPositionAbove

Cheers
Andy