Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code to move DataLables to top of Chart | Charts and Charting in Excel | |||
Position DataLables on a pivot pie chart realative to their Points | Charts and Charting in Excel | |||
Getting cell position in points | Excel Programming | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
Determining chart points at mouse position | Excel Programming |