Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 them to a location relative to the location of their pieces of the pie (Points). Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart position changes | Excel Discussion (Misc queries) | |||
Pivot Table - Not able to add field in the position I want | Excel Discussion (Misc queries) | |||
How to set the chart position exactly? | Charts and Charting in Excel | |||
Chart league position | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |