|Check out our Excel Charting Resources|
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.
or the cell that you want it linked to.
(Also, TextBoxes can link to the worksheet...)
Juan Pablo G.
If you really want to link them to a worksheet
cell you can do that too. To link them to a
1. Click once on a label... pause, and click again.
You're now in editing mode.
2. Type = in the formula bar and click on the
cell that you want to link to the label.
Once linked you can explicitly control line
breaks using the CHAR worksheet function (e.g.,
="long"&CHAR(10)&"label") or by using the
Alt+Enter key combination while entering the
label (i.e., type "long"; press Alt+Enter;