ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Label Object Position not working (https://www.excelbanter.com/excel-programming/306831-data-label-object-position-not-working.html)

Sean[_7_]

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


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com