MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Chart - LabelPosition

  Asked By: Irma    Date: Mar 06    Category: MS Office    Views: 2458

To all experienced VBA programmer

I can not think of anything to solve my problem and would need your

Chart with two series
x: 1 2 3 4 5 6
y: 5 1 6 3 8 9

Chart DataLabels must be positioned according to the date value, i.e
high value xlLabelPostionAbove, low value xlLablePositionBelow.

Ex: x=1, y=5. y (label) value should be above, x below
Ex: x=5, y=8. x (label) value should be above, y below

Exel Contrains
Looks like Excel can only position the xlLabelPosition by
SeriesCollection, rather than individual (label) value.

Recorded Macro

With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Position = xlLabelPositionAbove
.Orientation = xlHorizontal
End With

Would appreciate of you guys can think of somthing and share.



1 Answer Found

Answer #1    Answered By: Minal Nayak     Answered On: Mar 06

Check out these two free add-ins which give you more control & flexibility in
labeling charts:

Didn't find what you were looking for? Find more on Chart - LabelPosition Or get search suggestion and latest updates.