possiblity to set data label in bar chart to "no wrap"??
hey,
is there a possibility to display the data label in one line (- NO WRAP) the label position is "inside base" and the label should just NOT wrap (but it automatically does :( ) can someone point me in the right direction? thanks, Rhapsy |
possiblity to set data label in bar chart to "no wrap"??
Hi,
The warp is automatically decided by xl. Font size is the only control you have but even reducing the size may not stop wrapping. You can add textboxes to the chart and link the content to a cell but the position of the box will not update with changes in underlying data. To add textbox select chart and in formula bar enter cell reference including sheet name. So for textbox linked to A1 in sheet1 type =Sheet1!A1 Cheers Andy Rhapsody wrote: hey, is there a possibility to display the data label in one line (- NO WRAP) the label position is "inside base" and the label should just NOT wrap (but it automatically does :( ) can someone point me in the right direction? thanks, Rhapsy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 10:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com