 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Chart - Data Labels
Is it possible to change the width of the text box for 'Category Name' within the data label on a chart? I have Category Names which are very long and need to be 'word wrapped', but I cannot change the width of the text box or find a 'word wrap' option for this. Formatting is important as I also need to display the Value, so hard-coding the label is not an option Hi, Chart data labels are not sizable, even if the handles around them would suggest otherwise. You maybe able to get the breaks in the text you want at fixed places by using ALT+ENTER within the cells that contain the linked text. If you want complete control of formatting you need to use embedded textboxes. The drawback is that they will not automatically re position themselves is the data changes. Cheers Andy > Is it possible to change the width of the text box for 'Category Name' within > the data label on a chart? [quoted text clipped - 5 lines] > Formatting is important as I also need to display the Value, so hard-coding > the label is not an option |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.