View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean[_7_] Sean[_7_] is offline
external usenet poster
 
Posts: 20
Default Data Label Object Position not working

I have the following code in a spreadsheet:

ActiveChart.SeriesCollection(i).DataLabels.Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Position = xlLabelPositionAbove
.Orientation = xlDownward

I keep getting a run-time error '1004', application or
object defined error with the program reaches the line

.Position = xlLabelPositionAbove

but this seems to be the correct code. If I record a
macro, this is the code that is recorded, however it will
not run. I appreciate any help