Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) |