Resize Pie Chart Data Labels
Posted by Dave Lindsay on January 30, 2002 7:55 AM
I want to have control over the width of my pie chart data labels in Excel 2000. I understand that these are not text boxes, and even though they have handles you don't seem to be able to resize them with the mouse. I am wondering if anyone can shed light on how Excel determines the initial size of the labels and how that might be controlled. I'm also interested in how to gain control over the positioning of line breaks in longer labels.
MS support told me to use text boxes, but of course those don't link up to the worksheet, so this is not a good option. I'm wondering if the size of the worksheet cells has any bearing on the size of the label's bounding boxes, or if adding line breaks in the worksheet cell will translate to a line break in the chart data label.
Any info is very much appreciated.