Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Chart - LabelPosition

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

To all experienced VBA programmer

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

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

Problem:
-----------
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

ActiveChart.SeriesCollection(1).DataLabels.Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Position = xlLabelPositionAbove
.Orientation = xlHorizontal
End With


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

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.




Tagged: