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

Hi Rad,

Try this,

oPoint.DataLabel.Position = xlLabelPositionAbove

Cheers
Andy

Radixa wrote:
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, Microsoft MVP - Excel
http://www.andypope.info