Archive of Mr Excel Message Board

Check out our Excel Charting Resources
Back to Charting for Excel archive index
Back to archive home



Resize Pie Chart Data Labels

Posted by Dave Lindsay on January 30, 2002 7:55 AM
Greetings.

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.

Dave


Re: Resize Pie Chart Data Labels

Posted by Juan Pablo G. on January 30, 2002 8:18 AM
One option. Draw a rectangle. Remove the border if any, and when it is selected, go to the formula bar and put

=Sheet1!A1

or the cell that you want it linked to.

(Also, TextBoxes can link to the worksheet...)

Juan Pablo G.


Re: Resize Pie Chart Data Labels

Posted by Mark W. on January 30, 2002 8:25 AM
Well, they're sort of text boxes... you can edit
them, but you can't resize them. Also, they're
not really linked to your worksheet cells
containing the label values. Since you can edit
them you could add your own line breaks.

If you really want to link them to a worksheet
cell you can do that too. To link them to a
cell...

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;
type "label").







This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.