ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Position DataLables on a pivot pie chart realative to their Points (https://www.excelbanter.com/excel-programming/396574-position-datalables-pivot-pie-chart-realative-their-points.html)

Aaron

Position DataLables on a pivot pie chart realative to their Points
 
I use this code to name the location of the data labels:

ActiveChart.SeriesCollection(1).Points(1).DataLabe l.Select
Selection.Left = 641
Selection.Top = 134

But static locations are not what I am looking for. How can I set a data
lable to a location relative to the location of its
piece of the pie (Points)?




All times are GMT +1. The time now is 01:07 PM.

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