![]() |
Position DataLables on a pivot pie chart realative to their Points
I wrote some code to reset my formatting on my pivot pie chart when I
manipulate the pivot drop down menus. Part of my formatting is to position the Data labels out from the pie chart a bit so the Leader Lines are visible. 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 My problem is when I use my pivot drop downs, some selections have such different values that the data labels pieces of the pie (Points) are so far away the leader lines disappear (probably because the path they would have to take is too complex). So, instead of setting the position of my DataLables as a static place on the chart, I want to set it to a location relative to the location of its piece of the pie (Points). Any suggestions? |
All times are GMT +1. The time now is 12:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com