Display all labels outside of pie chart with leading lines
Posted on 2014-03-04
I am generating a pie chart using vba from MSAccess. With the best fit property setting, most of the labels are displayed outside of the pie chart. However, we still have to manually drag out those labels that are short enough to fit within the pie slice.
I would like to know how to iterate through each slice and determine which of the labels needs to be dragged away from the slice. Most importantly, I need to clearly display the leading lines connecting the labels to their respective slices.