How to positionne DataLabel on top of a point ?

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format only part of a DataLabel in Excel 2007/PowerPoint 2007 char 6
How To Modify One Point In A Graph... 3
Chart DataLabel Placement Error 2
Plot value at top of chart 1
add a chart in a Add-In 1
Unable to set the Values property of the Series class 1
I want to find the lowest point on the plotted line in a graph. 4
setting the gradientstops of a point in a macro 1

Top