View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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