If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How change dimensions of data label text box in pie chart?
In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie
chart. I can change the font and allignment of the text within the text box. But, if the text defaults onto two or three lines, I cannot stretch the text box out to get the text to stay on one line. Normally, you can pull on the the little handles on the text box. Is there a trick to this that I don't know about? |
#2
|
|||
|
|||
This is a deficiency in Excel's charting capabilities. The text elements
seem like regular text boxes, but you are unable to resize or reshape them. Even VBA can't do this. The workaround is to add a real text box with the text you want. To add a static text box, select the chart, type the label, and press Enter. A text box appears in the middle of the chart, with the text you've typed. To add a text box that's linked to a cell, select the chart, press the equals key, then select the cell with the mouse. A text box appears in the middle of the chart, with the text from the cell you selected. Move the text box where you need it, and format it as desired. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Gouden Willem wrote: In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie chart. I can change the font and allignment of the text within the text box. But, if the text defaults onto two or three lines, I cannot stretch the text box out to get the text to stay on one line. Normally, you can pull on the the little handles on the text box. Is there a trick to this that I don't know about? |
#3
|
|||
|
|||
How change dimensions of data label text box in pie chart?
Hi John, thanks this mail helped
However i need to be able to stretch the text I type so it diplays clearly whn I copy the graph into powerpoint. Is there any way I can i can strech th text ? "Jon Peltier" wrote: This is a deficiency in Excel's charting capabilities. The text elements seem like regular text boxes, but you are unable to resize or reshape them. Even VBA can't do this. The workaround is to add a real text box with the text you want. To add a static text box, select the chart, type the label, and press Enter. A text box appears in the middle of the chart, with the text you've typed. To add a text box that's linked to a cell, select the chart, press the equals key, then select the cell with the mouse. A text box appears in the middle of the chart, with the text from the cell you selected. Move the text box where you need it, and format it as desired. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Gouden Willem wrote: In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie chart. I can change the font and allignment of the text within the text box. But, if the text defaults onto two or three lines, I cannot stretch the text box out to get the text to stay on one line. Normally, you can pull on the the little handles on the text box. Is there a trick to this that I don't know about? |
#4
|
|||
|
|||
How change dimensions of data label text box in pie chart?
As I said, No. You cannot change the size of the label. You must replace it
with a textbox. The textbox can be resized in the expected way. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "keen learner" wrote in message ... Hi John, thanks this mail helped However i need to be able to stretch the text I type so it diplays clearly whn I copy the graph into powerpoint. Is there any way I can i can strech th text ? "Jon Peltier" wrote: This is a deficiency in Excel's charting capabilities. The text elements seem like regular text boxes, but you are unable to resize or reshape them. Even VBA can't do this. The workaround is to add a real text box with the text you want. To add a static text box, select the chart, type the label, and press Enter. A text box appears in the middle of the chart, with the text you've typed. To add a text box that's linked to a cell, select the chart, press the equals key, then select the cell with the mouse. A text box appears in the middle of the chart, with the text from the cell you selected. Move the text box where you need it, and format it as desired. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Gouden Willem wrote: In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie chart. I can change the font and allignment of the text within the text box. But, if the text defaults onto two or three lines, I cannot stretch the text box out to get the text to stay on one line. Normally, you can pull on the the little handles on the text box. Is there a trick to this that I don't know about? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |